Compute the sample statistics and determine whether there is evidence that the population mean upload speed is less than 0.97.Write a memo to management that summarizes your conclusion.*These are eText page numbers.*Please note the data are stored in AMS9 (attached). Also, please note you need to submit two identical files:1. The original Excel file for all work, including your calculations, decision, and memo, and2. The PDF copy of the Excel file. AMS9.xlsxTEXT: CUSTOM EDITION of Statistics for Managers Using Microsoft Excel, 8th Edition; Levine, Stephan, and Szabat; Pearson; ISBN of custom edition: 9781323516881; © 2016.

Scenario/SummaryThis week you will submit both parts of the course project. You completed Part I in Week 6 and will complete Part II this week. You will submit one word document with both parts of the project. ( the project for week 6 is attached)Hypothesis Testing is the use of statistics to determine the probability that a given claim is true.In Part II of this project, you will choose a data set, review claims and perform hypothesis testing and make a decision. You will then complete a write-up that includes the calculations.The government logs the number of documented births, deaths, marriages and divorces; however, it is possible to have undocumented cases. In part II of this project, you are going to test claims about total births, deaths, marriages and divorces.DeliverablesChoose a Data Set.Go to https://www.cdc.gov/nchs/products/nvsr.htm (Links to an external site.)In the search bar type: Births, Marriages, Divorces, and DeathsPick a DataSet and download the PDF document and make note of the volume, number, and date. For example you could use the National Vital Statistics Reports,Pick the same month/year combination for each data set. For example, choosing September of 2009.Preliminary CalculationsCreate a summary table for 1. Live Births, 2. Deaths, 3. Marriages, and 4. Divorces highlighting the mean, median, sample standard deviation, minimum and maximum values for each the data sets. You will have FOUR tables using the list of values of each state, the District of Columbia and Puerto Rico (You will have 52 numbers for each data set).Summary Table for _________Mean Median Standard Deviation Minimum MaximumHypothesis TestingWith the information that you gather from the summary tables, test the following (you can use excel when appropriate):Determine if there is sufficient evidence to conclude the average amount of births is over 5000 in the United States and territories at the 0.05 level of significance.Determine if there is sufficient evidence to conclude the average amount of deaths is equal to 6000 in the United States and territories at the 0.10 level of significance.Determine if there is sufficient evidence to conclude the average amount of marriages is greater or equal to 2500 in the United States and territories at the .05 level of significance.Determine if there is sufficient evidence to conclude the average amount of divorces is less than or equal to 4000 in the United States and territories at the 0.10 level of significance.For each of the tests above, in your report, be sure to—Clearly state a null and alternative hypothesisGive the value of the test statisticReport the P-ValueClearly state your conclusion (Reject the Null or Fail to Reject the Null)Explain what your conclusion means in context of the data.Lastly, propose and conduct your own test of hypothesis about the Birth, Death, Marriage and Divorce data that you have been analyzing. Make sure to follow the five steps above.Required SoftwareMicrosoft Office: Word and ExcelUse a personal copy or access the software at https://application.chamberlain.edu (Links to an external site.) .GradingThis activity will be graded based on the Course Project grading rubric.Course Outcomes (CO): 6Due Date: By 11:59 p.m. MT on Sunday of Week 7RubricCourse Project RubricCourse Project RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomePart I: Topic & Introduction4.0 ptsProficient Student picks appropriate topic, provides a description of topic and the cites where data was found.3.0 ptsAbove Average Student picks appropriate topic and introduces data. No citation.2.0 ptsAverage. Student does not pick a topic that is appropriate for the project, introduces the data but does not cite source.1.0 ptsNeeds Improvement Students provides topic without descritption and citation.0.0 ptsNo Effort. No topic, descritpion or citation is provided.4.0 ptsThis criterion is linked to a Learning OutcomePart I: Sample Data4.0 ptsProficient Student provides ALL 50 pieces of data.3.0 ptsAbove Average Student provides 30-49 pieces of data.2.0 ptsAverage Student provides 20 - 29 pieces of data.1.0 ptsNeeds Improvement Student provides 1-19 pieces of data.0.0 ptsNo Effort. No Data was provided.4.0 ptsThis criterion is linked to a Learning OutcomePart I: Mean & Standard Deviation5.0 ptsProficient Mean & Sample Standard Deviation of the data set is correct with no rounding error. .4.0 ptsAbove Average Mean & Sample Standard Deviation of the data set is correct but with roujnding error.3.0 ptsAverage One Value (either mean or sample standsrd deviation) is correct but the other is not correct.1.0 ptsNeeds Improvement Both the Mean & Sample Standard Deviation are incorrect but it was attempted.0.0 ptsNo Effort. The mean and sample standard deviation5.0 ptsThis criterion is linked to a Learning OutcomePart I: Constructing the 80%, 95%, 99% Confidence Intervals15.0 ptsProficient Computes the 80%, 95%, and 99% confidence intervals correclty making sure to note the margin of error for each.12.0 ptsAbove Average Computes the 80%, 95%, and 99% confidence intervals correclty but is missing margin of errors (or some of the margin of errors are incorrect).10.0 ptsAverage Computes the 80%, 95%, and 99% confidence intervals but there are some errors in the calculations.6.0 ptsNeeds Improvement Computes the 80%, 95%, and 99% confidence intervals but all of the values are incorrect. The component was attempted.0.0 ptsNo Effort. No Confidence Intervals are provided.15.0 ptsThis criterion is linked to a Learning OutcomePart I: Creating a new confidence interval7.0 ptsProficient. Student computes a confidence interval (not 80%, 95%, 99%) correctly making sure to list the margin of error.5.0 ptsAbove Average. Student computes a confidence interval (not 80%, 95%, 99%) correctly making sure to list the margin of error but there is rounding error.4.0 ptsAverage. Student computes a confidence interval (not 80%, 95%, 99%) correctly but does not highlight the margin of error.3.0 ptsNeeds Improvement Student computes a confidence interval (not 80%, 95%, 99%) but it was not done correctly.0.0 ptsNo Effort. The student did not create a new confidence interval.7.0 ptsThis criterion is linked to a Learning OutcomePart I: Problem Analysis10.0 ptsProficient. Student addresses trend that takes place when the confidence level rises. Provides a sentence for each confidence interval created explaining what the confidence interval means in context of the data collected. Provides a reflection for Part I of the project.8.0 ptsAbove Average. Student addresses trend that takes place when the confidence level rises. Provides sentences for each confidence interval created explaining what the confience interval means in context of the data collected. Does NOT provide a Reflection.7.0 ptsAverage. Student may or may not address the trend that takes place when the confidence level rises. Provides a sentence for SOME confidence intervaSl created explaining what the confidence interval means in context of the data collected. A reflection Part I of the project may or may not be provided.5.0 ptsNeeds Improvement. Majority of the analysis is missing.0.0 ptsNo Effort. No Problem Anaylsis is provided.10.0 ptsThis criterion is linked to a Learning OutcomePart II: Choose a Data Set & Preliminary Data5.0 ptsProficient. Student computes all 4 Preliminary Data Values.4.0 ptsAbove Average. Student computes all 3 Preliminary Data Values.3.0 ptsAverage. Student computes all 2 Preliminary Data Values.1.0 ptsNeeds Improvement. Student computes all 1 Preliminary Data Values.0.0 ptsNo Effort. No Preliminary Data5.0 ptsThis criterion is linked to a Learning OutcomePart II: Hypothesis Testing20.0 ptsProficient. Completes 4 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and report p-value.16.0 ptsAbove Average. Completes 3 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and report p-value.14.0 ptsAverage. Completes 2 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and report p-value.10.0 ptsNeeds Improvement: Completes 1 Hypothesis Test highlighting the null/alternate hypothesis, value of test statistic, and report p-value.0.0 ptsNo Effort. No Hypothesis Tests were completed.20.0 ptsThis criterion is linked to a Learning OutcomePart II: Hypothesis Testing Analysis10.0 ptsProficient. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for ALL 4 Problems.8.0 ptsAbove Average. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 3 Problems.7.0 ptsAverage. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 2 Problems.5.0 ptsNeeds Improvement. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 1 Problem0.0 ptsNo Effort. No conclusion/explanations were given.10.0 ptsThis criterion is linked to a Learning OutcomePart II: Proposal and computations for new hypothesis test10.0 ptsProficient. Student creates an original Hypothesis Test based on one of the data sets highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.8.0 ptsProficient. Student creates an original Hypothesis Test based on one of the data sets correclty and has MOST of the content: highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.7.0 ptsAverage. Student creates an original Hypothesis Test based on one of the data sets and MISSING MOST of the content: highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.5.0 ptsNeeds Improvement. Student creates an original Hypothesis Test based on one of the data sets but there are multiple mistakes and/or conclusions are not valid.0.0 ptsNo Effort. The student did not propose/compute a new hypothesis test.10.0 ptsTotal Points: 90.0PreviousNextSubmission Submitted!Oct 13 at 7:21pmSubmission DetailsDownload Week 6 Statistics .docxDownload Week 3 Statistics Worksheet.xlsx(90 pts possible)Graded Anonymously: no View Rubric EvaluationComments:Part 2: MissingSHERRI HERNANDEZ, Oct 19 at 8:41am