Using the dataset provided, can you answer the following question using Excel: The expected FEV for males is 3.91 L based on the average height and age of males in the sample. Do male smokers have an average FEV different from 3.91 L?

Formulate the null and alternate hypothesis for this test. Then, run the appropriate analysis in Excel and write up the results to answer the question, including the values you calculated for t-statistic, critical value, and p-value in a Word document.

ID	Age	FEV	Height	Sex	Smoke
1	16	3.171	63	0	0
2	13	3.745	68	0	0
3	14	3.428	64	0	1
4	19	3.078	67.5	1	0
5	13	5.083	74	1	0
6	17	1.694	60	1	1
7	16	4.872	72	1	1
8	14	3.795	68.5	1	0
9	15	3.102	64	0	1
10	15	2.198	62	0	1
11	19	3.681	68	0	0
12	13	3.089	67.5	1	0
13	15	4.284	70	1	0
14	16	2.354	62	0	0
15	14	2.276	66	1	1
16	15	3.004	64	0	1
17	17	3.082	67	1	1
18	13	2.387	66	0	1
19	14	3.074	65	0	1
20	15	3.985	71	1	0
21	12	3.751	72	1	1
22	13	3.069	65	0	1
23	15	4.5	70	1	0
24	13	3.577	63.5	0	0
25	16	4.27	67	1	1
26	13	3.141	61	0	0
27	16	3.038	65	0	1
28	13	3.785	63	0	1
29	16	3.387	66.5	0	0
30	13	2.449	63	0	0
31	13	3.297	65	0	1
32	14	2.538	71	0	0
33	13	3.255	66.5	0	0
34	13	2.677	67	0	1
35	13	2.819	62	0	0
36	12	3.692	67	1	0
37	19	3.519	66	0	1
38	13	3.208	61	0	1
39	14	4.273	72.5	1	0
40	15	5.793	69	1	0
41	18	2.822	62	0	0
42	14	2.997	64.5	0	0
43	15	4.073	67	1	0
44	14	3.741	68.5	1	0
45	17	3.169	62.5	0	1
46	18	4.404	70.5	1	1
47	19	1.716	55.5	1	0
48	16	3.104	67.5	0	1
49	18	3.082	64.5	0	0
50	13	3.152	62	0	1
51	13	3.887	67.5	1	0
52	15	2.635	64	0	0
53	13	1.873	52.5	1	0
54	14	4.309	69	1	1
55	17	4.429	70	1	0
56	15	2.278	60	0	1
57	13	3.984	71	1	0
58	15	3.122	64	0	1
59	18	4.22	68	1	0
60	16	2.903	63	0	1
61	14	3.78	70	1	0
62	14	2.352	61.5	1	0
63	16	2.795	63	0	1
64	19	3.345	65.5	0	1
65	13	2.599	62.5	0	1
66	12	3.186	67	0	1
67	12	2.841	63	0	0
68	15	2.953	67	0	1
69	19	2.592	65	1	0
70	18	2.906	66	0	0
71	14	4.683	68.5	1	0
72	14	3.169	64	0	0
73	15	3.305	65	0	0
74	17	2.646	60	1	0
75	16	4.299	66	1	0
76	13	4.336	69.5	1	0
77	12	2.384	63.5	0	1
78	14	2.975	63	0	1
79	13	3.906	67	1	0
80	15	1.953	58	1	1
81	14	3.395	67	0	0
82	17	3.406	69	1	1
83	13	4.045	69	1	1
84	14	4.111	71	1	0
85	16	2.608	62	0	1
86	12	3.835	69.5	0	1
87	13	2.216	68	0	1
88	13	4.877	73	1	0
89	16	3.023	67.5	0	0
90	15	3.211	66.5	0	0
91	14	2.236	66	0	1
92	12	2.304	66.5	1	1
93	14	4.271	72.5	1	0
94	14	3.498	68	1	1
95	17	3.022	61.5	0	0
96	16	4.504	72	1	0
97	18	4.086	67	1	1
98	14	3.806	68	1	0
99	17	4.13	67	1	0
100	14	3.957	72	1	1
101	13	3.816	63.5	0	0
102	15	2.679	66	0	1
103	15	4.506	71	1	1
104	14	2.891	62	0	0
105	16	3.645	73.5	1	0
106	15	3.731	67	1	0
107	13	3.12	61	0	1
108	16	2.894	67	1	0
109	16	4.07	69.5	1	1
110	16	3.688	68	1	1
111	13	3.297	65	0	1
112	14	4.842	72	1	0
113	15	2.887	63	0	0
114	19	2.458	60	0	0
115	13	3.078	66	0	1
116	13	4.448	69	1	0
117	13	4.756	68	1	1
118	14	3.339	68.5	1	1
119	19	5.102	72	1	0
120	12	2.759	61.5	0	1
121	13	3.549	68	1	0
122	16	3.413	66	0	1
123	19	4.637	72	1	1
124	12	2.752	63.5	0	0
125	12	2.913	64	1	0
126	14	4.763	68	1	1
127	15	3.727	68	1	1
128	15	3.33	68.5	0	1
129	13	2.434	65.4	0	0
130	12	2.556	62	0	0
131	17	4.724	70.5	1	0
132	12	3.791	68.5	1	0
133	17	5.633	73	1	0
134	17	3.5	62	0	0
135	13	3.056	63	0	0
136	13	2.976	65.5	1	0
137	15	4.279	67.5	1	0
138	14	3.585	70	1	0
139	14	2.545	65	1	0
140	13	4.225	74	1	0
141	14	2.934	64	0	0
142	13	3.994	67	1	0
143	13	3.147	64	0	0
144	16	2.981	66	0	0
145	15	2.264	63	0	1
146	15	3.799	66.5	1	1
147	13	2.646	61.5	0	0
148	13	4.789	69	1	1
149	12	3.343	68	1	1
150	14	3.68	67	1	0
151	13	4.232	70.5	1	0
152	12	2.868	62	0	0
153	18	2.853	60	0	0
154	17	3.96	70	1	0
155	13	4.305	68.5	1	0
156	13	3.331	65.5	0	0
157	13	3.06	61.5	0	0
158	13	2.531	61	1	0
159	14	3.381	63	1	0
160	16	3.674	67.5	0	0
161	13	2.704	61	0	0
162	14	3.436	62.5	1	0
163	17	5.638	70	1	0
164	13	3.086	67.5	0	1