Develop descriptive statistics for the monthly transformer requirements for each year over 2006-2010, assignment help

submit a paper and a spreadsheet that provides a justification of the appropriate statistical tools needed to analyze the company’s data, hypotheses, the results of your analysis, any inferences from your hypothesis test, and a forecasting model that addresses the company’s problem. For additional details, please refer to the Milestone Two Guidelines and Rubric document in the Assignment Guidelines and Rubrics section of the course.

The attached case addendum (qso510_final_project_case_addendum.pdf ) will help you make progress in the project. This addendum provides an outline of the study that you are expected to perform. As an extension of it, please include the analysis of the following in your Milestone 2 report.

i. Develop descriptive statistics for the monthly transformer requirements for each year over 2006-2010 to be submitted to the quality control department.
ii. Test the belief that the mean number of transformers that is required exceeds 1000 transformers using the most recent (2010) data….. Hypothesis tests for Means (Chapter 11).

iii. Provide an analysis that supports or disproves that mean number of transformers that are required has changed over the period 2006-2010….. ANOVA (Chapter 20)
iv. Develop a linear model for forecasting transformer requirements based on sales of refrigerators…Correlation and Regression Analysis (Chapter 4)

Please note that one of the main purposes of this project is that you demonstrate that you can perform the steps of a formal statistical analysis approach. Hence, a complete analysis of each hypothesis is essential for the successful completion of your study. The complete analysis should include the formal definition of the hypotheses, presentation and interpretation of the analysis results, and verification of the underlying assumptions.