Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started