Assignment Steps Resources: Microsoft Excel®, SignatureAssignment Databases, Signature Assignment Options, Part 3:Inferential Statistics Scenario: Upon successful completion of theMBA program, say you work in the analytics department for aconsulting company. Your assignment is to analyze one of thefollowing databases: Manufacturing Hospital Consumer Food FinancialSelect one of the databases based on the information in theSignature Assignment Options. Provide a 1,600-word detailed,statistical report including the following: Explain the context ofthe case Provide a research foundation for the topic Present graphsExplain outliers Prepare calculations Conduct hypotheses testsDiscuss inferences you have made from the results This assignmentis broken down into four parts: Part 1 - Preliminary Analysis Part2 - Examination of Descriptive Statistics Part 3 - Examination ofInferential Statistics Part 4 - Conclusion/Recommendations Part 1 -Preliminary Analysis (3-4 paragraphs) Generally, as a statisticsconsultant, you will be given a problem and data. At times, you mayhave to gather additional data. For this assignment, assume all thedata is already gathered for you. State the objective: What are thequestions you are trying to address? Describe the population in thestudy clearly and in sufficient detail: What is the sample? Discussthe types of data and variables: Are the data quantitative orqualitative? What are levels of measurement for the data? Part 2 -Descriptive Statistics (3-4 paragraphs) Examine the given data.Present the descriptive statistics (mean, median, mode, range,standard deviation, variance, CV, and five-number summary).Identify any outliers in the data. Present any graphs or charts youthink are appropriate for the data. Note: Ideally, we want toassess the conditions of normality too. However, for the purpose ofthis exercise, assume data is drawn from normal populations. Part 3- Inferential Statistics (2-3 paragraphs) Use the Part 3:Inferential Statistics document. Create (formulate) hypotheses Runformal hypothesis tests Make decisions. Your decisions should bestated in non-technical terms. Hint: A final conclusion saying\"reject the null hypothesis\" by itself without explanation isbasically worthless to those who hired you. Similarly, stating theconclusion is false or rejected is not sufficient. Part 4 -Conclusion and Recommendations (1-2 paragraphs) Include thefollowing: What are your conclusions? What do you infer from thestatistical analysis? State the interpretations in non-technicalterms. What information might lead to a different conclusion? Arethere any variables missing? What additional information would bevaluable to help draw a more certain conclusion?
