Past enrollment data indicates that 58% of the students taking Elements of Statistics online at FHSU come from families of size four or larger. Is the enrollment in this semester's online class significantly different from this claim, as measured statistically? Justify your answer through a formal hypothesis testing procedure with a 1% level of significance. After typing out a) and b) below, use scratch paper to identify all variables from the given information using the correct symbols (s, , , x-bar, n, p, , etc.), then go to the templates tab in the Unit 3 Excel Guide (part 1) and determine which template to use, based on the claim in the problem. Copy and paste the entire template (including title) to the right of the problem using the instructions in the blue-shaded area above. Use cell references from the completed template to answer parts c) - g). Next, give the conclusion of your hypothesis test (choose "reject the null hypothesis" or "fail to reject the null hypothesis") based on the test statistic and the p-value and explain why you chose your conclusion. Finally, give an interpretive sentence. Follow examples given in the Unit 3 Excel Guide for correct wording.

	PROVIDE THE FOLLOWING INFORMATION. FOR EACH STATISTIC, USE A CELL REFERENCE FROM YOUR TEMPLATE:
	a)		H0:
	b)		H1:
	c)		Sample proportion (p-hat):
	d)		Critical Value:
	e)		Sample's Test Statistic:
	f)		P-value:
	CONCLUSION OF HYPOTHESIS TEST BASED ON TEST STATISTIC AND P-VALUE AND EXPLAIN WHY:
	FINAL INTERPRETIVE SENTENCE:

1	Female	25.5	145.0	34	143.0	4	Brown
2	Female	24.5	180.0	41	184.5	4	Red
3	Female	23.5	161.5	29	161.5	3	Brown
4	Female	24.5	160.0	48	161.5	8	Brown
5	Female	24.0	170.0	36	172.0	5	Brown
6	Male	27.0	183.0	27	182.0	4	Brown
7	Female	25.5	174.0	45	171.5	3	Brown
8	Male	26.5	172.5	21	172.5	5	Red
9	Female	25.5	142.0	23	142.0	5	Brown
10	Male	26.5	180.0	23	180.0	4	Brown
11	Male	25.0	172.5	51	179.0	10	Brown
12	Male	23.0	182.5	21	180.0	3	Black
13	Female	22.5	159.0	29	160.0	9	Blonde
14	Male	25.5	168.0	28	166.5	5	Brown
15	Female	23.0	159.0	33	157.5	4	Brown
16	Female	23.0	160.0	23	156.0	3	Brown
17	Male	26.0	179.0	41	184.0	5	Brown
18	Male	28.0	189.0	28	187.0	4	Brown
19	Female	23.0	162.5	37	163.0	6	Brown
20	Female	23.0	181.0	24	174.0	7	Red
21	Female	20.0	160.0	20	160.0	5	Brown
22	Female	22.0	157.5	34	162.0	2	Brown
23	Female	23.5	169.0	27	169.0	5	Red
24	Male	26.0	173.0	22	170.0	4	Brown
25	Female	24.0	162.5	27	164.5	4	Blonde
26	Female	26.5	152.5	38	157.5	7	Brown
27	Female	23.0	163.0	32	165.0	2	Brown
28	Female	25.0	167.5	32	165.0	3	Brown
29	Female	24.5	157.5	26	155.0	3	Brown
30	Female	25.5	171.0	37	167.5	12	Blonde
31	Female	21.5	157.5	34	158.0	5	Brown
32	Female	25.5	165.0	19	169.0	7	Brown
33	Female	25.5	170.0	24	168.0	4	Purple
34	Female	21.0	167.0	24	167.0	4	Black
35	Female	24.0	170.0	20	170.0	3	Blonde
36	Male	29.5	188.0	34	189.5	4	Blonde
37	Female	25.0	177.0	41	173.0	5	Blonde
38	Male	30.0	185.5	31	185.5	1	Black
39	Male	26.5	179.5	31	177.5	3	Brown
40	Female	25.0	170.0	45	168.0	3	Blonde
41	Male	28.0	187.0	21	188.0	7	Black
42	Female	23.0	163.0	28	164.0	3	Red
43	Male	24.5	181.0	38	183.0	4	Brown
44	Female	23.5	166.5	29	169.5	2	Brown
45	Male	24.5	178.0	34	176.5	2	Brown
46	Female	24.0	167.0	18	167.0	3	Brown
47	Female	24.0	186.0	50	183.5	4	Brown
48	Female	25.5	171.5	24	171.0	5	Brown
49	Female	25.0	181.5	25	179.5	6	Black
50	Male	25.5	177.5	39	175.0	4	Black
51	Female	25.0	169.0	19	170.0	3	Red
52	Female	24.0	172.5	22	173.5	2	Blonde
53	Male	29.0	188.0	29	196.0	4	Brown
54	Male	26.5	169.0	25	172.0	5	Brown
55	Female	24.0	160.0	25	160.0	6	Brown
56	Female	26.0	170.0	37	168.0	6	Blonde
57	Female	22.5	155.0	27	153.0	4	Brown
58	Female	23.0	155.0	20	157.5	4	Brown
59	Female	24.0	162.5	23	160.0	6	Black
60	Female	23.0	170.0	21	171.0	5	Blonde
61	Male	28.0	183.0	28	180.0	4	Brown
62	Female	23.0	154.0	33	154.0	4	Brown
63	Male	27.0	172.5	18	173.0	7	Brown
64	Female	20.0	160.0	31	165.0	5	Blonde
65	Male	26.5	172.5	21	175.5	5	Brown
66	Female	23.0	159.0	19	160.0	4	Brown
67	Male	25.0	168.0	25	170.0	3	Black
68	Male	28.0	170.5	36	178.0	2	Black
69	Female	22.0	160.0	49	156.0	8	Red
70	Female	28.5	161.5	41	157.0	2	Blonde
71	Male	26.0	175.0	20	179.5	4	Brown
72	Female	23.0	156.0	22	160.0	3	Blonde
73	Male	25.0	175.0	27	177.0	4	Brown
74	Male	27.5	184.0	18	191.5	4	Blonde
75	Female	23.0	161.0	25	165.0	8	Blonde
76	Female	24.0	160.0	27	158.0	4	Brown
77	Female	25.5	164.0	25	172.5	11	Brown
78	Male	26.0	178.0	48	180.0	4	Brown
79	Male	28.0	186.0	21	183.0	5	Brown
80	Female	23.0	161.0	26	161.5	4	Brown
81	Male	23.5	162.5	42	162.5	4	Blonde
82	Female	27.0	169.0	31	170.0	1	Brown
83	Female	23.5	165.0	28	165.0	1	Blonde
84	Male	28.0	180.0	25	172.0	5	Red
85	Female	25.5	176.0	21	172.0	9	Blonde
86	Male	25.5	183.0	18	186.0	3	Brown
87	Female	26.0	171.0	25	172.0	12	Brown
88	Female	24.0	175.5	38	176.0	6	Blonde
89	Female	22.0	165.0	27	167.0	11	Brown
90	Male	28.0	175.0	39	182.0	3	Black
91	Male	28.0	188.0	33	189.0	7	Brown
92	Female	24.0	167.5	18	163.5	5	Blonde
93	Female	20.5	167.5	36	153.5	5	Black
94	Female	22.0	171.0	19	174.0	4	Red
95	Male	26.0	180.5	28	180.5	5	Brown
96	Female	25.0	167.5	22	165.0	3	Brown
97	Female	25.5	154.0	23	155.5	7	Brown
98	Female	21.0	158.0	25	157.0	2	Brown