Purpose of 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.
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 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.
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. Please see below numbers to create the graphs including a BOX AND WHISKER PLOT with a couple others. The Graphs and 700-Word paper please put together on one paper. Thank you.
Genre N Mean Standard Deviation Median Minimum Maximum
Action 47 116.28 19.51 122 89 165
Adventure 11 119.45 24.63 123 91 169
Animation 13 95.92 11.26 95 83 126
Biography 18 122.39 14.472 123.5 102 150
Comedy 47 106.76 16.49 105 80 153
Crime 9 111.55 15.47 111 84 141
Documentary 9 84 21 83 39 114
Drama 38 111.76 15.8 110 82 165
Horror 8 96.25 11.03 93.5 84 118