Excel: The General Manager has heard a rumor that the employees with a low salary are working more hours (on average) than the employees with a high salary. The manager asks you to find out if the difference in average working hours is significantly more on the low salary employees than on the high salary employees. Use a t-test please explain on excel.

• State the null and alternative hypothesis and Show the summary output

Satisfaction Level 2020	Satisfaction Level 2019	number_project	average_montly_hours	time_spend_company	Work_accident	promotion_last_5years	position	salary
0.41	0.46	2	128	3	0	0	accounting	low
0.38	0.5	2	132	3	0	0	accounting	low
0.09	0.62	6	294	4	0	0	accounting	low
0.39	0.56	2	142	3	0	0	accounting	low
0.44	0.5	2	148	3	0	0	accounting	medium
0.11	0.8	6	304	4	0	0	accounting	low
0.11	0.8	6	285	4	0	0	accounting	medium
0.4	0.56	2	149	3	0	0	accounting	low
0.9	0.97	4	258	5	0	0	accounting	low
0.11	0.83	6	244	4	0	0	accounting	low
0.11	0.84	6	287	4	0	0	accounting	medium
0.46	0.46	2	154	3	0	0	accounting	medium
0.41	0.48	2	145	3	0	0	accounting	medium
0.45	0.47	2	151	3	0	0	accounting	medium
0.31	0.56	4	238	2	0	0	accounting	medium
0.36	0.48	2	156	3	0	0	accounting	high

0.54

0.5

2

123

4

1

0

accounting

low