Physical Science 9 Assignment #3

Use the data here to do the following:
  1. Click on the link above to open the Excel file that has the data from the "acceleration due to gravity" lab we did on Friday. (If it does not open in Excel use right click, save it and then open it.) Look at the data and tell me what you notice about the difference between the consecutive (next to each other) position values as you move down the table. What does this mean in terms of the motion of the falling mass?
  2. To complete the calculations from the data for the third column do the following: in cell C2 type the equation =0.014*B2. Then, copy and paste the contents of cell C2 into the cells of the rest of the column. Are the values in this column what you expect? (Try figuring some out by calculator and see if you agree with the results.) Explain what you have just done.
  3. To complete the calculations from the data for the fourth column do the following: in cell D2 type the equation =A2/100. Then, copy and paste the contents of cell D2 into the cells of the rest of the column. Are the results as expected?
  4. To complete the calculations from the data for the fourth column do the following: in cell E2 type the equation =4.9*C2*C2. Then, copy and paste the contents of cell E2 into the cells of the rest of the column. Are the results as expected?
  5. Highlight the numbers in column 3, 4 and 5 and click on the Chart icon (it looks like a bar graph on the tool bar). Then, click on XY (scatterplot) followed by Next and then Series. Give Series 1 the name "Measured Position" and Series 2 the name "Theoretical Position." Click Next again and then add a title and axes labels. (Use: Position vs Time, Time (s) and Position (m) for this.) Clcik Next and choose a New Sheet. Now Click Finish.
  6. You have just produced a graph of the data from the lab! Have me check it to make sure it is ok and I will show you how to get rid of the gray background so you can print it. How do the two graphs compare? Do you think the experiment and prediction are in good agreement?
  7. You should try graphing one of the sets of data by hand on a full sheet of paper. Compare your graph by hand to the one generated by Excel.
Hosted by www.Geocities.ws

1