You should use Excel to solve the questions and provide the solution to each one of them. It is important that you demonstrate that you know how to use the Excel functions. Also, make sure to analyze and interpret the results. Respond to the questions provided in the textbook (below). Be organized, for example, use different tabs to respond each question. Detailed information about the Case (Problem 2) is in your textbook. Carefully read all the information to better understand the requirements for this assignment.

Use tabular and graphical methods of Descriptive statistics to learn how these variables contribute to the success of a motion picture (Movie). Include the following in your report:

1. Tabular and graphical summaries for each of the four variables along with a discussion of what each summary tells us about the motion picture industry. 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.

AutoSave OFF RESU 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments v 12 12 - A A Times New Roman > #Insert v ab Wraa Text E AY Number 27-O 4 LE Pasic BIU A Merge & Center v DX Delete DE! Farmat Sort & Ideas S% Y Conditional Format Cell Formatting as Tetle Styles Sensitivity Find & Select v Y C14 . fx 169.71 D E F G H j K L M M N P Q 5 S U v v Malou Picle Number of Theaters Werks Helease 5 2 Hurry Policy Hall Mart 2 3 Traxgoner: Dart of the loou 4 The Twilight Saga: Breaking Dawn Part ! 7 Hunpur Puntil 6 Pirates of the Cambbean: Om Shanger des 7 Faw Five # Miiluwih - Cikuv Prill 9 Cars 2 10 Skerlock Holmes: A Game of Shadows 11 7r 12 Rise of the Planer of the per 13 Capizin America: The First Arenger 147. He 15 Bridesmaids 16 Kung Fu Panda 2 12 Purin inte 18 X-Men: First Class 19 Rio Opening Geot Sales Smillies) 149.19 97.85 135.12 8.5.05 90.15 86.20 12.79 06.14 39.64 65.72 54.81 65.06 26.114 26.25 47.66 34.11% 55.10 39.23 35.01 23.24 35.45 3.IN 4.375 4.088 4,066 3.675 4.164 3,793 3.555 4,115 3,703 3.963 19 15 14 16 19 15 13 25 13 16 19 16 311 20 18 18 13 21 3,715 3.014 2.958 3.952 5.963 3,092 3,842 211 21 Ay and the Ame: Characked 22 Super 8 Tool Gross Sales milang 31.01 352.39 131.29 254.46 241.03 209.84 203.15 191.45 186.59 181.00 176.26 176.65 169.71 169.11 165.15 149.26 146.4. 143.67 142.61 121.33 127.00 123.4 117.54 116.60 1OIX.09 104.04 103.03 102.16 L00.29 100.24 99.07 98.78 94.24 58.57 35.47 34,35 3.55 83.50 81.70 11.36 79.35 TO 25 3,934 3,424 3.923 16 18 16 15 11 11 14 12 id 14 24 Homble Bosser 25 Green Lantern 26 Hus 27 Paranom domdry. 28 Jwar Go With 27 Crin will the way Yule (2011) 30 Bad Teacher 31 Cowboys & Aliens 32 (num) und Max 33 ? Green Jorner 34 The Lion EX in 3D 35 71 MAY 38 Reai Saei 37 Crazy Shipd. Low Yule am A 39 koris The Descendans 53.17 37.54 32.52 30.51 12.72 3..60 36.43 rec 25.36 33.53 30.15 29.24 3,816 3.610 3.329 3,548 2.9511 3,049 3,754 3.037 3.584 2,340 3.4411 3.440 3,020 3.417 3.120 2,03B 3.482 2.856 2 STR 17 16 19 17 12 15 17 19.10 35.57 32.21 1.19 20.117 7.52 1601 + 16 42 War Horse Data Sheet2 Shoct3 91%, AutoSave OFF EU- 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments X LE v 12 12 Times New Roman - A A #Insert v ab Wraa Text EY Number 27-O 4 DX Delete Pasic BIU A - Ideas Merge & Center Sort & S% Y Sensitivity Conditional Format Cell Formatting as Tetle Styles DE! Farmat v Find & Select Y Fille C14 fx 169.71 A 3 D E E F G H j K L M N N D P Q R 5 T U V V TEE THEATRE 44 Tower Fleisi The Adulures of Tin 26 Contagon 47 Moneyball We How 700 2e last and all 50 Justin Bieber: Never Say rever WON 79.25 73.05 77,48 75.00 75.6. 18.91 24.03 9.72 22.40 19.50 9.36 23.00 29.51 11.36 19.15 19.65 18.45 21.24 2..B6 21.16 16.84 13.21 0.511 18.02 19.45 14.81 52 Jonkreic 59 No Smugenached Mr Pengery Penis 5 Manpy Feet Two 13 12 14 19 19 13 13 16 18 11 18 10 12 12 74.16 73.0 72,51 72.29 50.66 68.27 57 7e Adjusion. WW 58 Warspor Alsan 59 The Lincoln Lower to Minegrin Puru 61 Preud's with exciter 62 SA Number Four Sonry Code 64 New Year's Eve G Emadows Trier PerryVad My Howy wwily 67 Diary of a Wimpy Kid Rodrick Rules 68 Footloose (2011) 1971 70 Arthur Cerises 71 Fail Pas 1 Yel Yerler 73 Malewietlon 5 74 The.Antist 75 712 Ides / Munte 78 Manne 77 Something sorrowed A Work Alle Time in Waru 29 Screen 4 30 Sig Hoans: Like Father, Like Son 2.3 3,870 3.07 3.222 3,0.B 3,170 3.43N 3.1.B 2,608 3.315 3,050 3,142 3.011 3,043 2,847 2.8211 2,707 1,038 2.926 3,156 2.971 3.305 2,419 2.788 3.169 3,555 2.943 3.376 2.950 2,7411 3.135 1.756 2,199 2.345 2,904 3,305 63.69 62,50 3N. 58.01 56.81 35.0 55.LO 54.71 54.54 51.0 $3,35 32.20 51.80 48,4% 45.46 45.06 43S 42.59 41.36 49.96 401.26 we 19.05 38.54 28.18 17.97 17.66 27.52 17.1. 17.31 27.30 13.27 25.07 23.75 15.56 17.82 12.117 13.51 18 43 9 15 15 11 23 13 10 13 7 7 11 15 1060 18.013 0.20 10.47 12.37 13.95 11.14 18.09 16.30 16 14 13 12 17 2,821 3,0301 3.127 2.806 B2 H 83 Paw HJE B 7 Monde 11 14 11 14 9 15 2 12.115 13.01 11.22 19.00 PS + 1 ORS 2.334 w Data Sheet2 Sheet3 91%, AutoSave OFF RESU 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments v 12 12 Times New Roman - A A #Insert v ab Wraa Text E AY Number 27-O 4 Pasic BIU A - Merge & Center v DX Delete DE! Farmat v Sort & Ideas S% Y Conditional Format Cell Formatting as Tetle Styles Sensitivity Find & Select Y C14 fx 169.71 3 D E F G H H j K M N P 5 T U v 1.5.22 13.53 13.33 10.41 19.06 13.10 12.05 1..34 8.54 9.11 14.29 12.22 0.07 9.91 9.BS 14.05 17.30 17.08 17.05 26.07 16 30 15.1 25.116 15.06 25.01 24.52 1104 33.04 31.76 31.18 30.44 29.14 2.035 2.9.3 2,888 2.614 3,003 2.976 2.XTS 2.900 2.479 1.214 2.985 3.276 2.630 1,874 2,752 2.464 X 8 7 111 9 7 111 21 13 17 10 0 12 10 11 R6 in Bom 87 ? Chauge Up B 30 Minnies or less Chowbund 90 Sucker Punch 91 Larry CNC 92 A Very HunMit Kam? (ristus 93 Diw (201!) 94 50/50 95 CM 95 7X Rate 97 A 2017 Os tremely loud & loweity Case 98 7X Debr 100 77e Sir 101 Pried 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 1211 121 122 123 124 125 126 127 128 129 120 121 Data Sheet2 Shoct3 + - + 91%, AutoSave OFF RESU 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments v 12 12 - A A Times New Roman > #Insert v ab Wraa Text E AY Number 27-O 4 LE Pasic BIU A Merge & Center v DX Delete DE! Farmat Sort & Ideas S% Y Conditional Format Cell Formatting as Tetle Styles Sensitivity Find & Select v Y C14 . fx 169.71 D E F G H j K L M M N P Q 5 S U v v Malou Picle Number of Theaters Werks Helease 5 2 Hurry Policy Hall Mart 2 3 Traxgoner: Dart of the loou 4 The Twilight Saga: Breaking Dawn Part ! 7 Hunpur Puntil 6 Pirates of the Cambbean: Om Shanger des 7 Faw Five # Miiluwih - Cikuv Prill 9 Cars 2 10 Skerlock Holmes: A Game of Shadows 11 7r 12 Rise of the Planer of the per 13 Capizin America: The First Arenger 147. He 15 Bridesmaids 16 Kung Fu Panda 2 12 Purin inte 18 X-Men: First Class 19 Rio Opening Geot Sales Smillies) 149.19 97.85 135.12 8.5.05 90.15 86.20 12.79 06.14 39.64 65.72 54.81 65.06 26.114 26.25 47.66 34.11% 55.10 39.23 35.01 23.24 35.45 3.IN 4.375 4.088 4,066 3.675 4.164 3,793 3.555 4,115 3,703 3.963 19 15 14 16 19 15 13 25 13 16 19 16 311 20 18 18 13 21 3,715 3.014 2.958 3.952 5.963 3,092 3,842 211 21 Ay and the Ame: Characked 22 Super 8 Tool Gross Sales milang 31.01 352.39 131.29 254.46 241.03 209.84 203.15 191.45 186.59 181.00 176.26 176.65 169.71 169.11 165.15 149.26 146.4. 143.67 142.61 121.33 127.00 123.4 117.54 116.60 1OIX.09 104.04 103.03 102.16 L00.29 100.24 99.07 98.78 94.24 58.57 35.47 34,35 3.55 83.50 81.70 11.36 79.35 TO 25 3,934 3,424 3.923 16 18 16 15 11 11 14 12 id 14 24 Homble Bosser 25 Green Lantern 26 Hus 27 Paranom domdry. 28 Jwar Go With 27 Crin will the way Yule (2011) 30 Bad Teacher 31 Cowboys & Aliens 32 (num) und Max 33 ? Green Jorner 34 The Lion EX in 3D 35 71 MAY 38 Reai Saei 37 Crazy Shipd. Low Yule am A 39 koris The Descendans 53.17 37.54 32.52 30.51 12.72 3..60 36.43 rec 25.36 33.53 30.15 29.24 3,816 3.610 3.329 3,548 2.9511 3,049 3,754 3.037 3.584 2,340 3.4411 3.440 3,020 3.417 3.120 2,03B 3.482 2.856 2 STR 17 16 19 17 12 15 17 19.10 35.57 32.21 1.19 20.117 7.52 1601 + 16 42 War Horse Data Sheet2 Shoct3 91%, AutoSave OFF EU- 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments X LE v 12 12 Times New Roman - A A #Insert v ab Wraa Text EY Number 27-O 4 DX Delete Pasic BIU A - Ideas Merge & Center Sort & S% Y Sensitivity Conditional Format Cell Formatting as Tetle Styles DE! Farmat v Find & Select Y Fille C14 fx 169.71 A 3 D E E F G H j K L M N N D P Q R 5 T U V V TEE THEATRE 44 Tower Fleisi The Adulures of Tin 26 Contagon 47 Moneyball We How 700 2e last and all 50 Justin Bieber: Never Say rever WON 79.25 73.05 77,48 75.00 75.6. 18.91 24.03 9.72 22.40 19.50 9.36 23.00 29.51 11.36 19.15 19.65 18.45 21.24 2..B6 21.16 16.84 13.21 0.511 18.02 19.45 14.81 52 Jonkreic 59 No Smugenached Mr Pengery Penis 5 Manpy Feet Two 13 12 14 19 19 13 13 16 18 11 18 10 12 12 74.16 73.0 72,51 72.29 50.66 68.27 57 7e Adjusion. WW 58 Warspor Alsan 59 The Lincoln Lower to Minegrin Puru 61 Preud's with exciter 62 SA Number Four Sonry Code 64 New Year's Eve G Emadows Trier PerryVad My Howy wwily 67 Diary of a Wimpy Kid Rodrick Rules 68 Footloose (2011) 1971 70 Arthur Cerises 71 Fail Pas 1 Yel Yerler 73 Malewietlon 5 74 The.Antist 75 712 Ides / Munte 78 Manne 77 Something sorrowed A Work Alle Time in Waru 29 Screen 4 30 Sig Hoans: Like Father, Like Son 2.3 3,870 3.07 3.222 3,0.B 3,170 3.43N 3.1.B 2,608 3.315 3,050 3,142 3.011 3,043 2,847 2.8211 2,707 1,038 2.926 3,156 2.971 3.305 2,419 2.788 3.169 3,555 2.943 3.376 2.950 2,7411 3.135 1.756 2,199 2.345 2,904 3,305 63.69 62,50 3N. 58.01 56.81 35.0 55.LO 54.71 54.54 51.0 $3,35 32.20 51.80 48,4% 45.46 45.06 43S 42.59 41.36 49.96 401.26 we 19.05 38.54 28.18 17.97 17.66 27.52 17.1. 17.31 27.30 13.27 25.07 23.75 15.56 17.82 12.117 13.51 18 43 9 15 15 11 23 13 10 13 7 7 11 15 1060 18.013 0.20 10.47 12.37 13.95 11.14 18.09 16.30 16 14 13 12 17 2,821 3,0301 3.127 2.806 B2 H 83 Paw HJE B 7 Monde 11 14 11 14 9 15 2 12.115 13.01 11.22 19.00 PS + 1 ORS 2.334 w Data Sheet2 Sheet3 91%, AutoSave OFF RESU 1. 2011 Movies (2) Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Tell me Share Comments v 12 12 Times New Roman - A A #Insert v ab Wraa Text E AY Number 27-O 4 Pasic BIU A - Merge & Center v DX Delete DE! Farmat v Sort & Ideas S% Y Conditional Format Cell Formatting as Tetle Styles Sensitivity Find & Select Y C14 fx 169.71 3 D E F G H H j K M N P 5 T U v 1.5.22 13.53 13.33 10.41 19.06 13.10 12.05 1..34 8.54 9.11 14.29 12.22 0.07 9.91 9.BS 14.05 17.30 17.08 17.05 26.07 16 30 15.1 25.116 15.06 25.01 24.52 1104 33.04 31.76 31.18 30.44 29.14 2.035 2.9.3 2,888 2.614 3,003 2.976 2.XTS 2.900 2.479 1.214 2.985 3.276 2.630 1,874 2,752 2.464 X 8 7 111 9 7 111 21 13 17 10 0 12 10 11 R6 in Bom 87 ? Chauge Up B 30 Minnies or less Chowbund 90 Sucker Punch 91 Larry CNC 92 A Very HunMit Kam? (ristus 93 Diw (201!) 94 50/50 95 CM 95 7X Rate 97 A 2017 Os tremely loud & loweity Case 98 7X Debr 100 77e Sir 101 Pried 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 1211 121 122 123 124 125 126 127 128 129 120 121 Data Sheet2 Shoct3 + - + 91%