Easy work to do

• See Chapter 3, Case Problem #2: Movie Theater Releases, and download the data file (attached).
• Part 1: Add additional columns and create formulas to show, for each movie:Average opening weekend sales per theaterAverage total sales per theaterAverage sales per weekApply conditional formatting to the “average sales per week” column to highlight (in green) any movies that averaged over $20M per week.
• Part 2: Use the tabular and graphical methods of descriptive statistics to learn how these variables contribute to the success of a motion picture. Include the following in your report.Tabular and graphical summaries for each of the four variables along with a discussion of what each summary tells us about the movies that are released to theaters.A scatter diagram to explore the relationship between total gross sales and opening weekend gross sales.A scatter diagram to explore the relationship between total gross sales and number of theaters.A scatter diagram to explore the relationship between total gross sales and number of weeks in release.
• Add a new sheet and rename the tab “Summary” and complete the following:In cell A1, type the movie with the highest average sales per theater.In cell A2, type the movie with the highest average sales week.Copy your “Total Gross Sales and Opening Weekend Gross Sales” diagram to your Summary sheet. In cell A3, type any observations or takeaways you learn from this diagram.

Movie Title
Rogue One: A Star Wars Story
Finding Dory
Captain America: Civil War
The Secret Life of Pets
The Jungle Book (2016)
Deadpool
Zootopia
Batman v Superman: Dawn of Justice
Suicide Squad
Sing
Moana
Fantastic Beasts and Where To Find Them
Doctor Strange
Hidden Figures
Jason Bourne
Star Trek Beyond
X-Men: Apocalypse
Trolls
La La Land
Kung Fu Panda 3
Ghostbusters (2016)
Central Intelligence
The Legend of Tarzan
Sully
Bad Moms
The Angry Birds Movie
Independence Day: Resurgence
The Conjuring 2
Arrival
Passengers (2016)
Sausage Party
The Magnificent Seven (2016)
Ride Along 2
Don’t Breathe
Miss Peregrine’s Home for Peculiar Children
The Accountant
Teenage Mutant Ninja Turtles: Out of the Shadows
The Purge: Election Year
Alice Through the Looking Glass
Pete’s Dragon (2016)
The Girl on the Train (2016)
Opening Gross Total Gross Sales Number of
Sales ($ millions)
($ millions)
Theaters
155.08
532.18
4,157
135.06
486.3
4,305
179.14
408.08
4,226
104.35
368.38
4,381
103.26
364
4,144
132.43
363.07
3,856
75.06
341.27
3,959
166.01
330.36
4,256
133.68
325.1
4,255
35.26
270.4
4,029
56.63
248.76
3,875
74.4
234.04
4,144
85.06
232.64
3,882
0.52
169.61
3,416
59.22
162.43
4,039
59.25
158.85
3,928
65.77
155.44
4,153
46.58
153.71
4,066
0.88
151.1
3,236
41.28
143.53
3,987
46.02
128.35
3,963
35.54
127.44
3,508
38.53
126.64
3,591
35.03
125.07
3,955
23.82
113.26
3,215
38.16
107.51
3,932
41.04
103.14
4,130
40.41
102.47
3,356
24.07
100.55
3,115
14.87
100.01
3,478
34.26
97.69
3,135
34.7
93.43
3,696
35.24
91.22
3,192
26.41
89.22
3,384
28.87
87.24
3,835
24.71
86.26
3,402
35.32
82.05
4,071
31.52
79.21
2,821
26.86
77.04
3,763
21.51
76.23
3,702
24.54
75.4
3,241
Boo! A Madea Halloween
Storks
10 Cloverfield Lane
Lights Out
Hacksaw Ridge
The Divergent Series: Allegiant
Now You See Me 2
Ice Age: Collision Course
The Boss
London Has Fallen
Miracles from Heaven
Deepwater Horizon
Why Him?
My Big Fat Greek Wedding 2
Jack Reacher: Never Go Back
Fences
Me Before You
The BFG
Neighbors 2: Sorority Rising
The Shallows
Office Christmas Party
Assassin’s Creed
Barbershop: The Next Cut
13 Hours: The Secret Soldiers of Benghazi
Lion
The Huntsman: Winter’s War
Kubo and the Two Strings
Manchester by the Sea
Warcraft
How to Be Single
Mike and Dave Need Wedding Dates
War Dogs
Almost Christmas
Money Monster
Allied
Nerve
Risen
The Nice Guys
The Boy (2016)
Dirty Grandpa
Ouija: Origin of Evil
The 5th Wave
Inferno
Mother’s Day
28.5
21.31
24.73
21.69
15.19
29.03
22.38
21.37
23.59
21.64
14.81
20.22
11
17.86
22.87
0.13
18.72
18.78
21.76
16.8
16.89
10.28
20.24
16.19
0.12
19.45
12.61
0.26
24.17
17.88
16.63
14.69
15.13
14.79
12.7
9.45
11.8
11.2
10.78
11.11
14.07
10.33
14.86
8.37
73.21
72.68
72.08
67.27
67.21
66.18
65.08
64.06
63.29
62.68
61.71
61.43
60.32
59.69
58.7
57.68
56.25
55.48
55.46
55.12
54.77
54.65
54.03
52.85
51.74
48.39
48.02
47.7
47.37
46.84
46.01
43.03
42.16
41.01
40.1
38.58
36.88
36.26
35.82
35.59
35.14
34.92
34.34
32.49
2,299
3,922
3,427
2,835
2,971
3,740
3,232
3,997
3,495
3,492
3,155
3,403
3,008
3,179
3,780
2,368
2,762
3,392
3,416
2,962
3,210
2,996
2,676
2,917
1,802
3,802
3,279
1,213
3,406
3,357
3,008
3,258
2,379
3,104
3,160
2,538
2,915
2,865
2,671
2,912
3,168
2,908
3,576
3,291
Patriots Day
Gods of Egypt
Collateral Beauty
Hail, Caesar!
When the Bough Breaks
Zoolander 2
Moonlight (2016)
The Finest Hours
Florence Foster Jenkins
Hell or High Water
The Forest
Ben-Hur (2016)
The Witch
Bridget Jones’s Baby
Kevin Hart: What Now?
0.16
14.12
7.1
11.36
14.2
13.84
0.4
10.29
6.6
0.62
12.74
11.2
8.8
8.57
11.77
31.89
31.15
31.02
30.5
29.75
28.85
27.85
27.57
27.38
27.01
26.59
26.41
25.14
24.25
23.59
3,120
3,117
3,028
2,248
2,246
3,418
1,564
3,143
1,528
1,505
2,509
3,084
2,204
2,930
2,567
Weeks in
Release
20
25
20
25
24
18
22
12
14
20
22
19
19
46
21
13
9
21
20
25
17
11
11
20
13
17
12
11
17
17
19
15
22
17
19
13
14
15
14
18
12
9
16
12
10
18
11
11
15
17
13
18
11
13
9
12
15
11
15
8
14
7
11
13
10
24
15
15
23
13
9
14
9
9
12
9
10
13
11
10
8
10
18
12
7
11
11
8
21
10
7
28
10
11
14
10
7
14
13
9