Purchase Solution

Difference in Mean Shop Hours Across Departments

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution
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.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Direct and Step Method Cost Accounting

    data to be used in its service department cost allocations: Service Departments Operating Departments Administration Janitorial Groceries Gifts Departmental costs before allocations $150,000 $40,000 $2,320,000 $950,000 Employee-hours

  • Testing of Hypothesis

    At the .05 significance level, can she conclude there is a difference in the mean number of hours spent per week by industry?

  • Test hypotheses

    At the .05 significance level, can she conclude there is a difference in the mean number of hours spent per week by industry?

  • Basic Statistics for Business and Economics

    At the .05 significance level, can we conclude that there is a difference in their mean times?

  • Interpreting Statisitical Software Output

    There is evidence to suggest a difference in the mean waiting times at the four body shops.

  • Test hypotheses based on an output of a statistical package

    To check if there is any difference in service, customers are randomly selected from each repair shop and their waiting times in days are recorded.

  • Overhead Costs

    b. significant differences exist in the factory overhead rates used across different production departments.

  • Interpreation of results of ANOVA

    To check if there is any difference in service, customers are randomly selected from each repair shop and their waiting times in days are recorded.

  • Clarification of Analysis of Variance

    To check if there is any difference in service, customers are randomly selected from each repair shop and their waiting times in days are recorded.

View More Related Solutions