Review the data your coworker collected in the Analysis of t-Test Data Spreadsheet.First, plan your analysis. Second, conduct your analysis.Explain the followings:Part 1: PlanningWhat are the null and alternative hypotheses?Where did you obtain your data or who obtained it for you?Part 2: AnalysisWhat are the descriptive statistics for your sample? Include:Sample sizeMeanMedianModeStandard deviationPost a response to your classmate. Be constructive and professional.This is an answer from another student. I need a reply to their answer with a minimum of 100 words and without any references."The null hypothesis would be that there is no difference in contribution between managers or individual employees. The alternative hypothesis would be that there is a difference in contribution between managers and individual employees. The data for this analysis was obtained by a coworker, not sure the method that was used.The sample size is 53 individuals which consists of 25 managers and 28 individual contributors.The mean for managers is 59.24.The mean for individual contributors is 42.39The overall mean is 50.33The median for managers is 67.The mode for managers is 78, 54, 56, 67, 23.The median for individual contributors is 35.The mode for individual contributors is 23.The overall median is 45.The overall mode is 23.The standard deviation for this data group is 28.7According to the results, the null hypothesis is wrong since there is a difference in contribution between managers and individual employees."

Using excel and the 2017 Uniform Crime Report (UCR) contained in the module's folder, construct one graph that compares the violent crime rates in 2016 and 2017 for California, Connecticut, Florida, Illinois, New Mexico, New York, and Tennessee. Based on the text and aesthetic, it is up to you to decide the best graph to convey the information.

Your task is to write a 2 page Memo Report on the group you are assigned to from the "Product Material PivotTable" tab you created from Module 5 Project Assignment.Steps: 1. From the Material filter to your assigned group on Canvas (Gold, Silver or Copper). 2. From the Type filter select “Select All”.The Memo Report should contain information / analysis about the data you are viewing, which attributes were used, and what do the results indicate.PivotTable: Material Type Total Sales Grand TotalPivotChart: Column Chart Filter by Material Type Legend by yearsMemo Report Length: 2 Pages double spacedEnsure that you embed your unique copy of the PivotTable and PivotChart in your Memo Report from the worksheet. Then submit the Memo Report to Canvas. You may download a memo template from Microsoft Word in order to complete this assignment.