Use the excel data to answer the questions

Data: https://1drv.ms/x/s!AoKasatN5SDBkGB4ihb67WoGMy7Q

1. What is the t-statistic for the difference of the HR and R&D performance ratings?

2. What is the p-value for that t-statistic (HR vs. R&D)?

3. Is the p-value significant at the .05 level?

4. What is the t-statistic for the difference of the HR and Sales performance ratings means? Is the p-value significant at the .05 level?

5. What is the t-statistic for the difference of the R&D and Sales performance ratings means?

6. What is the p-value for that t-statistic (R&D vs. Sales)? Is the p-value significant at the .05 level?

7. What can you determine about the performance ratings for each department?

- The performance ratings vary somewhat by department, but they are not significant..

- The performance ratings vary significantly by department.

- The performance ratings are quite similar between department and there are not significant differences.

8. If you look closely at the Performance Ratings data across the dataset, you will see that there are only 2 values: 3 and 4.

What does this mean?

- You should only compare performance ratings for large groups.

- It is highly unlikely you will have a significant difference in performance ratings by any two groups.

- Most groups will have the same exact performance rating.