Share
Explore BrainMass

Lean six sigma scenario

Case Scenario: The CEO of Excellent Manufacturing Company sees a report showing the Complaints of the four sales regions and wants to know if there is any difference in the level of complaints across the regions and if so why. You are the Senior Data Analyst. How do you analyze the data and make this determination?
Eastern Midwestern Southern Western
Jan 52 45 39 47
Feb 50 52 38 58
Mar 36 43 49 65
Apr 42 31 55 63
May 61 38 57 46
Jun 49 55 61 34
Jul 24 33 44 51
Aug 55 46 42 43
Sep 50 62 58 58
Oct 40 52 29 53
Nov 47 53 37 48
Dec 28 34 36 25
Assignment: Do an ANOVA analysis with this data.
Assignment Expectations: First do the ANOVA using the separate formulas in Excel. Then on a separate worksheet in the same Excel file, do the analysis again using the ANOVA Data Analysis Tool. Write a paper as a memo to the CEO explaining the results of your analysis and what the results mean. Be sure to refer to the results. The paper should be one to two pages. Submit the paper as the case and upload the Excel file into Additional files.

Attachments

Solution Summary

The lean six sigma scenario are examined.

$2.19