Explore BrainMass

Difference in Mean Shop Hours Across Departments

Please help with the following statistics-related problem. Please provide the solution in Excel.

The president of a new car dealership professional association wishes to study the number of hours department heads spend on the floor of their shops weekly by department. The manager selected a sample of five department heads from each of three shops from among area dealerships. At the .05 significance level, can she conclude there is a difference in the mean number of hours spent on the shop floor by department heads, by department?

Body Shop Mechanical Repair Shop Make-Ready Shop
48 35 15
55 33 25
20 31 33
23 37 36
15 40 22

Solution Summary

The following posting helps with a statistics-related problem. The attached Excel file performs an ANOVA to find if the difference in means is valid at the 0.05 significance level.