trial# distance time x^2 xy y^2 (y-y')^2 David
1 17.2 =SQRT(B2*0.02/9.81) =A2^2 =A2*C2 =C2^2 =(C2-$C$45)^2 0.155 =K2+0.0083 =L2+0.0083 =M2+0.0083 =N2+0.0083 =O2+0.0083 =P2+0.0083 =Q2+0.0083 =R2+0.0083 =S2+0.0083 =T2+0.0083
2 16.2 =SQRT(B3*0.02/9.81) =A3^2 =A3*C3 =C3^2 =(C3-$C$45)^2 Sample Calculation 6 5 7 10 5 3 1 1
3 11.8 =SQRT(B4*0.02/9.81) =A4^2 =A4*C4 =C4^2 =(C4-$C$45)^2 6 5 7 10 5 3
4 16.4 =SQRT(B5*0.02/9.81) =A5^2 =A5*C5 =C5^2 =(C5-$C$45)^2 Results 6 5 7 10 5 3
5 17.6 =SQRT(B6*0.02/9.81) =A6^2 =A6*C6 =C6^2 =(C6-$C$45)^2 6 5 7 10 5
6 13.5 =SQRT(B7*0.02/9.81) =A7^2 =A7*C7 =C7^2 =(C7-$C$45)^2 6 5 7 10 5
7 16 =SQRT(B8*0.02/9.81) =A8^2 =A8*C8 =C8^2 =(C8-$C$45)^2 6 7 10
8 12.6 =SQRT(B9*0.02/9.81) =A9^2 =A9*C9 =C9^2 =(C9-$C$45)^2 7 10
9 13.6 =SQRT(B10*0.02/9.81) =A10^2 =A10*C10 =C10^2 =(C10-$C$45)^2 10
10 19.6 =SQRT(B11*0.02/9.81) =A11^2 =A11*C11 =C11^2 =(C11-$C$45)^2 10
11 12.2 =SQRT(B12*0.02/9.81) =A12^2 =A12*C12 =C12^2 =(C12-$C$45)^2 10
12 15.7 =SQRT(B13*0.02/9.81) =A13^2 =A13*C13 =C13^2 =(C13-$C$45)^2 =(K2+L2)/2 =(L2+M2)/2 =(M2+N2)/2 =(N2+O2)/2 =(O2+P2)/2 =(P2+Q2)/2 =(Q2+R2)/2 =(R2+S2)/2 =(S2+T2)/2 =(T2+U2)/2
13 15.2 =SQRT(B14*0.02/9.81) =A14^2 =A14*C14 =C14^2 =(C14-$C$45)^2 6 5 7 10 5 3 1 1
14 16.2 =SQRT(B15*0.02/9.81) =A15^2 =A15*C15 =C15^2 =(C15-$C$45)^2 1 2 3 4 5 6 7 8 9 10
15 13.5 =SQRT(B16*0.02/9.81) =A16^2 =A16*C16 =C16^2 =(C16-$C$45)^2
16 18.3 =SQRT(B17*0.02/9.81) =A17^2 =A17*C17 =C17^2 =(C17-$C$45)^2 0.146 =K17+0.0092 =L17+0.0092 =M17+0.0092 =N17+0.0092 =O17+0.0092 =P17+0.0092 =Q17+0.0092 =R17+0.0092 =S17+0.0092 =T17+0.0092
17 27.8 =SQRT(B18*0.02/9.81) =A18^2 =A18*C18 =C18^2 =(C18-$C$45)^2
18 16.5 =SQRT(B19*0.02/9.81) =A19^2 =A19*C19 =C19^2 =(C19-$C$45)^2 5 6 7 8 6 4 2 0 1 1 Vicki
19 20.1 =SQRT(B20*0.02/9.81) =A20^2 =A20*C20 =C20^2 =(C20-$C$45)^2 1 5 5 11 8 4 2 1 0 1 David
20 18.9 =SQRT(B21*0.02/9.81) =A21^2 =A21*C21 =C21^2 =(C21-$C$45)^2 =(K17+L17)/2 =(L17+M17)/2 =(M17+N17)/2 =(N17+O17)/2 =(O17+P17)/2 =(P17+Q17)/2 =(Q17+R17)/2 =(R17+S17)/2 =(S17+T17)/2 =(T17+U17)/2
21 16.2 =SQRT(B22*0.02/9.81) =A22^2 =A22*C22 =C22^2 =(C22-$C$45)^2
22 15.4 =SQRT(B23*0.02/9.81) =A23^2 =A23*C23 =C23^2 =(C23-$C$45)^2
23 18.4 =SQRT(B24*0.02/9.81) =A24^2 =A24*C24 =C24^2 =(C24-$C$45)^2
24 14 =SQRT(B25*0.02/9.81) =A25^2 =A25*C25 =C25^2 =(C25-$C$45)^2
25 14.8 =SQRT(B26*0.02/9.81) =A26^2 =A26*C26 =C26^2 =(C26-$C$45)^2
26 20.3 =SQRT(B27*0.02/9.81) =A27^2 =A27*C27 =C27^2 =(C27-$C$45)^2
27 14.1 =SQRT(B28*0.02/9.81) =A28^2 =A28*C28 =C28^2 =(C28-$C$45)^2
28 22.4 =SQRT(B29*0.02/9.81) =A29^2 =A29*C29 =C29^2 =(C29-$C$45)^2
29 16.9 =SQRT(B30*0.02/9.81) =A30^2 =A30*C30 =C30^2 =(C30-$C$45)^2
31 14.8 =SQRT(B31*0.02/9.81) =A31^2 =A31*C31 =C31^2 =(C31-$C$45)^2
33 17.4 =SQRT(B32*0.02/9.81) =A32^2 =A32*C32 =C32^2 =(C32-$C$45)^2
34 12.9 =SQRT(B33*0.02/9.81) =A33^2 =A33*C33 =C33^2 =(C33-$C$45)^2
35 17 =SQRT(B34*0.02/9.81) =A34^2 =A34*C34 =C34^2 =(C34-$C$45)^2
36 17.9 =SQRT(B35*0.02/9.81) =A35^2 =A35*C35 =C35^2 =(C35-$C$45)^2
37 12.7 =SQRT(B36*0.02/9.81) =A36^2 =A36*C36 =C36^2 =(C36-$C$45)^2
38 15.6 =SQRT(B37*0.02/9.81) =A37^2 =A37*C37 =C37^2 =(C37-$C$45)^2
39 14.8 =SQRT(B38*0.02/9.81) =A38^2 =A38*C38 =C38^2 =(C38-$C$45)^2
40 13.1 =SQRT(B39*0.02/9.81) =A39^2 =A39*C39 =C39^2 =(C39-$C$45)^2
=A40^2 =A40*C40 =C40^2
=A41^2 =A41*C41 =C41^2
=SUM(A2:A41) =SUM(C2:C41) =SUM(D2:D41) =SUM(E2:E41) =SUM(F2:F41) =SUM(G2:G41)
=D42-A42^2/C44 =E42-A42*C42/C44 =F42-C42^2/C44
n = 38
mean = =AVERAGE(C2:C39)
stdev = =STDEVP(C2:C39)
slope = =E43/D43 =F43-C47*E43
variance= =C49^2 =D47/(C44-2)
stdev = =SQRT(G42/($C$44-1)) =SQRT(D48)
30 out =SQRT(B51*0.02/9.81)
32 out =SQRT(B52*0.02/9.81)