Question: Use Excel's ToolPak to compute One-Way ANOVA and submit your statistical output. Are there significant salary differences between the four departments? Please provide evidence to
- UseExcel's ToolPakto compute One-Way ANOVA and submit your statistical output.
- Are there significant salarydifferences betweenthe four departments? Please provide evidence to support your conclusion.
| 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
