The file P02_02.xlsx contains information on 256 movies that grossed at least $1 million in 2017. Rank
Question:
The file P02_02.xlsx contains information on 256 movies that grossed at least $1 million in 2017.
Rank | Movie | Release Date | Distributor | Recoded Distributor | Genre | Recoded Genre | MPAA | 2017 Gross | Tickets Sold | |
1 | Star Wars Ep. VIII: The Last Jedi | 12/15/2017 | Walt Disney | Walt Disney | Adventure | Adventure | PG-13 | $517,218,368 | 57,660,910 | |
2 | Beauty and the Beast | 3/17/2017 | Walt Disney | Walt Disney | Musical | Other | PG | $504,014,165 | 56,188,870 | |
3 | Wonder Woman | 6/2/2017 | Warner Bros. | Warner Bros. | Action | Action | PG-13 | $412,563,408 | 45,993,691 | |
4 | Guardians of the Galaxy Vol 2 | 5/5/2017 | Walt Disney | Walt Disney | Action | Action | PG-13 | $389,813,101 | 43,457,424 | |
5 | Spider-Man: Homecoming | 7/7/2017 | Sony Pictures | Sony Pictures | Action | Action | PG-13 | $334,201,140 | 37,257,652 | |
6 | It | 9/8/2017 | Warner Bros. | Warner Bros. | Horror | Horror | R | $327,481,748 | 36,508,556 | |
7 |
| 11/3/2017 | Walt Disney | Walt Disney | Action | Action | PG-13 | $311,225,150 | 34,696,226 | |
8 | Despicable Me 3 | 6/30/2017 | Universal | Universal | Adventure | Adventure | PG | $264,624,300 | 29,501,036 | |
9 | Logan | 3/3/2017 | 20th Century Fox | 20th Century Fox | Action | Action | R | $226,277,068 | 25,225,983 | |
10 | The Fate of the Furious | 4/14/2017 | Universal | Universal | Action | Action | PG-13 | $225,764,765 | 25,168,870 | |
11 | Justice League | 11/17/2017 | Warner Bros. | Warner Bros. | Action | Action | PG-13 | $225,546,295 | 25,144,514 | |
12 | Dunkirk | 7/21/2017 | Warner Bros. | Warner Bros. | Action | Action | PG-13 | $188,373,161 | 21,000,352 | |
13 | Coco | 11/22/2017 | Walt Disney | Walt Disney | Musical | Other | PG | $179,834,199 | 20,048,405 | |
14 | The Lego Batman Movie | 2/10/2017 | Warner Bros. | Warner Bros. | Adventure | Adventure | PG | $175,750,384 | 19,593,131 | |
15 | Get Out | 2/24/2017 | Universal | Universal | Horror | Horror | R | $175,484,140 | 19,563,449 | |
16 | The Boss Baby | 3/31/2017 | 20th Century Fox | 20th Century Fox | Adventure | Adventure | PG | $175,003,033 | 19,509,814 | |
17 | Pirates of the Caribbean: Dead Men Tell No Tales | 5/26/2017 | Walt Disney | Walt Disney | Adventure | Adventure | PG-13 | $172,558,876 | 19,237,332 | |
18 | Jumanji: Welcome to the Jungle | 12/20/2017 | Sony Pictures | Sony Pictures | Adventure | Adventure | PG-13 | $169,002,557 | 18,840,864 | |
19 | Kong: Skull Island | 3/10/2017 | Warner Bros. | Warner Bros. | Adventure | Adventure | PG-13 | $168,052,812 | 18,734,985 | |
20 | Hidden Figures | 12/25/2016 | 20th Century Fox | 20th Century Fox | Drama | Drama | PG | $167,620,331 | 18,686,770 | |
21 | Cars 3 | 6/16/2017 | Walt Disney | Walt Disney | Adventure | Adventure | G | $152,901,115 | 17,045,832 | |
22 | War for the Planet of the Apes | 7/14/2017 | 20th Century Fox | 20th Century Fox | Action | Action | PG-13 | $146,880,162 | 16,374,600 | |
23 | Split | 1/20/2017 | Universal | Universal | Horror | Horror | PG-13 | $138,141,585 | 15,400,399 | |
24 | Transformers: The Last Knight | 6/21/2017 | Paramount Pictures | Paramount Pictures | Action | Action | PG-13 | $130,168,683 | 14,511,558 | |
25 | Wonder | 11/17/2017 | Lionsgate | Lionsgate | Drama | Drama | PG | $121,559,294 | 13,551,760 | |
26 | La La Land | 12/9/2016 | Lionsgate | Lionsgate | Musical | Other | PG-13 | $116,833,190 | 13,024,881 | |
27 | Girls Trip | 7/21/2017 | Universal | Universal | Comedy | Comedy | R | $115,108,515 | 12,832,610 | |
28 | Fifty Shades Darker | 2/10/2017 | Universal | Universal | Drama | Drama | R | $114,434,010 | 12,757,414 | |
29 | Baby Driver | 6/28/2017 | Sony Pictures | Sony Pictures | Thriller/Suspense | Thriller/Suspense | R | $107,825,862 | 12,020,720 | |
30 | Rogue One: A Star Wars Story | 12/16/2016 | Walt Disney | Walt Disney | Adventure | Adventure | PG-13 | $107,189,617 | 11,949,790 | |
31 | Sing | 12/21/2016 | Universal | Universal | Adventure | Adventure | PG | $103,831,225 | 11,575,387 | |
32 | Annabelle: Creation | 8/11/2017 | Warner Bros. | Warner Bros. | Horror | Horror | R | $102,092,201 | 11,381,516 | |
33 | Daddy’s Home 2 | 11/10/2017 | Paramount Pictures | Paramount Pictures | Comedy | Comedy | PG-13 | $101,791,381 | 11,347,980 | |
34 | Murder on the Orient Express | 11/10/2017 | 20th Century Fox | 20th Century Fox | Drama | Drama | PG-13 | $100,619,624 | 11,217,349 | |
35 | Kingsman: The Golden Circle | 9/22/2017 | 20th Century Fox | 20th Century Fox | Action | Action | R | $100,227,039 | 11,173,583 | |
36 | John Wick: Chapter Two | 2/10/2017 | Lionsgate | Lionsgate | Action | Action | R | $92,029,184 | 10,259,663 | |
37 | Blade Runner 2049 | 10/6/2017 | Warner Bros. | Warner Bros. | Thriller/Suspense | Thriller/Suspense | R | $91,654,512 | 10,217,894 | |
38 | The Emoji Movie | 7/28/2017 | Sony Pictures | Sony Pictures | Adventure | Adventure | PG | $86,089,513 | 9,597,493 | |
39 | Power Rangers | 3/24/2017 | Lionsgate | Lionsgate | Action | Action | PG-13 | $85,364,450 | 9,516,661 | |
40 | The Mummy | 6/9/2017 | Universal | Universal | Adventure | Adventure | PG-13 | $80,101,125 | 8,929,891 | |
41 | The Hitman’s Bodyguard | 8/18/2017 | Lionsgate | Lionsgate | Action | Action | R | $75,468,583 | 8,413,442 | |
42 | Alien: Covenant | 5/19/2017 | 20th Century Fox | 20th Century Fox | Horror | Horror | R | $74,262,031 | 8,278,933 | |
43 | Captain Underpants: The First Epic Movie | 6/2/2017 | 20th Century Fox | 20th Century Fox | Adventure | Adventure | PG | $73,921,000 | 8,240,914 | |
44 | A Bad Moms Christmas | 11/1/2017 | STX Entertainment | Other | Comedy | Comedy | R | $71,891,988 | 8,014,714 | |
45 | A Dog’s Purpose | 1/27/2017 | Universal | Universal | Drama | Drama | PG | $64,321,890 | 7,170,779 | |
46 | Pitch Perfect 3 | 12/22/2017 | Universal | Universal | Comedy | Comedy | PG-13 | $63,300,605 | 7,056,923 | |
47 | The Lego Ninjago Movie | 9/22/2017 | Warner Bros. | Warner Bros. | Adventure | Adventure | PG | $59,281,555 | 6,608,869 | |
48 | Baywatch | 5/25/2017 | Paramount Pictures | Paramount Pictures | Comedy | Comedy | R | $58,060,186 | 6,472,707 | |
49 | The Shack | 3/3/2017 | Lionsgate | Lionsgate | Drama | Drama | PG-13 | $57,386,418 | 6,397,593 | |
50 | Happy Death Day | 10/13/2017 | Universal | Universal | Thriller/Suspense | Thriller/Suspense | PG-13 | $55,683,845 | 6,207,786 | |
51 | Ferdinand | 12/15/2017 | 20th Century Fox | 20th Century Fox | Adventure | Adventure | PG | $53,546,717 | 5,969,533 | |
52 | Atomic Blonde | 7/28/2017 | Focus Features | Other | Thriller/Suspense | Thriller/Suspense | R | $51,573,925 | 5,749,601 | |
53 | American Made | 9/29/2017 | Universal | Universal | Thriller/Suspense | Thriller/Suspense | R | $51,342,000 | 5,723,745 | |
54 | The Dark Tower | 8/4/2017 | Sony Pictures | Sony Pictures | Western | Other | PG-13 | $50,701,325 | 5,652,322 | |
55 | The Greatest Showman | 12/20/2017 | 20th Century Fox | 20th Century Fox | Musical | Other | PG | $49,036,718 | 5,466,746 | |
56 | Tyler Perry’s Boo 2! A Madea Halloween | 10/20/2017 | Lionsgate | Lionsgate | Comedy | Comedy | PG-13 | $47,319,572 | 5,275,314 | |
57 | Lion | 11/25/2016 | Weinstein Co. | Other | Drama | Drama | PG-13 | $46,435,795 | 5,176,789 | |
58 | Snatched | 5/12/2017 | 20th Century Fox | 20th Century Fox | Comedy | Comedy | R | $45,852,178 | 5,111,726 | |
59 | The Great Wall | 2/17/2017 | Universal | Universal | Action | Action | PG-13 | $45,157,105 | 5,034,236 | |
60 | Smurfs: The Lost Village | 4/7/2017 | Sony Pictures | Sony Pictures | Adventure | Adventure | PG | $45,020,282 | 5,018,984 | |
61 | Going in Style | 4/7/2017 | Warner Bros. | Warner Bros. | Comedy | Comedy | PG-13 | $45,018,541 | 5,018,789 | |
62 | All Eyez on Me | 6/16/2017 | Lionsgate | Lionsgate | Drama | Drama | R | $44,922,302 | 5,008,060 | |
63 | xXx: Return of Xander Cage | 1/20/2017 | Paramount Pictures | Paramount Pictures |
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Business Analytics Data Analysis And Decision MakingISBN: 9780357109953 7th Edition Authors: S. Christian Albright, Wayne L. Winston
Question Posted:
|