About Your Signature AssignmentThis signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The signature assignments might be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements.Purpose of Assignment The purpose of this assignment is for students to synthesize the concepts learned throughout the course. This assignment will provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems requiring data by compiling all pertinent information into one report. Assignment Steps Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential StatisticsScenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases:ManufacturingHospitalConsumer FoodFinancial Select one of the databases based on the information in the Signature Assignment Options. Provide a 1,600-word detailed, statistical report including the following:Explain the context of the caseProvide a research foundation for the topicPresent graphsExplain outliersPrepare calculationsConduct hypotheses testsDiscuss inferences you have made from the results This assignment is broken down into four parts:Part 1 - Preliminary AnalysisPart 2 - Examination of Descriptive StatisticsPart 3 - Examination of Inferential StatisticsPart 4 - Conclusion/Recommendations Part 1 - Preliminary Analysis (3-4 paragraphs)Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.State the objective:What are the questions you are trying to address?Describe the population in the study clearly and in sufficient detail:What is the sample?Discuss the types of data and variables:Are the data quantitative or qualitative?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 you think are appropriate for the data.Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations. Part 3 - Inferential Statistics (2-3 paragraphs)Use the Part 3: Inferential Statistics document.Create (formulate) hypothesesRun formal hypothesis testsMake decisions. Your decisions should be stated in non-technical terms.Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient. Part 4 - Conclusion and Recommendations (1-2 paragraphs)Include the following:What are your conclusions?What do you infer from the statistical analysis?State the interpretations in non-technical terms. What information might lead to a different conclusion?Are there any variables missing?What additional information would be valuable to help draw a more certain conclusion?

Demonstrate the use of the normal distribution, the standard normal distribution, and the central limit theorem for calculating areas under the normal curve and exploring these concepts in real life applications.ScenarioFrank has only had a brief introduction to statistics when he was in high school 12 years ago, and that did not cover inferential statistics. He is not confident in his ability to answer some of the problems posed in the course.As Frank's tutor, you need to provide Frank with guidance and instruction on a worksheet he has partially filled out. Your job is to help him understand and comprehend the material. You should not simply be providing him with an answer as this will not help when it comes time to take the test. Instead, you will be providing a step-by-step breakdown of the problems including an explanation on why you did each step and using proper terminology.What to SubmitTo complete this assignment, you must first download the word document, (attached) and then complete it by including the following items on the worksheet:Incorrect AnswersCorrect any wrong answers. You must also explain the error performed in the problem in your own words.Partially Finished WorkComplete any partially completed work. Make sure to provide step-by-step instructions including explanations.Blank QuestionsShow how to complete any blank questions by providing step-by-step instructions including explanations.Your step-by-step breakdown of the problems, including explanations, should be present within the word document provided. You must also include an Excel workbook (not attached, you will have to create it) which shows all your calculations performed.YOU MUST MEET THE REQUIREMENTS BELOW: All problems are solved correctly. Complete and detailed steps are provided to explain how to solve the problem. Explanations demonstrate a mastery of understanding of the statistical concepts and terminology. All variables, equations, and expressions are properly formatted.