Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Attached.
Running Head: STATISTICAL DATA ANALYSIS
STATISTICAL DATA ANALYSIS
Name
Professor
Course
Date
1
STATISTICAL DATA ANALYSIS
2
STATISTICAL DATA ANALYSIS
Microsoft excel was used to analyze the data set and descriptive statistics was used to
evaluate the individual statistical parameters foe the summary measures of the total gross income
for each movie genre. The data set was firs filtered and categorized according type of genre that
each movie belonged to. The results of the analysis are shown below along with the mean,
standard deviation, first quartile, median, third quartile, maximum and the interquartile range for
the total gross income of each movie genre.
3rd
Quartile
Maximum
Interquartile
Range
58607007
130,800,900
350126372
111,064,841
45,058,978
113729151
169483956
350126372
124,424,978
2553002
50151543
64251541
131538435
257760692
81386892
32675664.09
2107925
4721703
22592565.5
44755348.75
115637895
40033645.75
28653207.85
33263412.48
1359497
3461509
10616104
45216161
150157400
41754652
237,075,004
26341667.11
16671949.76
3322127
13757804
26307600
33680992
52543632
19923188
57,758,244
6417582.667
6294492.382
1514782
1539680
2799318
10422129
17780194
8882449
Drama
929,595,121
244...
