Question

Use the heights from the SCC data to answer the following questions. Men are to use the male data, and women are to use the female data (only answer the questions for ONE set of data, not both).

2. State the following for the SCC sample male heights.

a. Sample size (n)

b. Sample mean (?̅)

c. Sample standard deviation (s

male Student # Gender Height Shoe Age Hand

1 M 67 10 19 R

2 M 74 12 17 R

3 M 72 11.5 19 R

4 M 69 10 35 R

5 M 66 9 18 R

6 M 71 10.5 17 R

7 M 72 10.5 17 R

8 M 66 10 20 R

9 M 67 10 18 R

10 M 71 10.5 24 R

11 M 66 10 21 R

12 M 71 10.5 18 R

13 M 69 10 22 R

14 M 66 9.5 18 L

15 M 76 14 18 R

16 M 69 11 22 R

17 M 68 9 19 R

18 M 70 12 30 R

19 M 67 10 24 R

20 M 70 11 21 R

21 M 70 10 52 R

22 M 63 9 27 R

23 M 69 11 22 R

24 M 72 10 22 R

25 M 76 11.5 20 L

26 M 75 11 17 R

27 M 72 11 50 L

28 M 69 11 20 R

29 M 70 12 20 R

30 M 69 11.5 23 R

31 M 70 11 18 R

32 M 67 10 21 R

33 M 68 11 44 R

34 M 76 13 48 R

35 M 62 8 23 L

36 M 69 9 19 R

37 M 72 10 60 R

38 M 73 11.5 41 R

39 M 70 9.5 39 R

40 M 78 15 24 R

41 M 65 8.5 23 R

42 M 68 9.5 20 R

Answer 1

a) sample size(n)= 42

There are 42 samples/records overall

b)sample mean(?̅)= sum of all male student's hights/No of male students= 2930/42= 69.76

c)Sample standard deviation

The Standard Deviation(σ) is a measure of how spread out numbers are.

σ=

Variance  

where ?̅= mean= 69.76

n= no of samples= 42

Variance is the average of the squared differences from the Mean.

Student #	Height(xi)	xi-mean	(xi-mean)^2
1	67	-2.7619	7.628117914
2	74	4.238095	17.96145125
3	72	2.238095	5.009070295
4	69	-0.7619	0.580498866
5	66	-3.7619	14.15192744
6	71	1.238095	1.532879819
7	72	2.238095	5.009070295
8	66	-3.7619	14.15192744
9	67	-2.7619	7.628117914
10	71	1.238095	1.532879819
11	66	-3.7619	14.15192744
12	71	1.238095	1.532879819
13	69	-0.7619	0.580498866
14	66	-3.7619	14.15192744
15	76	6.238095	38.9138322
16	69	-0.7619	0.580498866
17	68	-1.7619	3.10430839
18	70	0.238095	0.056689342
19	67	-2.7619	7.628117914
20	70	0.238095	0.056689342
21	70	0.238095	0.056689342
22	63	-6.7619	45.72335601
23	69	-0.7619	0.580498866
24	72	2.238095	5.009070295
25	76	6.238095	38.9138322
26	75	5.238095	27.43764172
27	72	2.238095	5.009070295
28	69	-0.7619	0.580498866
29	70	0.238095	0.056689342
30	69	-0.7619	0.580498866
31	70	0.238095	0.056689342
32	67	-2.7619	7.628117914
33	68	-1.7619	3.10430839
34	76	6.238095	38.9138322
35	62	-7.7619	60.24716553
36	69	-0.7619	0.580498866
37	72	2.238095	5.009070295
38	73	3.238095	10.48526077
39	70	0.238095	0.056689342
40	78	8.238095	67.86621315
41	65	-4.7619	22.67573696
42	68	-1.7619	3.10430839
Mean	69.7619		Variance=(xi-mean)^2)/41= 12.18583043
Standard Deviation		=3.490820882

Variance for the hights calculated using excel= 12.18583

Standard Deviation= 3.490820882