A group of students performed the Pendulum experiment and theyobtained the following results:
L (cm) T (s)
50 1.42
72 1.70
85 1.85
106 2.06
125 2.24
(a) Use Excel to construct a spreadsheet to do the following. (Youwill not submit this spreadsheet. However, the results will beneeded later in this problem.)
(i) Enter the above data.
(ii) Create a graph of L vs. T2.
(iii) Use Excel's trendline to plot a best-fit line through thedata. Make sure the equation to the trendline is clearly visible onyour graph.
(vi) Use the LINEST function in Excel to determine the slope andits uncertainty.
(b) Record your values below.
slope = ±
(c) What is the formula for the uncertainty in g in terms of theuncertainty in the slope Ïs?
Ïg =
(d) From your value of the slope determine g the acceleration dueto gravity.
g = ±
(e) If you had plotted
sqrt(L) vs. T
instead, what would the slope be? (Use any variable or symbolstated above as necessary.)
slope =
I can do up to B, but I don't know how to do the rest!
A group of students performed the Pendulum experiment and theyobtained the following results:
L (cm) T (s)
50 1.42
72 1.70
85 1.85
106 2.06
125 2.24
(a) Use Excel to construct a spreadsheet to do the following. (Youwill not submit this spreadsheet. However, the results will beneeded later in this problem.)
(i) Enter the above data.
(ii) Create a graph of L vs. T2.
(iii) Use Excel's trendline to plot a best-fit line through thedata. Make sure the equation to the trendline is clearly visible onyour graph.
(vi) Use the LINEST function in Excel to determine the slope andits uncertainty.
(b) Record your values below.
slope = ±
(c) What is the formula for the uncertainty in g in terms of theuncertainty in the slope Ïs?
Ïg =
(d) From your value of the slope determine g the acceleration dueto gravity.
g = ±
(e) If you had plotted
sqrt(L) vs. T
instead, what would the slope be? (Use any variable or symbolstated above as necessary.)
slope =
I can do up to B, but I don't know how to do the rest!
