Progress CheckUse this activity to assess whether you and your peers can: Under appropriate conditions, conduct a hypothesis test about a difference between two population means. State a conclusion in contextLearn by DoingIn this activity you will learn to use StatCrunch to perform a two-sample t-test.Some features of this activity may not work well on a cell phone or tablet. We highly recommend that you complete this activity on a computer.Use the rubric at the bottom of this page as a guide for completing this assignment.A list of StatCrunch directions is provided after the Prompt section below.DirectionsSubmit your work:Carefully read all sections below (beginning with the Context section and ending with the Prompt section).Commit a good-faith effort to address all items in the Prompt section below. Please be sure to number your responses.If directed to do so, embed all required StatCrunch output in your initial submission. Please do not submit StatCrunch output as an attachment.Complete your assigned peer reviews:After you submit your initial good-faith attempt, continue to the ANSWER(S) page and review your instructor's response. But please do not submit your corrected work yet.Within three days after the due date, return to this assignment and complete your assigned peer reviews (directions (Links to an external site.)).Submit your corrected work:We all learn from mistakes (our own and our classmates' mistakes). So please do not immediately correct your own mistakes. If possible, wait until you receive feedback from at least one of your peers. If necessary, correct your work and resubmit the entire assignment - including any required StatCrunch output. Your instructor will only review and grade your most recent submission, so please do not refer to a previous submission.ContextDo undergraduates sleep less than graduate students?A student conducted a study of sleep habits at a large state university. His hypothesis is that undergraduates will party more and sleep less than graduate students. He surveyed random samples of 75 undergraduate students and 50 graduate students. Subjects reported the hours they sleep in a typical night.For this hypothesis test, he defined the population means as follows:𝜇1μ1μ2 is the mean number of hours undergraduate students sleep in a typical night.𝜇2 is the mean number of hours graduate students sleep in a typical night.VariablesHours: typical number of hours a student sleeps each night Program: undergraduate or graduate Program is the explanatory variable, and the data is categorical. Hours is the response variable, and the data is quantitative.DataDownload the sleep2 (Links to an external site.) datafile, and upload the file in StatCrunch. PromptState the null and alternative hypotheses. Include a clear description of the populations and the variable.Explain why we can safely use the two-sample T-test in this case.Use StatCrunch to carry out the test. (directions)Copy and paste the content of in the StatCrunch output window (text and the table) in your initial post. State a conclusion in the context of this problem.List of StatCrunch DirectionsEach link will open in a new window. To return to this discussion, either close the new tab or select the tab for this discussion. Purchase StatCrunch (You only need to do this once.)Open StatCrunchDownload Excel FileUpload Excel Data File to StatCrunchDownload StatCrunch Output Window (no screenshots; please use these directions)Upload Files to Your Stats-Class Folder in CanvasEmbed Pictures in a Textbox (no attachments; please use these directions)Copy & Paste a StatCrunch Table Conduct a Hypothesis Test for a Difference in Two Population MeansContent by the Open Learning Initiative (Links to an external site.) and licensed under CC BY (Links to an external site.).RubricPeer Reviewed Assignment w/ StatCrunchPeer Reviewed Assignment w/ StatCrunchCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeAddressing the Prompt6 ptsFull MarksAll parts of the Prompt are addressed. Answers are correct. Statistical vocabulary is used appropriately. Writing is clear and thought process is easy to follow.4 ptsPartial CreditSome parts of the prompt are not addressed, are incorrect, or are unclear.0 ptsNo MarksThe prompt is not addressed.6 ptsThis criterion is linked to a Learning OutcomeStatCrunch Data2 ptsFull MarksAppropriate StatCrunch graphs and/or tables are provided as directed.1 ptsPartial CreditStatCrunch graphs and tables are inappropriate or missing important information.0 ptsNo MarksNo StatCrunch information is provided.2 ptsThis criterion is linked to a Learning OutcomeIndividual Penalty0 ptsNo individual penalty-1 ptsIndividual penalty.Please see the instructor comments for more information.0 ptsThis criterion is linked to a Learning OutcomePeer Reviews2 ptsFull MarksYou completed all assigned peer reviews (maximum of 2). For each peer review, the points you assigned in the rubric are appropriate. You included comments explaining the score you posted in the rubric. If you deducted points in the rubric, your comments explain what the author needs to do to earn a higher grade when the teacher grades the assignment.1 ptsPartial CreditCommitted a good-faith effort to provide a high-quality peer review, but many necessary instructive comments are missing.0 ptsNo MarksNo peer review provided or the comments are not instructive.2 ptsTotal Points: 10

Its an excel project where you follow the rubric completely as it gives you instructions for math excel problems

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?Develop an PowerPoint executive summary (8-10 slides)regarding the information contained in your signature assignment narrative. Topics should follow and be consistent with those identified and discussed in the submitted narrative for your chosen analysis. Each section of the presentation (as identified in the narrative for the paper) is worth 4 points, with the overall organization, style of presentation, and visuals Format your assignment consistent with APA format.