Please help, please show steps in excel. Thank you

The movie industry is a competitive business. More than 50 studios produce hundreds of new movies for theater release each year, and the financial success of each movie varies considerably. The opening weekend gross sales ($ millions), the total gross sales ($ millions), the number of theaters the movie was shown in, and the number of weeks the movie was in release are common variables used to measure the success of a movie released to theaters. Data collected for the top 100 theater movies released in 2016 are contained in the file Movies 2016 (Box Office Mojo website). Use the tabular and graphical methods to learn how these variables contribute to the success of a motion picture. Include the following in your report. 1. A frequency distribution and a histogram 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) The opening gross sales, discuss. b) The total gross sales, discuss. c) The number of theaters, discuss. d) The number of weeks in release, discuss. 2. A scatter diagram to explore the relationship between Total Gross Sales and Opening Weekend Gross Sales. Discuss. 3. A scatter diagram to explore the relationship between Total Gross Sales and Number of Theaters. Discuss. 4. A scatter diagram to explore the relationship between Total Gross Sales and Number of Weeks in Release. Discuss. Write a report. Charts and tables should be included in your report. Submit HW 1 in PDF file format or Word file format, plus associated Excel file. Before you write each of the discussions, ask yourself, "If I was going to tell my boss a key take-away about the movie business from this chart, what would that be? 1 Movie Title 2 Rogue One: A Star Wars Story 3 Finding Dory 4 Captain America: Civil War 5 The Secret Life of Pets 6 The Jungle Book (2016) 7 Deadpool 8 Zootopia 9 Batman v Superman: Dawn of Justice 10 Suicide Squad 11 Sing 12 Moana 13 Fantastic Beasts and Where To Find Them 14 Doctor Strange 15 Hidden Figures 16 Jason Bourne 17 Star Trek Beyond 18 X-Men: Apocalypse 19 Trolls 20 La La Land 21 Kung Fu Panda 3 22 Ghostbusters (2016) 23 Central Intelligence 24 The Legend of Tarzan 25 Sully 26 Bad Moms 27 The Angry Birds Movie 28 Independence Day: Resurgence 29 The Conjuring 2 30 Arrival B Opening Gross Sales Total Gross Sales (S millions) (S millions) 155.08 532.18 135.06 486.3 179.14 408.08 104.35 368.38 103.26 364 132.43 363.07 75.06 341.27 166.01 330.36 133.68 325.1 35.26 270.4 56.63 248.76 74.4 234.04 85.06 232.64 0.52 169.61 59.22 162.43 59.25 158.85 65.77 155.44 46.58 153.71 0.88 151.1 41.28 143.53 46.02 128.35 35.54 127.44 38.53 126.64 35.03 125.07 23.82 113.26 38.16 107.51 41.04 103.14 40.41 102.47 24.07 100.55 Number of Theaters 4,157 4,305 4,226 4,381 4,144 3,856 3,959 4,256 4,255 4,029 3,875 4,144 3,882 3,416 4,039 3,928 4,153 4,066 3,236 3,987 3,963 3,508 3,591 3,955 3,215 3,932 4,130 3,356 3,115 E 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 31 Passengers (2016) 32 Sausage Party 33 The Magnificent Seven (2016) 34 Ride Along 2 35 Don't Breathe 36 Miss Peregrine's Home for Peculiar Children 37 The Accountant 38 Teenage Mutant Ninja Turtles: Out of the Shadows 39 The Purge: Election Year 40 Alice Through the Looking Glass 41 Pete's Dragon (2016) 42 The Girl on the Train (2016) 43 Boo! A Madea Halloween 44 Storks 45 10 Cloverfield Lane 46 Lights Out 47 Hacksaw Ridge 48 The Divergent Series: Allegiant 49 Now You See Me 2 50 Ice Age: Collision Course 51 The Boss 52 London Has Fallen 53 Miracles from Heaven 54 Deepwater Horizon 55 Why Him? 14.87 34.26 34.7 35.24 26.41 28.87 24.71 35.32 31.52 26.86 21.51 24.54 28.5 21.31 24.73 21.69 15.19 29.03 22.38 21.37 23.59 21.64 14.81 20.22 100.01 97.69 93.43 91.22 89.22 87.24 86.26 82.05 79.21 77.04 76.23 75.4 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 3,478 3,135 3,696 3,192 3,384 3,835 3,402 4,071 2,821 3,763 3,702 3,241 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 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 11 9 12 15 11 15 8 14 7 56 My Big Fat Greek Wedding 2 57 Jack Reacher: Never Go Back 58 Fences 59 Me Before You 60 The BFG 61 Neighbors 2: Sorority Rising 62 The Shallows 63 Office Christmas Party 64 Assassin's Creed 65 Barbershop: The Next Cut 66 13 Hours: The Secret Soldiers of Benghazi 67 Lion 68 The Huntsman: Winter's War 69 Kubo and the Two Strings 70 Manchester by the Sea 71 Warcraft 72 How to Be Single 73 Mike and Dave Need Wedding Dates 74 War Dogs 75 Almost Christmas 76 Money Monster 77 Allied 78 Nerve 79 Risen 80 The Nice Guys 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 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 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 11 13 10 24 15 15 23 13 9 14 9 9 12 9 10 13 11 81 The Boy (2016) 82 Dirty Grandpa 83 Ouija: Origin of Evil 84 The 5th Wave 85 Inferno 86 Mother's Day 87 Patriots Day 88 Gods of Egypt 89 Collateral Beauty 90 Hail, Caesar! 91 when the Bough Breaks 92 Zoolander 2 93 Moonlight (2016) 94 The Finest Hours 95 Florence Foster Jenkins 96 Hell or High Water 97 The Forest 98 Ben-Hur (2016) 99 The Witch 100 Bridget Jones's Baby 101 Kevin Hart: What Now? 10.78 11.11 14.07 10.33 14.86 8.37 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 35.82 35.59 35.14 34.92 34.34 32.49 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 2,671 2,912 3,168 2,908 3,576 3,291 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 10 8 10 18 12 7 11 11 8 21 10 7 28 10 11 14 10 7 14 13 9