Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 5 (2 pts): See the list of top 50 Box Office gross movies of all time. Write a formula to figure the ranking of

Part 5 (2 pts): See the list of top 50 Box Office gross movies of all time. Write a formula to figure the ranking of each movie according to domestic gross and overseas gross. Then, write a formula to break the movies into the following categories: "Top 10 Domestic and Overseas", "Top 10 Domestic only", "Top 10 Overseas only", or "not Top 10"

WORLDWIDE BOX OFFICE GROSSES ($M)
Rank Title Studio Worldwide Domestic % of Gross Overseas % of Gross Year Domestic Rank Overseas Rank Top 10?
1 Avatar Fox $2,788.00 $760.50 27.30% $2,027.50 72.70% 2009
2 Titanic Par. $2,187.50 $659.40 30.10% $1,528.10 69.90% 1997
3 Star Wars: The Force Awakens BV $2,068.20 $936.70 45.30% $1,131.60 54.70% 2015
4 Jurassic World Uni. $1,671.70 $652.30 39.00% $1,019.40 61.00% 2015
5 Marvel's The Avengers BV $1,518.80 $623.40 41.00% $895.50 59.00% 2012
6 Furious 7 Uni. $1,516.00 $353.00 23.30% $1,163.00 76.70% 2015
7 Avengers: Age of Ultron BV $1,405.40 $459.00 32.70% $946.40 67.30% 2015
8 Harry Potter and the Deathly Hallows Part 2 WB $1,341.50 $381.00 28.40% $960.50 71.60% 2011
9 Frozen BV $1,276.50 $400.70 31.40% $875.70 68.60% 2013
10 Star Wars: The Last Jedi BV $1,269.00 $595.60 46.90% $673.40 53.10% 2017
11 Beauty and the Beast (2017) BV $1,263.50 $504.00 39.90% $759.50 60.10% 2017
12 The Fate of the Furious Uni. $1,236.00 $226.00 18.30% $1,010.00 81.70% 2017
13 Iron Man 3 BV $1,214.80 $409.00 33.70% $805.80 66.30% 2013
14 Minions Uni. $1,159.40 $336.00 29.00% $823.40 71.00% 2015
15 Captain America: Civil War BV $1,153.30 $408.10 35.40% $745.20 64.60% 2016
16 Transformers: Dark of the Moon P/DW $1,123.80 $352.40 31.40% $771.40 68.60% 2011
17 The Lord of the Rings: The Return of the King NL $1,119.90 $377.80 33.70% $742.10 66.30% 2003
18 Skyfall Sony $1,108.60 $304.40 27.50% $804.20 72.50% 2012
19 Transformers: Age of Extinction Par. $1,104.10 $245.40 22.20% $858.60 77.80% 2014
20 The Dark Knight Rises WB $1,084.90 $448.10 41.30% $636.80 58.70% 2012
21 Toy Story 3 BV $1,067.00 $415.00 38.90% $652.00 61.10% 2010
22 Pirates of the Caribbean: Dead Man's Chest BV $1,066.20 $423.30 39.70% $642.90 60.30% 2006
23 Rogue One: A Star Wars Story BV $1,056.10 $532.20 50.40% $523.90 49.60% 2016
24 Pirates of the Caribbean: On Stranger Tides BV $1,045.70 $241.10 23.10% $804.60 76.90% 2011
25 Despicable Me 3 Uni. $1,034.80 $264.60 25.60% $770.20 74.40% 2017
26 Jurassic Park Uni. $1,029.20 $402.50 39.10% $626.70 60.90% 1993
27 Finding Dory BV $1,028.60 $486.30 47.30% $542.30 52.70% 2016
28 Star Wars: Episode I - The Phantom Menace Fox $1,027.00 $474.50 46.20% $552.50 53.80% 1999
29 Alice in Wonderland (2010) BV $1,025.50 $334.20 32.60% $691.30 67.40% 2010
30 Zootopia BV $1,023.80 $341.30 33.30% $682.50 66.70% 2016
31 The Hobbit: An Unexpected Journey WB (NL) $1,021.10 $303.00 29.70% $718.10 70.30% 2012
32 The Dark Knight WB $1,004.60 $534.90 53.20% $469.70 46.80% 2008
33 Harry Potter and the Sorcerer's Stone WB $974.80 $317.60 32.60% $657.20 67.40% 2001
34 Despicable Me 2 Uni. $970.80 $368.10 37.90% $602.70 62.10% 2013
35 The Lion King BV $968.50 $422.80 43.70% $545.70 56.30% 1994
36 The Jungle Book (2016) BV $966.60 $364.00 37.70% $602.50 62.30% 2016
37 Pirates of the Caribbean: At World's End BV $963.40 $309.40 32.10% $654.00 67.90% 2007
38 Harry Potter and the Deathly Hallows Part 1 WB $960.30 $296.00 30.80% $664.30 69.20% 2010
39 The Hobbit: The Desolation of Smaug WB (NL) $958.40 $258.40 27.00% $700.00 73.00% 2013
40 The Hobbit: The Battle of the Five Armies WB (NL) $956.00 $255.10 26.70% $700.90 73.30% 2014
41 Finding Nemo BV $940.30 $380.80 40.50% $559.50 59.50% 2003
42 Harry Potter and the Order of the Phoenix WB $939.90 $292.00 31.10% $647.90 68.90% 2007
43 Harry Potter and the Half-Blood Prince WB $934.40 $302.00 32.30% $632.50 67.70% 2009
44 The Lord of the Rings: The Two Towers NL $926.00 $342.60 37.00% $583.50 63.00% 2002
45 Shrek 2 DW $919.80 $441.20 48.00% $478.60 52.00% 2004
46 Harry Potter and the Goblet of Fire WB $896.90 $290.00 32.30% $606.90 67.70% 2005
47 Spider-Man 3 Sony $890.90 $336.50 37.80% $554.30 62.20% 2007
48 Ice Age: Dawn of the Dinosaurs Fox $886.70 $196.60 22.20% $690.10 77.80% 2009
49 Spectre Sony $880.70 $200.10 22.70% $680.60 77.30% 2015
50 Spider-Man: Homecoming Sony $880.20 $334.20 38.00% $546.00 62.00% 2017

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ai And The Lottery Defying Odds With Intelligent Prediction

Authors: Gary Covella Ph D

1st Edition

B0CND1ZB98, 979-8223302568

More Books

Students also viewed these Databases questions