Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I tried solving this problem in Excel using the required formula but I dont know how to format it correctly. Please help! 42. For the
I tried solving this problem in Excel using the required formula but I dont know how to format it correctly. Please help!
42. For the Excel file Job Satisfaction, use ANOVA to determine if the mean overall job satisfaction ratings differ by department. | ||||||||
Job Satisfaction.xlsx | ||||||||
1=Low, 10=High | ||||||||
Overall Job satisfaction | ||||||||
Department | Satisfaction | Administrative | Maintenance | Management | Production | Quality Control | Shipping/Receiving | |
Administrative | 3 | 3 | 8 | 9 | 5 | 10 | 5 | |
Administrative | 9 | 9 | 9 | 8 | 4 | 7 | 4 | |
Administrative | 6 | 6 | 3 | 8 | 5 | |||
Maintenance | 8 | 10 | 10 | |||||
Maintenance | 9 | 4 | 8 | |||||
Management | 9 | 9 | ||||||
Management | 8 | 7 | ||||||
Management | 3 | 8 | ||||||
Production | 5 | 6 | ||||||
Production | 4 | 6 | ||||||
Production | 8 | 8 | ||||||
Production | 10 | 7 | ||||||
Production | 4 | 7 | ||||||
Production | 9 | 8 | ||||||
Production | 7 | 6 | ||||||
Production | 8 | 9 | ||||||
Production | 6 | 3 | ||||||
Production | 6 | |||||||
Production | 8 | |||||||
Production | 7 | |||||||
Production | 7 | |||||||
Production | 8 | |||||||
Production | 6 | |||||||
Production | 9 | |||||||
Production | 3 | |||||||
Quality Control | 10 | |||||||
Quality Control | 7 | |||||||
Shipping / Receiving | 5 | |||||||
Shipping / Receiving | 4 | |||||||
Shipping / Receiving | 5 | |||||||
Shipping / Receiving | 10 | |||||||
Shipping / Receiving | 8 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started