Using excel

It has been claimed that the mean height of adults in the U.S. is more than 166 cm. Does the data of our statistics class support or contradict this claim? Justify your answer through a formal hypothesis testing procedure with a P-value approach using a significance level of your choice. Calculation of and interpretation based on the P-value is required in this problem. You will choose your own level of significance. After typing out a) and b), 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. 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 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.
a)		H0:
b)		H1:
c)		Sample's Mean (x-bar):
d)		Sample's S.D. (s):
e)		Sample's Test Statistic:
f)		P-value:
CONCLUSION OF HYPOTHESIS TEST BASED ON P-VALUE AND EXPLAIN WHY:
FINAL INTERPRETIVE SENTENCE:

MATH 250- Elements of Statistics
Class Data, Spring 2021---CLEANED Student Data--ID# Renumbered
Individual ID#	Gender	Foot Length	Height	Age	Armspan	Number in Family	Hair Color
1	Female	24.5	157.5	20	158.0	5	Blonde
2	Female	21.0	163.0	43	158.5	6	Blonde
3	Female	26.5	167.0	27	170.0	3	Brown
4	Female	22.5	170.0	55	159.0	6	Blonde
5	Male	30.5	183.5	40	188.5	4	Black
6	Female	24.5	161.0	19	159.0	4	Brown
7	Male	25.0	174.5	43	180.0	3	Blonde
8	Female	22.0	159.5	54	155.0	4	Brown
9	Female	25.0	167.0	29	160.0	4	Black
10	Male	27.0	179.0	39	180.5	8	Black
11	Female	27.0	180.0	32	188.5	4	Brown
12	Female	24.5	166.5	30	172.5	6	Brown
13	Male	26.5	180.0	34	178.0	2	Brown
14	Female	21.0	163.0	43	158.5	6	Blonde
15	Male	26.0	185.0	18	185.6	5	Blonde
16	Female	22.5	158.0	22	155.0	3	Blonde
17	Female	23.5	161.5	30	157.5	5	Brown
18	Female	22.5	163.5	22	161.5	6	Brown
19	Female	23.5	165.0	22	162.0	5	Brown
20	Female	23.5	176.5	25	159.0	3	Brown
21	Male	25.0	172.5	21	177.5	2	Blonde
22	Female	24.0	152.5	38	155.0	5	Brown
23	Female	24.0	164.0	27	170.0	6	Brown
24	Male	29.0	188.0	32	175.0	4	Brown
25	Female	23.0	170.0	21	178.0	3	Brown
26	Female	24.0	162.5	21	162.5	6	Brown
27	Female	24.5	170.0	39	162.0	1	Blonde
28	Female	23.5	152.5	26	154.0	3	Brown
29	Female	24.0	170.0	20	177.5	6	Brown
30	Female	25.5	156.0	47	171.5	8	Brown
31	Female	23.5	162.0	32	162.0	2	Brown
32	Female	24.0	161.5	45	148.0	7	Red
33	Female	27.0	163.0	39	159.0	7	Black
34	Female	25.0	164.0	34	166.0	7	Brown
35	Male	29.0	173.0	47	171.0	3	Brown
36	Male	23.0	173.0	37	174.0	4	Brown
37	Female	22.5	166.0	26	166.5	2	Brown
38	Male	26.5	183.0	32	185.0	3	Black
39	Female	26.0	179.0	22	181.0	3	Blonde
40	Female	26.0	168.0	20	162.0	7	Brown
41	Male	30.5	182.0	30	195.5	4	Red
42	Female	23.0	167.0	32	163.0	5	Brown
43	Male	24.5	172.0	42	172.0	3	Brown
44	Female	23.0	164.0	40	162.5	4	Brown
45	Female	26.5	170.0	28	170.0	3	Brown
46	Female	26.5	167.5	33	167.5	2	Brown
47	Male	27.0	171.5	21	181.0	4	Brown
48	Male	28.0	188.0	20	190.0	4	Brown
49	Female	25.5	168.0	29	167.0	2	Brown
50	Male	25.0	168.0	28	170.5	6	Brown
51	Female	23.0	157.5	37	142.0	4	Brown
52	Male	27.0	178	20	183.0	4	Brown
53	Female	24.0	166.5	48	162.5	4	Brown
54	Female	24.0	170.0	43	164.0	3	Brown
55	Male	26.0	178.0	25	178.0	3	Black
56	Female	25.0	166.0	22	176.0	4	Blonde
57	Female	24.0	157.5	40	150.0	5	Blonde
58	Male	25.5	176.0	49	176.0	4	Blonde
59	Male	24.0	167.0	30	167.0	2	Black
60	Male	26.5	174.0	19	176.0	3	Black
61	Female	21.5	163.0	23	170.0	2	Blonde
62	Female	20.0	160.0	27	159.0	2	Blonde
63	Female	26.0	169.0	20	169.0	3	Blonde
64	Female	23.0	168.5	20	172.5	3	Blonde
65	Male	27.0	178.0	21	177.0	3	Blonde
66	Female	23.5	152.5	24	146.0	3	Blonde
67	Female	23.0	162.5	32	153.0	4	Blonde
68	Male	28.0	188.0	28	188.0	3	Brown
69	Male	28.0	175.0	23	180.0	3	Brown
70	Male	26.5	183.0	22	183.0	3	Brown
71	Male	27.0	178.0	21	183.0	3	Brown
72	Female	24.0	162.0	50	162.0	4	Brown
73	Female	25.0	174.0	21	176.0	4	Brown
74	Female	24.0	167.0	23	170.0	4	Brown
75	Female	23.0	167.5	33	167.5	5	Brown
76	Male	30.0	164.0	20	178.0	4	Brown
77	Male	28.0	188.0	59	185.5	3	Black
78	Female	24.0	175.0	49	177.0	2	Blonde
79	Female	23.0	162.5	21	165.0	3	Brown
80	Female	26.0	175.5	21	160.0	3	Brown
81	Female	22.5	174.0	34	169.0	4	Brown
82	Female	22.0	160.0	19	163.0	3	Blonde
83	Female	25.0	163.0	25	162.0	3	Brown
84	Female	25.5	170.0	21	170.0	4	Brown
85	Female	22.5	171.5	41	156.0	7	Brown
86	Male	26.0	173.0	22	169.0	5	Brown
87	Female	23.0	163.0	32	167.5	2	Purple
88	Female	24.0	157.0	26	156.0	3	Red
89	Female	22.0	163.0	46	160.0	8	Red
90	Female	20.0	149.0	22	158.0	3	Blonde
91	Male	26.0	190.5	34	191.0	4	Blonde
92	Female	24.5	170.0	39	162.0	1	Blonde
93	Female	23.5	152.5	26	154.0	3	Brown
94	Female	21.5	157.5	28	165.0	4	Brown
95	Male	24.5	182.0	32	190.0	3	Bald
96	Female	24.5	174.0	33	167.0	4	Brown