PLEASE ANSWER WITH EXCEL FORMULAS IN EXCEL FORMAT

A. Suppose the 60 hospital discharges on the Hospital Charges worksheet represent a random sample of all Medicare-eligible persons discharged from a specific hospital.

3. Calculate the variance and standard deviation of Age, LOS, and Charges by using the =VAR() and STDEV functions.

4. Test the hypothesis at the 95 percent level of confidence that average Charges for the population is $6,000 (H0: C=$6,000), against the alternative hypothesis that average Charges is not $6,000 (H1: C$6,000), and state your conclusion.

IDI57A1A12:I50	Sex	Age	LOS	DRG	Charges	Medicare	Diag	ICD-9
1	F	46	4	294	$ 2,426.48	$ 2,003.62	2	0
2	F	87	8	139	$ 6,815.61	$ 1,072.17	4	4
3	F	70	10	34	$ 7,596.68	$ 4,096.98	6	0
4	M	72	5	140	$ 6,450.77	$ 1,710.79	5	0
5	F	82	3	141	$ 3,542.79	$ 1,914.90	3	7
6	F	85	2	15	$ 2,590.86	$ 2,601.14	5	4
7	F	73	5	294	$ 5,082.83	$ 2,035.31	7	2
8	M	65	6	241	$ 3,580.55	$ 2,320.42	6	0
9	M	73	6	335	$ 11,045.79	$ 4,184.26	1	0
10	F	94	14	148	$ 19,708.11	$12,158.49	4	0
11	F	94	11	89	$ 8,953.38	$ 4,345.84	4	0
12	M	79	5	127	$ 7,000.21	$ 3,993.48	5	0
13	M	82	6	89	$ 5,330.24	$ 3,408.07	4	0
14	F	76	3	122	$ 6,864.63	$ 3,637.35	5	4
15	M	72	3	336	$ 4,318.13	$ 2,676.01	2	0
16	F	91	7	321	$ 6,424.30	$ 1,510.20	3	0
17	F	90	6	174	$ 5,184.53	$ 3,642.44	6	5
18	F	83	3	143	$ 1,871.78	$ 1,167.65	6	0
19	F	82	11	358	$ 11,179.97	$ 3,432.13	9	6
20	F	49	2	140	$ 3,405.38	$ 1,710.79	1	0
21	F	88	2	143	$ 1,731.73	$ 1,979.28	4	7
22	F	75	2	159	$ 5,384.92	$ 3,316.59	2	0
23	M	81	7	89	$ 5,216.91	$ 3,613.06	2	4
24	F	76	4	294	$ 2,489.65	$ 2,201.93	3	0
25	F	85	10	473	$ 8,244.25	$12,772.75	4	0
26	F	84	6	128	$ 3,548.05	$ 2,163.29	8	4
27	F	77	3	15	$ 4,713.26	$ 1,801.73	4	0
28	F	94	6	121	$ 5,804.21	$ 5,282.36	5	7
29	F	66	6	128	$ 2,945.22	$ 2,849.72	2	0
30	M	72	1	140	$ 1,035.75	$ 1,685.62	5	4
31	M	78	3	209	$ 17,005.45	$ 7,534.44	1	7
32	F	86	3	143	$ 4,637.96	$ 1,447.84	5	0
33	F	70	5	209	$ 17,480.97	$ 7,566.98	5	0
34	M	72	5	96	$ 5,029.09	$ 3,306.80	8	4
35	M	91	3	144	$ 3,078.99	$ 3,351.64	5	4
36	M	75	2	90	$ 2,146.99	$ 1,968.05	2	4
37	F	83	6	88	$ 5,482.93	$ 3,147.39	2	0
38	M	82	1	183	$ 1,078.56	$ 1,386.42	6	5
39	F	82	10	430	$ 9,931.21	$ 3,530.00	1	0
40	F	92	2	138	$ 2,451.69	$ 2,266.56	2	4
41	F	79	2	88	$ 2,834.68	$ 3,579.24	1	0
42	F	69	2	447	$ 1,547.81	$ 988.00	3	0
43	F	76	3	183	$ 1,876.70	$ 1,235.80	1	0
44	M	73	2	140	$ 2,781.28	$ 1,483.79	4	0
45	F	83	6	127	$ 6,460.59	$ 3,993.48	5	0
46	F	80	4	444	$ 3,026.42	$ 1,918.32	1	6
47	F	76	10	493	$ 14,769.92	$ 5,594.68	4	5
48	F	77	7	324	$ 4,425.44	$ 1,531.55	5	5
49	F	85	4	140	$ 5,151.52	$ 1,710.79	5	0
50	F	70	1	140	$ 2,404.39	$ 735.58	1	4
51	M	81	2	140	$ 5,019.86	$ 1,730.79	2	0
52	F	83	9	138	$ 10,421.01	$ 2,384.12	5	0
53	M	76	2	269	$ 4,860.83	$ 5,688.67	4	1
54	F	88	3	140	$ 2,694.11	$ 1,564.50	2	0
55	M	88	4	208	$ 2,421.63	$ 1,346.94	2	0
56	F	89	2	15	$ 3,311.66	$ 2,065.49	3	0
57	M	39	1	434	$ 1,596.91	$ 392.00	5	3
58	F	89	5	88	$ 5,399.67	$ 3,048.91	4	4
59	M	80	12	78	$ 17,605.59	$ 4,432.93	9	7
60	F	71	7	89	$ 11,098.70	$ 4,256.70	3	4