(Solved): Module I Assignment - Descriptive Statistics Directions: Type final answers after each question on ...

Module I Assignment - Descriptive Statistics Directions: Type final answers after each question on Microsoft Word. Make sure to show formulas used in Microsoft Excel, which should also be attached. - Earn up to 20 points for accurately completing all parts of this problem. - Earn up to 5 points for turning assignment on time. - Worth a total of 25 points. Task: You will have to prepare descriptive statistics based on the Case Problem 2: Movie Theater Releases. You should see a Microsoft Excel document attached in the Module I Assignment link. 1. When looking at the top 100 movies of 2016, prepare these basic descriptive statistics on opening gross sales and total gross sales. You will need to show your Microsoft Excel formulas and place them to the right of the data so that they can be seen. (Worth 20 points) a. What is the mean, median, and mode of opening gross sales? (Worth 6 points) b. What is the mean and median of total gross sales? (Worth 4 points) c. Which movie has the highest total gross sales? Lowest total gross sales? (Worth 4 points) d. What is the variance of this sample for total gross sales (Worth 3 points) 0. What is the standard deviation of this sample? (Worth 3 points)