Description
Assignment Mini-Project 3-3
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. Use only Adventure, Crime and Horror
- Which genre had greater variability in total gross income? Explain why. Use the Interquartile ranges for Adventure, Crime, and Horror. See pgs.108 & ff., text)
- 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? Again, use only Adventure, Crime and Horror
Use the mean movie gross income for each genre to compare the movie opening gross income. Again, use only Adventure, Crime and Horror
Choose an appropriate statistical measure to compare the consistency of movie gross income. Use the Interquartile range for Adventure, Crime, and Horror
Make the calculations and write a 350-word report comparing the total movie gross income and the consistency of movie opening gross by genre.
Format your assignment consistent with APA guidelines.
I attached the spreadsheet with the movie data that is needed.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Mini-Project Movie Data Set The genre that generated more income was the action movies. The total gross collected from action movies was 4,399,334,570. Most people like action movies, unlike other genres. The results from the data collected were a clear indication of the taste and preference of most people in the world, even though the data was collected from a few studios. The statistics published indicate the kind of movies widely liked are action movies and the people in the military hence a new release of movies creates move of many people wanting to watch the movie. Several genes exist, but the level action movies generate to make the studio and theater people to equip their list with more of action movies than other genres. The analysis can be used by movie shop owners and other studio experts who stock movies and resell for the production entertainment departments. Businesses are set for profit, hence stocking more of action movies can be of great importance in increasing sales. Despite action movies having the greatest preference among the people, the other genres should be maintained in the market t ensure that the customers who like them do not miss something to watch should they walk into the studios or theater rooms. Having a balanced set of movies from different genres could help in accumulating income from the sale or watch of the various types of movies. A studio can have different shelves that have stocks of the all kinds of movies that can be managed by the attendant and issued to clients whenever requested, the analysis is done from the movie data set in the excel attached.
Running head: MINI-PROJECT MOVIE DATA SET
MINI-PROJECT MOVIE DATA SET
Student
Institution
MINI-PROJECT MOVIE DATA SET
1
Mini-Project Movie Data Set
The genre that generated more income was the action movies. The total gross collected
from action movies was 4,399,334,570. Most people like action movies, unlike other genres. The
results from the data collected were a clear indication of the taste and preference of most people
in the world, even though the data was collected from a few studios. The statistics published
indicate the kind of movies widely liked are action movies and the people in the military hence a
new release of movies creates move of many people wanting to watch the movie. Several genes
exist, but the level action movies generate to make the studio and theatre people to equip their
list with more of action movies than other genres.
The analysis can be used by movie shop owners and other studio experts who stock
movies and resell for the production entertainment departments. Businesses are set for profit,
hence stocking more of action movies can be of great importance in increasing sales. Despite
action movies having the greatest preference among the people, the other genres should be
maintained in the market t ensure that the customers who like them do not miss something to
watch should they walk into the studios or theater rooms. Having a balanced set of movies from
different genres could help in accumulating income from the sale or watch of the various types of
movies. A studio can have different shelves that have stocks of the all kinds of movies that can
be managed by the attendant and issued to clients whenever requested, the analysis is done from
the movie data set in the excel attached.
Movie Title
American Sniper
Studio
Warner Brothers
22 Jump Street
Sony
3 Days to Kill
Relativity
300: Rise of An Empire
Warner Brothers
A Most Violent Year
A24
Bang Bang
FIP
Brick Mansions
Captain America: The Winter Soldier
Dawn of the Planet of the Apes
Dracula Untold
Edge of Tomorrow
Relativity
Buena Vista
Fox
Universal
Warner Brothers
Exodus: Gods and Kings
Fox
Fury (2014)
Sony
Godzilla (2014)
Warner Brothers
Guardians of the Galaxy
Buena Vista
Hercules (2014)
Paramount
I, Frankenstein
Lionsgate
Into The Storm
Warner Brothers
Jack Ryan: Shadow Recruit
Kick
Left Behind (2014)
Lucy
Paramount
UTV Communications
Freestyle Releasing
Universal
Maleficent
Buena Vista
Need for Speed
Buena Vista
Noah
Paramount
Non-Stop
Universal
Persecuted
Millenium Entertainment
Pompeii
Ride Along
Tristar
Universal
RoboCop (2014)
Sony
Sabotage (2014)
Open Road Films
Snowpiercer
Teenage Mutant Ninja Turtles (2014)
Radius-TWC
Paramount
The Amazing Spider-Man 2
Sony
The Equalizer
Sony
The Giver
The Interview (2014)
The Legend of Hercules
The Maze Runner
Weinstein Company
Sony
Lionsgate
Fox
The November Man
Relativity
The Purge: Anarchy
Universal
Transformers: Age of Extinction
Vampire Academy
X-Men: Days of Future Past
Paramount
Weinstein Company
Fox
John Wick
Lionsgate
The Expendables 3
Lionsgate
The Raid 2
Sony Classics
As Above/So Below
Universal
Divergent
Lionsgate
Earth to Echo
Relativity
Interstellar
Paramount
Into the Woods
Buena Vista
Muppets Most Wanted
Buena Vista
Night at the Museum: Secret of the Tomb
The Admiral: Roaring Currents
The Grand Budapest Hotel
The Hobbit: The Battle of the Five Armies
The Hunger Games: Mockingjay - Part 1
Fox
CJ Entertainment
Fox Searchlight
Warner Brothers
Lionsgate
Big Hero 6
Buena Vista
Dragon Ball Z: Battle of Gods
Screenvision
How to Train Your Dragon 2
Fox
Legends of Oz: Dorothy's Return
Clarius Entertainment
Mr. Peabody & Sherman
Fox
Penguins of Madagascar
Fox
Planes: Fire & Rescue
Buena Vista
Rio 2
Fox
The Book of Life (2014)
Fox
The Boxtrolls
Focus Features
The LEGO Movie
Warner Brothers
The Nut Job
Open Road Films
The Wind Rises
Big Eyes
Buena Vista
Weinstein Company
Cantinflas
Lionsgate
Cesar Chavez
Lionsgate
Foxcatcher
Sony Classics
Get On Up
Universal
Gloria (2014)
Jersey Boys
Kill the Messenger
Roadside Attractions
Warner Brothers
Focus Features
Million Dollar Arm
Buena Vista
Mr. Turner
Sony Classics
Rosewater
Open Road Films
Selma
Son of God
Paramount
Fox
The Imitation Game
Weinstein Company
The Railway Man
Weinstein Company
The Theory of Everything
Unbroken
Wild (2014)
2 States
A Haunted House 2
A Million Ways to Die in the West
About Last Night (2014)
Focus Features
Universal
Fox Searchlight
UTV Communications
Open Road Films
Universal
Sony/Columbia
Alexander and the Terrible, Horrible, No Good, Very Bad Day
Buena Vista
Anchorman 2 (R-Rated Extended Cut)
Paramount
And So It Goes
Annie (2014)
Clarius Entertainment
Sony
Bad Words
Focus Features
Birdman
Fox Searchlight
Blended
Warner Brothers
Chef
Open Road Films
Dear White People
Dumb and Dumber To
Roadside Attractions
Universal
Fading Gigolo
Millenium Entertainment
Force Majeure
Magnolia
Ghostbusters (30th Anniversary re-release)
Sony
Horrible Bosses 2
Warner Brothers
Inherent Vice
Warner Brothers
Kirk Cameron's Saving Christmas
Samuel Goldwyn
Le Week-End
Music Box Films
Let's Be Cops
Fox
Magic in the Moonlight
Moms' Night Out
My Old Lady
Neighbors
Obvious Child
P.K.
Sony Classics
Tristar
Cohen Media Group
Universal
A24
UTV Communications
Pride (2014)
CBS
Sex Tape
Sony
St. Vincent
Tammy
That Awkward Moment
The Fluffy Movie
The Grand Seduction
Weinstein Company
Warner Brothers
Focus Features
Open Road Films
Entertainment One
The Hundred-Foot Journey
Buena Vista
The Other Woman (2014)
Fox
The Skeleton Twins
The Trip to Italy
Think Like a Man Too
This is Where I Leave You
Top Five
Tusk
Tyler Perry's The Single Moms Club
What If (2014)
Wish I Was Here
Roadside Attractions
IFC
Sony/Columbia
Warner Brothers
Paramount
A24
Lionsgate
CBS
Focus Features
Words and Pictures
Roadside Attractions
A Most Wanted Man
Roadside Attractions
A Walk Among the Tombstones
Universal
No Good Deed (2014)
Sony/Columbia
The Drop
Fox Searchlight
The Gambler
Paramount
The Judge
Warner Brothers
Veronica Mars
Warner Brothers
Frank Miller's Sin City: A Dame to Kill For
Nightcrawler
America (2014)
Awake: The Life of Yogananda
Bears
Weinstein Company
Open Road Films
Lionsgate
Counterpoint Films
Buena Vista
Citizenfour
Radius-TWC
Fed Up
Radius-TWC
Finding Vivian Maier
Island of Lemurs: Madagascar (IMAX)
Meet the Mormons
Tim's Vermeer
2014 Oscar Nominated Short Films
Addicted
IFC
Warner Brothers
Purdie Distribution
Sony Classics
Shorts International
Lionsgate
Before I Go To Sleep
Clarius Entertainment
Begin Again
Weinstein Company
Belle
Fox Searchlight
Beyond the Lights
Boyhood
Calvary
Dolphin Tale 2
Relativity
IFC
Fox Searchlight
Warner Brothers
Draft Day
Lionsgate
Endless Love (2014)
Universal
Gimme Shelter
God's Not Dead
Gone Girl
Heaven is for Real
Roadside Attractions
Freestyle Releasing
Fox
Tristar
Ida
Music Box Films
If I Stay
Warner Brothers
Labor Day
Locke
Love is Strange
Mommy
Ode to My Father
Only Lovers Left Alive
Paramount
A24
Sony Classics
Roadside Attractions
CJ Entertainment
Sony Classics
Step Up All In
Lionsgate
The Best of Me
Relativity
The Fault in our Stars
The Good Lie
The Homesman
The Identical
Fox
Warner Brothers
Saban Films
Freestyle Releasing
The Immigrant
Weinstein Company
The Lunchbox
Sony Classics
The Monuments Men
Transcendence
Sony
Warner Brothers
Two Days, One Night
IFC
Under the Skin (2014)
A24
When the Game Stands Tall
Whiplash
Tristar
Sony Classics
Winter's Tale
Warner Brothers
Annabelle
Warner Brothers
Deliver Us From Evil
Devil's Due
Sony/Columbia
Fox
Oculus
Relativity
Ouija
Universal
Paranormal Activity: The Marked Ones
The Pyramid
Paramount
Fox
The Quiet Ones
Lionsgate
Total Gross
Total Theaters
Opening Gross
Opening Theaters
Genre
4
Action
350.126.372
3.885
633.456
191.719.337
3.426
57.071.445
3.306
Action
30.697.999
2.872
12.242.218
2.872
Action
106.580.051
3.490
45.038.460
3.470
Action
4
Action
5.749.134
818
172.788
2.546.172
271
1.278.690
271
Action
20.396.829
2.647
9.516.855
2.647
Action
259.766.572
3.938
95.023.721
3.938
Action
208.545.589
3.969
72.611.427
3.967
Action
56.280.355
2.900
23.514.615
2.885
Action
100.206.256
3.505
28.760.246
3.490
Action
65.014.513
3.503
24.115.934
3.503
Action
85.817.906
3.313
23.702.421
3.173
Action
200.676.069
3.952
93.188.384
3.952
Action
333.176.600
4.088
94.320.883
4.080
Action
72.688.614
3.595
29.800.263
3.595
Action
19.075.290
2.753
8.610.441
2.753
Action
47.602.194
3.434
17.346.427
3.434
Action
50.577.412
3.387
15.451.981
3.387
Action
2.472.695
180
1.071.373
180
Action
14.019.924
1.887
6.300.147
1.825
Action
126.663.600
3.202
43.899.340
3.173
Action
241.410.378
3.948
69.431.298
3.948
Action
43.577.636
3.115
17.844.939
3.115
Action
101.200.044
3.571
43.720.472
3.567
action
92.168.600
3.183
28.875.635
3.090
Action
1.558.836
736
736
Action
23.219.748
2.658
10.340.823
2.658
Action
134.938.200
2.867
41.516.170
2.663
Action
58.607.007
3.372
21.681.430
3.372
Action
10.508.518
2.486
5.272.444
2.486
Action
4.563.650
356
8
Action
851.391
171.187
191.204.754
3.980
65.575.105
3.845
Action
202.853.933
4.324
91.608.337
4.324
Action
101.530.738
3.236
34.137.828
3.236
Action
45.090.374
3.003
12.305.016
3.003
Action
6.105.175
581
1.794.666
331
Action
18.848.538
2.104
8.868.318
2.104
Action
102.427.862
3.638
32.512.804
3.604
Action
25.018.119
2.776
7.911.597
2.776
Action
71.962.800
2.856
29.816.675
2.805
Action
245.439.076
4.233
100.038.390
4.233
Action
7.791.979
2.676
3.921.742
2.676
Action
233.921.534
4.001
90.823.660
3.996
Action
43.037.835
2.589
14.415.922
2.589
Action
39.322.544
3.221
15.879.645
3.221
Action
2.627.209
954
7
Action
21.321.100
2.650
8.632.820
2.640
Adventure
150.947.895
3.936
54.607.747
3.936
Adventure
38.934.842
3.230
8.364.658
3.230
Adventure
188.020.017
3.561
47.510.360
3.561
Adventure
128.002.372
2.833
31.051.923
2.440
Adventure
51.183.113
3.194
17.005.126
3.194
Adventure
113.729.151
3.914
17.100.520
3.785
Adventure
165.292
2.589.811
45
51.431
1
Adventure
59.100.318
1.467
811.166
4
Adventure
255.119.788
3.875
54.724.334
3.875
Adventure
337.135.885
4.151
121.897.634
4.151
Adventure
222.527.828
3.773
56.215.889
3.761
Animation
62
Animation
2.553.002
692
296.414
177.002.924
4.268
49.451.322
4.253
Animation
8.462.027
2.658
3.747.780
2.658
Animation
111.506.430
3.951
32.207.057
3.934
Animation
83.350.911
3.775
25.447.444
3.764
Animation
59.165.787
3.839
17.509.407
3.826
Animation
131.538.435
3.975
39.327.869
3.948
Animation
50.151.543
3.113
17.005.218
3.071
Animation
50.837.305
3.464
17.275.239
3.464
Animation
257.760.692
3.890
69.050.279
3.775
Animation
64.251.541
3.472
19.423.000
3.427
Animation
5.209.580
496
21
Animation
14.482.031
1.408
3.001.738
1.307
Biography
6.382.924
429
2.661.253
382
Biography
5.571.497
664
2.861.528
664
Biography
12.096.300
759
270.877
6
Biography
30.703.100
2.469
2.468
Biography
2.107.925
110
3
Biography
47.047.013
2.905
2.905
Biography
2.450.846
427
374
Biography
313.751
13.585.915
56.454
13.319.371
941.809
36.457.627
3.019
3.019
Biography
3.958.500
120
109.000
5
Biography
3.128.941
371
1.154.303
371
Biography
52.076.908
2.235
571.450
19
Biography
59.700.064
3.271
25.601.865
3.260
Biography
91.125.683
2.402
479.352
4
Biography
4.438.438
600
61.845
4
Biography
35.893.537
1.220
208.763
5
Biography
115.637.895
3.301
30.621.445
3.131
Biography
37.880.356
1.361
606.810
21
Biography
2.238.174
137
1.073.898
135
Comedy
17.329.486
2.310
8.843.875
2.310
Comedy
43.139.300
3.160
16.797.385
3.158
Comedy
48.637.684
2.253
25.649.011
2.253
Comedy
66.954.149
3.117
18.360.230
3.088
Comedy
2.184.339
1.317
1.358.833
1.317
Comedy
15.160.801
1.816
4.642.329
1.762
Comedy
85.911.262
3.197
15.861.939
3.116
Comedy
7.779.614
1.074
113.301
6
Comedy
42.340.598
1.213
424.397
4
Comedy
46.294.610
3.555
14.284.031
3.555
Comedy
31.424.003
1.298
204.961
6
Comedy
4.404.154
393
347.959
11
Comedy
86.208.010
3.188
3.154
Comedy
3.769.873
356
180.801
5
Comedy
1.359.497
68
23.309
2
Comedy
3.580.343
784
1.756.513
784
Comedy
54.445.357
3.400
15.457.418
3.375
Comedy
8.110.975
653
328.184
5
Comedy
2.783.970
410
992.087
410
Comedy
2.225.098
157
43.608
3
Comedy
82.390.774
3.140
3.094
Comedy
10.539.326
964
17
Comedy
10.429.707
1.046
1.044
Comedy
4.013.786
273
11
Comedy
3.279
Comedy
3
Comedy
150.157.400
3.311
10.515.659
36.111.775
17.813.722
412.095
4.311.083
124.680
49.033.915
3.123.963
202
77.315
10.616.104
272
3.565.258
272
Comedy
1.446.634
124
100.040
10
Comedy
38.543.473
3.062
3.062
Comedy
14.608.152
44.137.712
2.552
109.878
4
Comedy
84.525.432
3.465
21.577.049
3.465
Comedy
26.068.955
2.809
8.742.109
2.809
Comedy
2.827.393
432
1.311.446
432
Comedy
3.430.018
124
323.743
94
Comedy
54.240.821
2.167
10.979.290
2.023
Comedy
83.911.193
3.306
24.763.752
3.205
Comedy
5.284.309
461
380.691
15
Comedy
2.880.537
199
71.712
3
Comedy
65.182.182
2.225
29.241.911
2.225
Comedy
34.296.320
2.868
11.558.149
2.868
Comedy
25.317.291
1.426
6.896.593
979
Comedy
1.826.705
602
846.831
602
Comedy
15.973.881
1.896
1.896
Comedy
3.493.000
787
133.898
20
Comedy
3.591.299
753
484.401
68
Comedy
2.171.257
216
87.879
10
Comedy
17.237.855
801
2.687.227
361
Crime
26.307.600
2.714
12.758.780
2.712
Crime
52.543.632
2.175
24.250.283
2.175
Crime
10.724.389
1.192
4.104.552
809
Crime
33.680.992
2.494
9.129.999
2.478
Crime
47.119.388
3.003
13.116.226
3.003
Crime
3.322.127
347
1.988.351
291
Crime
13.757.804
2.894
6.317.683
2.894
Crime
32.381.217
2.766
10.441.000
2.766
Crime
14.444.502
1.105
38.608
3
Documentary
1.539.680
21
18.885
1
Documentary
17.780.194
1.790
1.720
Documentary
2.799.318
105
126.321
5
Documentary
1.538.899
104
126.028
18
Documentary
1.514.782
97
63.600
3
Documentary
10.422.129
302
188.307
37
Documentary
6.047.363
333
2.509.8...