excel question 3,2

profileBayhawks22
Week3ExcelAssignment2.xlsx
Home>Reading homework help>excel question 3,2

Instructions

Instructions
Add two new columns: "Total Box Office" and "% of Domestic Share"
Calculate Total Box Office and % of Domestic Share
Create the following Pivot Tables:
Distributor
Pivot Table showing Total Box Office by Distributor with % of Sum Column
Pivot Table showing Average Box Office per Movie by Distributor
Pivot Table showing Total Box Office by Distributor by Month in outline form
Month
Pivot Table showing Total Box Office by Month with % of Sum Column (rename to % of Grand Total), sort by % of Grand Total
Pivot Table showing Total Box Office by Month by Movie in outline form with Subtotal rows at the bottom of each month
Same Pivot Table as above but sort chronologically by month and then in descending order by % of Grand Total
Create charts for:
Total Box Office by Distributor
Total Box Office by Distributor by Month

Box Office Data

Movie Domestic Box Office International Box Office Distributor Release Month
A Dog’s Journey $ 22,546,590 $ 51,940,808 Universal May
A Dog’s Way Home $ 41,952,715 $ 39,198,286 Sony Pictures January
Abominable $ 59,357,510 $ 109,028,543 Universal September
Ad Astra $ 50,005,312 $ 74,224,231 20th Century Fox September
After $ 12,138,565 $ 45,951,960 Aviron Pictures April
Aladdin $ 355,559,216 $ 682,500,000 Walt Disney May
Alita: Battle Angel $ 85,710,210 $ 317,261,058 20th Century Fox February
Angel Has Fallen $ 69,030,436 $ 60,932,874 Lionsgate August
Annabelle Comes Home $ 74,152,591 $ 154,400,000 Warner Bros. June
Avengers: Endgame $ 858,373,000 $ 1,937,100,000 Walt Disney April
Bai She: Yuan Qi $ 61,597,048
Boonie Bears:Blast Into The Past $ 106,825,451
Breakthrough $ 40,713,082 $ 8,309,745 20th Century Fox April
Captain Marvel $ 426,829,839 $ 699,300,000 Walt Disney March
Child’s Play $ 29,208,403 $ 14,295,990 Orion Pictures June
Cold Pursuit $ 32,138,862 $ 30,460,297 Lionsgate February
Crawl $ 39,014,193 $ 51,000,000 Paramount Pictures July
Da Ren Wu $ 56,040,680
Dark Phoenix $ 65,845,974 $ 180,510,921 20th Century Fox June
Doctor Sleep $ 18,070,840 $ 19,878,280 Warner Bros. November
Dora and the Lost City of Gold $ 60,477,943 $ 54,249,609 Paramount Pictures August
Downton Abbey $ 95,850,075 $ 87,994,047 Focus Features September
Dumbo $ 114,766,307 $ 233,100,000 Walt Disney March
Eiga Doraemon: Nobita no Getsumen Tansaki $ 63,191,904
ek-si-teu $ 478,949 $ 68,225,180
Escape Room $ 57,000,756 $ 98,312,322 Sony Pictures January
Extreme Crisis $ 124,169,976
Fan Tan Feng Bao 4 $ 115,687,407
Fast & Furious Presents: Hobbs & Shaw $ 173,810,100 $ 584,961,989 Universal August
Fei Chi Ren Sheng $ 255,832,826
Feng Kuang De Wai Xing Ren $ 326,150,303
Fighting With My Family $ 22,958,583 $ 15,771,649 United Artists February
Five Feet Apart $ 45,729,221 $ 45,793,152 Lionsgate March
Gemini Man $ 48,135,938 $ 118,161,142 Paramount Pictures October
Geukhanjikeob $ 1,565,885 $ 118,775,541
Gisaengchung $ 11,318,741 $ 103,499,625
Glass $ 111,035,005 $ 134,268,500 Universal January
Godzilla: King of the Monsters $ 110,500,138 $ 272,799,777 Warner Bros. May
Good Boys $ 83,083,070 $ 27,770,441 Universal August
Happy Death Day 2U $ 28,051,045 $ 36,233,515 Universal February
Hellboy $ 21,903,748 $ 18,882,732 Lionsgate April
How to Train Your Dragon: The Hidden World $ 160,799,505 $ 358,112,167 Universal February
Hustlers $ 104,690,084 $ 40,195,959 STX Entertainment September
Isn’t it Romantic $ 48,791,187 Warner Bros. February
It: Chapter Two $ 211,419,656 $ 251,082,186 Warner Bros. September
John Wick: Chapter 3 — Parabellum $ 171,015,687 $ 154,770,095 Lionsgate May
Joker $ 316,360,635 $ 672,774,761 Warner Bros. October
Kingudamu $ 50,462,102
Lie huo ying xiong $ 290,217 $ 237,714,063
Little $ 40,673,960 $ 8,061,310 Universal April
Liu Lang Di Qiu $ 692,163,684
Long Shot $ 30,316,271 $ 23,054,333 Lionsgate May
Luo Xiaohei zhan ji $ 44,553,752
MA $ 45,373,120 $ 15,150,549 Universal May
Maleficent: Mistress of Evil $ 100,012,127 $ 331,772,785 Walt Disney October
Masukarêdo hoteru $ 39,395,312
Meitantei Conan: Konjo no Fisuto $ 117,888,768
Men in Black: International $ 80,001,807 $ 172,992,753 Sony Pictures June
Midway $ 23,574,563 $ 24,049,579 Lionsgate November
Ne Zha Zhi Mo Tong Jiang Shi $ 3,695,533 $ 705,101,664
Once Upon a Time…in Hollywood $ 140,878,766 $ 227,696,130 Sony Pictures July
Pan Deng Zhe $ 487,157 $ 152,510,515
Pet Sematary $ 54,724,696 $ 54,776,450 Paramount Pictures April
Pokémon: Detective Pikachu $ 144,105,346 $ 285,579,676 Warner Bros. May
Qu'est-ce qu'on a encore fait au bon dieu? $ 74,769,800
Rambo: Last Blood $ 44,745,467 $ 42,222,444 Lionsgate September
Ready or Not $ 28,714,231 $ 28,094,037 Fox Searchlight August
Rocketman $ 96,368,160 $ 93,031,837 Paramount Pictures May
Scary Stories to Tell in the Dark $ 68,947,075 $ 26,660,285 Lionsgate August
Shao Nian De Ni $ 989,536 $ 206,367,764
Shazam! $ 140,371,656 $ 223,292,877 Warner Bros. April
Shi Tu Xing Zhe 2 Die Ying Xing Dong $ 296,751 $ 98,147,657
Song of Youth $ 50,885,008
Spider-Man: Far From Home $ 390,532,085 $ 741,251,268 Sony Pictures July
Tenki no Ko $ 175,492,409
Terminator: Dark Fate $ 51,164,755 $ 150,900,000 Paramount Pictures November
The Addams Family $ 92,647,127 $ 64,014,290 United Artists October
The Angry Birds Movie 2 $ 41,657,076 $ 107,015,429 Sony Pictures August
The Curse of La Llorona $ 54,733,739 $ 66,927,656 Warner Bros. April
The Hustle $ 35,417,038 $ 59,248,934 MGM May
The LEGO Movie 2: The Second Part $ 105,806,508 $ 84,324,528 Warner Bros. February
The Lion King $ 543,486,894 $ 1,098,700,000 Walt Disney July
The Secret Life of Pets 2 $ 158,257,265 $ 274,934,940 Universal June
The Upside $ 108,235,497 $ 10,789,039 STX Entertainment January
The White Storm 2: Drug Lords $ 184,390,774
Toy Story 4 $ 433,952,080 $ 637,000,000 Walt Disney June
Tyler Perry’s A Madea Family Funeral $ 73,257,045 $ 1,524,954 Lionsgate March
Us $ 175,006,930 $ 80,560,500 Universal March
Wan Pīsu Sutanpīdo $ 84,374,048
What Men Want $ 54,611,903 $ 15,300,000 Paramount Pictures February
Wo he wo de zu guo $ 2,323,409 $ 426,863,913
Wo Wei Xiong Di Kuang $ 60,006,412
Wonder Park $ 45,216,793 $ 69,899,191 Paramount Pictures March
Xīn xǐjù zhī wáng $ 92,796,952
Yesterday $ 73,286,650 $ 78,104,889 Universal June
Yin He Bu Xi Ban $ 122,911,412
Zhongguo jizhang $ 702,899 $ 416,481,032
Zhu Xian $ 56,911,144
Zhui Long 2: Zhui Ji Da Fu Hao $ 196,634 $ 44,388,292
Zombieland: Double Tap $ 68,098,112 $ 35,204,923 Sony Pictures October