Assignment:
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.
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.
Answer following questions based on an analysis of the data:
1. What are the mean, standard deviation, five-number summary, and interquartile range of the total gross income for each movie genre. You can create a table with these results.
2. Based on the previous information, which genre had greater variability in total gross income?
3. Draw a box-and-whisker plot of a movie's length of time (minutes) by genre.
4. Are there any any outliers in the data. If so, which ones?