This assignment provided students with practice in understanding the relationship of averages and standard deviation to make an informed business decision about the gross income performance of each movie genre. Students will learn to implement the use of these statistical measures for better business decision-making.Resources:ÿWeek 2 Videos; Week 2 Readings; Statistics LabÿTutorial help on Excel?ÿand Word functions can be found on the Microsoft?ÿOffice website. There are also additional tutorials via the web offering support for Office products.Assignment StepsReferÿto Mini-Project Movie Data Set.ÿAnalyzeÿandÿwriteÿa report summarizing this data. This report should include answers to at least the following questions:ÿCalculate the summary measures (the mean, standard deviation, five-number summary, and interquartile range) of the total gross income for each movie genre.Which genre had greater variability in total gross income?ÿ Explain why.Draw a box-and-whisker plot of a movie’s length of time (minutes) by genre. Are there any differences in movie lengths when compared across genres? Are there any outliers?Useÿthe mean movie gross income for each genre to compare the movie opening gross income.Chooseÿan appropriate statistical measure to compare the consistency of movie gross income.ÿMakeÿthe calculations andÿwriteÿa 700-word report comparing the total movie gross income and the consistency of movie opening gross by genre.Formatÿyour assignment consistent with APA guidelines.