1. Set up the euqrientment.
.jpeg)
2.Record the date.
3. Date analysis.
Open an excel file.
In cell A1 enter Time. In cell A2 enter 0.In cell A3 enter =A2=1/60. if you highlight cell A3 and several cells below that, then choose the Edit/ Fill/ Down menu EWxcel automatically fill the cells below.
Choose a bot to be your t=0s dot.
In cell B1 enter Distance. In cell B2 enter0. In cell B3 enter the position of 2nd dot from your spark tape. Enter the rest of the dot positions in cell B4,B5,ect.
In cell C1 enter delta x. In cell C2 enter=(B3-B2). Fill down this to the cells below this on.
In cell D1 enter Mid- interval time. In cell D2 enter =A2=1/120. fill down
In cell E1 enter Mid interval speed. In cell E2 enter =(C2/(1/60)).
Dart we got form our spark tape.
4. Graphing Data
Select your data in columns D and E. Click on the Chart Wizard on the top toolbar to start making the graph. Choose an SY(scatter) graph with the points NOT connected.Give appropriate titles (with units) for your graph and graph axes.place the chart as a new sheet.
under the chart menu sellect Add Trenline, choose Linear. Under the Pitions tab you click "OK" this should give you a line and equation on the graph.
Double click on the equtaion. Use the Nuberes formatting to get a reasonable number of decimal places in your answers. Use the Font menu to make the equtaion large enough that it will show up nicely when you print your graph.
Select Colums A and B. follow the same setps above Except when you get to Add Trendline choose a polymonial fit of order 2.
Linear fit for Mid-interval speed
Find out the g=9.296m/s^2
Plymonial fit for Distancce VS. time
.jpeg)
We have unexplained spread in our data. All of our values are too low. systematic error.
No comments:
Post a Comment