SHM of spring – M6
No. of Mass, Position, osc. Data No. m / g x / mm N 1 105.400 31.5 20 2 203.510 46.0 20 3 303.090 66.0 20 4 203.510 56.0 20 5 403.900 77.6 20 6 403.900 90.0 20 7 155.350 50.0 20 8 256.590 60.0 20 9 354.540 70.0 20 10 11 12 unc. of position, dx Exclude (Y / N) Extremes?n
Record the data in the coloured k 1 sections. The spreadsheet is programmed to complete the DA for you in the grey sections (these cells therefore cannot be edited). To make a graph, copy the data columns. Use EDIT\PASTE SPECIAL\VALUES to transfer data to the graph plotting spreadsheet.
Repeated Readings T1 15.35 21.28 25.68 21.46 29.33 29.94 18.66 23.91 28.01 T2 15.42 21.29 25.98 21.35 29.89 29.71 17.71 24.06 28.14 T3 15.38 21.27 25.92 21.29 28.65 30.07 18.62 24.00 27.96 T4 15.33 21.32 24.64 21.23 28.30 29.93 17.73 23.98 27.96 T5 15.35 21.29 25.97 21.46 28.48 29.89 18.55 23.87 28.05 T6 T7 T8 T9 T10
No. of repeats n 5 5 5 5 5 5 5 5 5 0 0 0
Mean Time TN / s 15.37 21.29 25.64 21.36 28.93 29.91 18.25 23.96 28.02
Unc. Time Unc. % Unc. Time2 % Unc. Unc. in TN of 1 osc in T1 in T1 of 1 osc in T12 in T12 dTN / s T1 / s dT1 / s dT1 % T12 / s2 dT12 % dT12 / s2 0.02 0.768 0.001 0.1% 0.5903 0.3% 0.0015 0.01 1.065 0.001 0.1% 1.1332 0.1% 0.0012 0.30 1.282 0.015 1.2% 1.6433 2.3% 0.0384 0.05 1.068 0.003 0.2% 1.1404 0.5% 0.0055 0.36 1.447 0.018 1.2% 2.0924 2.5% 0.0514 0.08 1.495 0.004 0.3% 2.2362 0.5% 0.0120 0.21 0.913 0.011 1.2% 0.8330 2.3% 0.0194 0.04 1.198 0.002 0.2% 1.4357 0.4% 0.0051 0.04 1.401 0.002 0.1% 1.9634 0.3% 0.0056