Mini-Project 3-3: Relationship Of Averages And Standard Deviation

Order 100% Plagiarism free paper

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 Steps
Refer 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.