PHYSICS EXCEL HELP

Question

TIME POSITION Y/T (CM/S)

0/60 0 125

1/60 2.08 125

2/60. 4.4 132

3/60. 7.05 141

4/60. 9.93 149

5/60. 13.08 157

6/60. 16.6 166

7/60. 20.24 173

8/60. 24.13 181

9/60. 28.51 190

- Determine the linear correlation coefficients, R2, for both the y vs. t data and the y/t vs. t data. (Both to four decimal places.)

For y vs. t, ____________ For y/t vs. t, ____________

-Using the linearized relationship, y/t vs. t, report the properly rounded best estimate for 𝑔. (𝑔𝑎𝑐𝑐 = 980.35 𝑐𝑚/𝑠)

𝒈 =

%DIFF =

Answer 1

Marissa

If you are using Excel, you should be able to use the following functions to get your answers.

1. CORREL: It needs the Independent Variable values in one column and Dependent Variable values in the other to determine a correlation coefficient. You should be able to run this calculation for both Y vs T, and Y/T vs T. Using your dataset, I obtained

R2 = 0.9941 for Y-vs-T

R2 = 0.9949 for Y/T-vs-T

1. LINEST: This function returns the slope of a linear fit to the data, y = mx + C. Notice that slope of Y/T-vs-T gives you the acceleration g you are asked to calculate (i.e., rate of change of speed, ΔV/ΔT, where V = Y/T).

This function gives a value, acceleration, g = 460.

1. You can now calculate the %difference w.r.t. g_acc

_{P.S. I have assumed that the time data is in fractions of a second (i.e. 1/60 s, 2/60 s, etc). If your data is different from my interpretation, you will get a different answer).}