ANALYSIS OF VARIANCE – ANOVA

ANALYSIS OF VARIANCE – ANOVA

Assignment Overview
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 two to three pages. Submit the paper as the case and upload the Excel file into Additional files.

 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂