ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Distance Traveled on Carpet (cm)
2
Track Height (cm)203040
3
Trial 14597126
4
Trial 24480131
5
Trial 34794136
6
Trial 44287127
7
Trial 544101121
8
Trial 6
9
Trial 7
10
Trial 8
11
Trial 9
12
Trial 10
13
Trial 11
14
Trial 12
15
Trial 13
16
Trial 14
17
Trial 15
18
Trial 16
19
Trial 17
20
Trial 18
21
Trial 19
22
Trial 20Directions for Data Entry: Where indicated, enter in the dependent and independent variables with
23
Trial 21
units. Then enter the settings or values for the independent variable across row 2.
24
Trial 22
Next, enter the values of the dependent variable trials measured under each setting.
25
Trial 23
You can enter as many trials as there is space for in the table. The 1's in row 3 are there as placeholders
26
Trial 24
and should be replaced immediately with your actual data or deleted if you did not use all 7 settings
27
Trial 25
for your independent variable.
28
Trial 26
29
Trial 27
Only enter a number for your data without units otherwise the program will not recognize it as a number.
30
Trial 28
31
Trial 29
32
Trial 30
33
34
Data Summary
35
203040
36
Mean (Average)44.491.8128.2#DIV/0!#DIV/0!#DIV/0!#DIV/0!
37
Standard Deviation (𝞼)1.88.35.6#DIV/0!#DIV/0!#DIV/0!#DIV/0!
38
Mean + 1𝞼46.2100.1133.8#DIV/0!#DIV/0!#DIV/0!#DIV/0!68% of values fall between
39
Mean - 1𝞼42.683.5122.6#DIV/0!#DIV/0!#DIV/0!#DIV/0!
40
Mean + 2𝞼48.0108.5139.5#DIV/0!#DIV/0!#DIV/0!#DIV/0!95% of values fall between
41
Mean - 2𝞼40.875.1116.9#DIV/0!#DIV/0!#DIV/0!#DIV/0!
42
Mean + 3𝞼49.8116.8145.1#DIV/0!#DIV/0!#DIV/0!#DIV/0!highly unlikely to find a value greater or lower than these
43
Mean - 3𝞼39.066.8111.3#DIV/0!#DIV/0!#DIV/0!#DIV/0!
44
Standard Error0.83.72.5#DIV/0!#DIV/0!#DIV/0!#DIV/0!
45
46
47
48
Track Height (cm)Mean Distance Traveled on Carpet (cm)Standard Error
49
2044.40.8
50
3091.83.7
51
40128.22.5
52
#DIV/0!#DIV/0!
53
#DIV/0!#DIV/0!
54
#DIV/0!#DIV/0!
55
#DIV/0!#DIV/0!
56
57
58
59
60
61
62
63
64
65
You must update the constant value used for the Standard Error manually. They are set to 10 by default. To do this, double click on the graph above to bring up the Chart editor options to the right. Then, click on Series, click on Apply to all series dropdown menu, select the Data series one at a time, scroll down to where the Error bars is check and update the constant Value to match your calculated Standard Errors from I49 through I55.
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100