ABCDEFGHIJKLMNOPQRSTUVW
1
Quiz score dataCompany age data sets
2
xdeviations: x - musquared deviations: (x - mu)^2x^2Company 1Company 2
3
824644770
4
3-3993839
5
2-41643618
6
711494046
7
104161003727
8
9398142
9
1041610038
10
0-636042
11
93981
12
82464
13
3-399Sigma x =320200
14
2-4164N =85
15
5-1125Mean mu =4040
16
4-2416
17
10416100
18
19
Sigma x =90sum of squares SS_x =166706
20
N =15
21
Mean mu =6variance sigma^2 =11.07sample var11.85714286
22
standard deviation sigma =3.33sample std dev3.443420227
23
24
Check: mean mu directly via "average" function:6Check: std dev directly via "stdevp" function:3.33Check using "var"11.85714286
25
check using "stdev"3.443420227
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
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