Week 2 Reflection Name: (fill in name here) Chapter 3 Reflection (Excel File Attached): You are required to use Excel to complete this reflection. The movie industry is a competitive business. The...

1 answer below »
see attachment. Excel work.


Week 2 Reflection Name: (fill in name here) Chapter 3 Reflection (Excel File Attached): You are required to use Excel to complete this reflection. The movie industry is a competitive business. 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. Data on the top 100 grossing movies released in 2016 (Box Office Mojo website) are contained in the attached Excel file. We will use the numerical methods of descriptive statistics discussed in Chapter 3 to create a report of our findings. 1. Find descriptive statistics, including the mean, median, mode, range, standard deviation, and quartiles, for each of the four variables described above. Discuss what the statistics you find tell us about the movie industry. 2. According to Total Gross Sales, what movies if any, should be considered high-performance outliers? Explain how you arrived at your answer mathematically. (Use the method on p. 134 for detecting outliers.) Round any calculations/data to two decimal values. 3. Compute descriptive statistics showing the relationship between total gross sales and each of the other variables. These need to include the covariance and correlation coefficient. Discuss the relationships.
nameexcelweek2reflect-byifyhhx.xlsx 1nameweek2reflect-ehf4ifyv.docx
Answered Same DayMar 15, 2021

Answer To: Week 2 Reflection Name: (fill in name here) Chapter 3 Reflection (Excel File Attached): You are...

Mohammad Wasif answered on Mar 15 2021
140 Votes
Sheet1
    Movie Title    Opening Gross Sales ($ millions)    Total Gross Sales ($ millions)    Number of Theaters    Weeks in Release
    Rogue One: A Star Wars Story    155.08    532.18    4,157    20
    Finding Dory    135.06    486.30    4,305    25
    Captain America: Civil War    179.14    408.08    4,226    20
    The Secret Life of Pets    104.35    368.38    4,381    25
    The Jungle Book (2016)    103.26    364.00    4,144    24
    Deadpool    132.43    363.07    3,856    18
    Zootopia    75.06    341.27    3,959    22
    Batman v Superman: Dawn of Justice    166.01    330.36    4,256    12
    Suicide Squad    133.68    325.10    4,255    14
    Sing    35.26    270.40    4,029    20
    Moana    56.63    248.76    3,875    22
    Fantastic Beasts and Where To Find Them    74.40    234.04    4,144    19
    Doctor Strange    85.06    232.64    3,882    19
    Hidden Figures    0.52    169.61    3,416    46
    Jason Bourne    59.22    162.43    4,039    21
    Star Trek Beyond    59.25    158.85    3,928    13
    X-Men: Apocalypse    65.77    155.44    4,153    9
    Trolls    46.58    153.71    4,066    21
    La La Land    0.88    151.10    3,236    20
    Kung Fu Panda 3    41.28    143.53    3,987    25
    Ghostbusters (2016)    46.02    128.35    3,963    17
    Central Intelligence    35.54    127.44    3,508    11
    The Legend of Tarzan    38.53    126.64    3,591    11
    Sully    35.03    125.07    3,955    20
    Bad Moms    23.82    113.26    3,215    13
    The Angry Birds Movie    38.16    107.51    3,932    17
    Independence Day: Resurgence    41.04    103.14    4,130    12
    The Conjuring 2    40.41    102.47    3,356    11
    Arrival    24.07    100.55    3,115    17
    Passengers (2016)    14.87    100.01    3,478    17
    Sausage Party    34.26    97.69    3,135    19
    The Magnificent Seven (2016)    34.70    93.43    3,696    15
    Ride Along 2    35.24    91.22    3,192    22
    Don't Breathe    26.41    89.22    3,384    17
    Miss Peregrine's Home for Peculiar Children    28.87    87.24    3,835    19
    The Accountant    24.71    86.26    3,402    13
    Teenage Mutant Ninja Turtles: Out of the Shadows    35.32    82.05    4,071    14
    The Purge: Election Year    31.52    79.21    2,821    15
    Alice Through the Looking Glass    26.86    77.04    3,763    14
    Pete's Dragon (2016)    21.51    76.23    3,702    18
    The Girl on the Train (2016)    24.54    75.40    3,241    12
    Boo! A Madea Halloween    28.50    73.21    2,299    9
    Storks    21.31    72.68    3,922    16
    10 Cloverfield Lane    24.73    72.08    3,427    12
    Lights Out    21.69    67.27    2,835    10
    Hacksaw Ridge    15.19    67.21    2,971    18
    The Divergent Series: Allegiant    29.03    66.18    3,740    11
    Now You...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?