Excel Assignment

Texas Health Harris Methodist measures average wait time for patients in the ER is 45 minutes. The average wait time for the ER is normally distributed. The hospital decided to check if this is still true, the quality control staff recorded 45 observations of the wait time of ER patients. Using the observations below, is there evidence that the average wait time for ER patients is not 45 minutes? Use a level of significance of .05

Observation

Observations	Time (in minutes)
1	44.48
2	43.93
3	44.92
4	45.05
5	46.11
6	47.52
7	44.4
8	46.38
9	46.03
10	46.12
11	45.27
12	44.23
13	49.48
14	40.35
15	41.96
16	42.93
17	47.86
18	45.57
19	46.52
20	45.34
21	45.33
22	40.98
23	46.58
24	47.2
25	46.89
26	44.23
27	46.14
28	48.63
29	43.69
30	45.87
31	42.98
32	45.95
33	45
34	44.16
35	44.38
36	47.51
37	45.14
38	41.75
39	46.22
40	45.64
41	45.87
42	48.06
43	45.64
44	45.44
45	41.49

Answer the following question:

1. What is the null and alternative hypothesis to the case above?

2. Copy the data into excel and do an analysis to test the hypothesis

Upload the excel file with the your assignment submission

Hint: (watch the module 3 videos)

3. What is the conclusion of your analysis? (try to state it in terms of the original problem or question)

As a director of your HR department you want to see if there is a difference in salary based on gender in your industry. You take a sample of the salaries of males and females from different companies in your industry. Using the observations below, is there evidence that the average salary between males and female are different? Use a level of significance of .05

Company	MALES ($ thousands)	FEMALES ($ thousands)
1	34.5	33.9
2	30.5	31.2
3	35.1	35
4	35.7	34.2
5	31.5	32.4
6	34.4	34.1
7	32.1	32.7
8	30.7	29.9
9	33.7	31.2
10	35.3	35.5
11	30.7	30.2
12	34.2	34.8
13	39.6	38.7
14	30.5	30
15	33.8	33.8
16	31.7	32.4
17	32.8	31.7
18	38.5	38.9
19	40.5	41.2
20		25.5
21		28
22		35.1

4. What is the null and alternative hypothesis to the case above?

5. Copy the data into excel and do an analysis to test the hypothesis

Upload the excel file with the your assignment submission

6. What is the conclusion of your analysis? (state it in terms of the original problem or question)