Purchase Solution

Statistics

Not what you're looking for?

Ask Custom Question

Suppose a firm evaluates the productivity of the three shifts of workers who work in their factory. Each shift's performance is measured on the amount of output that is produced during the shift - day, evening, or swing shift. Based on these ratings presented in the table below, produce an ANOVA analysis in Excel (see the example of a 1-way ANOVA in Course Materials), and determine if the average amount of output for any shift is different than the others.

Please show all calculations (especially the calculations of the variances for each shift (how the resultant variance number is derived), and also show the calculations how the P-value is determined - whether by formula or by charts.

Day Evening Swing

6 5 5
8 8 6
9 7 5
8 7 7
8 6 5
9 7 6
7 7 5
8 8 5
7 6 6
7 5 5

Purchase this Solution

Solution Summary

Excel file contains solution by both manual and excel method. It contains ANOVA analysis and calculate p -value

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking