Job Satisfaction Dummy Database & Statistical Error Excel Sheet Exercise The Vice President of HR is tasked with overseeing the hiring of all new staff. Sh

Job Satisfaction Dummy Database & Statistical Error Excel Sheet Exercise The Vice President of HR is tasked with overseeing the hiring of all new staff. She has noticed a disturbing trend recently. Employees who are younger and have only worked for a few companies are less satisfied with their work. She thinks this could be because they fear they are missing out on other opportunities.

However, she wants to know if there is data to support this. Therefore, she needs to know if there is a difference in job satisfaction between employees who have worked for more than 4 companies and employees who have worked for 4 or less companies.

Use the dummy database to answer the following questions:

1. What is the mean job satisfaction for employees who have worked for more than 4 companies?

2. What is the mean job satisfaction for employees than have worked for 4 or less companies?

3. What is the t-statistic for the difference of those means?

4. What is the p-value for that t-statistic

a. <.05 and >.01

b. <.001 c. <.01 and >.001

d. >.05

5. Is the difference in job satisfaction between employees who have worked for more than 4 companies and employees who have worked for 4 or less companies significant?

a. no

b. Yes, the p-value <.01 c.Yes, the p-value <.05 d. Yes, the p-value <.001