Question: Based on the data provided, use One-Way ANOVA to find out if there are significant salary differences between the four departments. In specific, please do
Based on the data provided, use One-Way ANOVA to find out if there are significant salarydifferences betweenthe four departments.
In specific, please do the following:
- Create hypothesis testing for the One-Way ANOVA
- Use Excel's ToolPak to compute the One-Way ANOVA.
- Submit your statistical findings.
- Based on the statistical findings, explain if there are any significant differences between the populations' means. Please interpret your answer.
| Dept. 1 | Dept. 2 | Dept. 3 | Dept. 4 |
| $32,782 | $35,467 | $23,654 | $65,487 |
| $32,920 | $35,468 | $36,578 | $46,184 |
| $29,548 | $29,876 | $37,548 | $54,899 |
| $39,828 | $43,674 | $53,234 | $34,869 |
| $31,528 | $36,431 | $54,679 | $35,487 |
| $38,985 | $26,578 | $47,536 | $26,548 |
| $41,889 | $36,571 | $31,425 | $34,231 |
| $38,791 | $56,326 | $39,331 | |
| $28,985 | $36,512 | ||
| $24,749 | $68,425 | ||
| $36,487 | |||
| $34,632 | |||
| $46,211 | |||
| $51,698 | |||
| $69,246 | |||
| $48,695 | |||
| $34,987 | |||
| $35,631 | |||
| $39,743 | |||
| $41,255 | |||
| $26,452 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help