1. Create a scatter chart to examine the relationship between the year released and the inflation-adjusted U.S. box office receipts. Include a trendline for this scatter chart. What does the scatter chart indicate about inflation-adjusted U.S. box office receipts over time for these top 50 movies?

2. Create a scatter chart to examine the relationship between the budget and the noninflation-adjusted world box office receipts. (Note: You may have to adjust the data in Excel to ignore the missing budget data values to create your scatter chart. You can do this by first sorting the data using Budget and then creating a scatter chart using only the movies that include data for Budget.) What does this scatter chart indicate about the relationship between the movie’s budget and the world box office receipts?

3. Create a frequency distribution, percent frequency distribution, and histogram for inflation-adjusted U.S. box office receipts. Use bin sizes of $100 million. Interpret the results. Do any data points appear to be outliers in this distribution?

4. Create a PivotTable for these data. Use the PivotTable to generate a crosstabulation for movie genre and rating. Determine which combinations of genre and rating are most represented in the top 50 movie data. Now filter the data to consider only movies released in 1980 or later. What combinations of genre and rating are most represented for movies after 1980? What does this indicate about how the preferences of moviegoers may have changed over time?

5. Use the PivotTable to display the average inflation-adjusted U.S. box office receipts for each genre–rating pair for all movies in the dataset. Interpret the results.

 

Transcribed Image Text:

Werld Bex Offce US. Bax OfFre US. Ber Office Receipts Receipts (Nen- ILitation Adjusted Inflation Adjusted MEns 5) Budget (Ne Receipts (Inflation Released Adjusted MEons 5) Rating Year (Nan-Inlation AGested Mons $) Tile Geare MEons $) $1,650 G $1,426 PG $1,145 G $1,132 PG $1,096 PG-13 Gone With the Wind 1939 Drama $3 $391 $199 Star Wars 1977 SciFFantasy $11 $798 $461 The Sqund ofMusic 1965 Musical $163 $163 ET. 1982 SciFFantasy $757 $435 Tianic 1997 Drama $200 $2,185 $659 The Ten 1956 $1,053 G Drama $14 $80 $80 Commandments Jaws 1975 $1,029 PG Action $12 $471 $260 Doctor Zhivago 1965 $973 PG-13 Drama $11 $112 $112 The Jungle Book 1967 $871 G Animated $206 $142 Spow White and the 1937 $854 G Animated $1 $185 $185 Seven Dwarfs Ben-Hur 1959 $844 G Drama $15 $70 $70 One Hundred and 1961 $825 G Animated $215 $153 One Dalmatians The Exorrist 1973 $809 R Horror $12 $358 $205 Avatar 2009 $804 PG-13 Action $230 $2,778 $761 The Empire Stikes 1980 $772 PG SciFFantasy $18 $534 290 Back Retum of the Jedi 1983 $741 PG SciFFantasy $33 $573 $309 The Lion King 1994 $722 G Animated $45 $952 $423 Star Wars. The 1999 $720 PG ScifiFantasy $110 $1,027 $475 Phartom Menace The Sting 1973 $715 PG Drama $6 $160 $160 Mary Poppins Raiders of the Lost 1964 $686 G Mnsical $102 $102 1981 $683 PG Action $20 $384 $248 Ark Jurassic Park 1993 $676 PG-13 Action $63 $920 $357 The Gradnate 1967 $671 PG Drama $104 $104 Fantasia 1940 $651 G Animated $2 $76 $76 Marvels The 2012 $623 PG-13 ScifFantasy $220 $1,512 $623 Avengers The Godfather $6 $55 1972 $623 R Drama $135 $135 Forest Gump 1994 $618 PG-13 Drama $680 $330 Close EncountErs of 1977 $612 PG Drama $300 $128 the Third Kind The Dark Knight Sleeping Beanty 2008 $589 PG-13 SciFFantasy $150 $1,002 $533 1959 $570 G Animated $6 $52 $52 Grease 1978 $562 PG Comedy $6 $380 $182 Shrek 2 2004 $557 PG Animated $75 $912 $437 Butch Cassidy and the Sundance Kid 1969 $553 PG Western $102 $102 Spider-Man 2002 $552 PG-13 SciFFantasy $139 $807 $404 Bambi 1942 $552 G Animated $268 $103 SciFFantasy Independence Day Love Story 1996 $549 PG-13 $75 $813 $306 1970 $549 PG Drama $106 $106 Beverly Hils Cop 1984 $548 R Сomedy $316 $235 Pinocchio 1940 $529 G Aninated $3 $84 $84 Home Alone 1990 $528 PG Comedy $534 $286 $527 UR $44 $58 $58 Cleopatra Aiport American Grafffiri 1963 Drama 1970 $518 G Drama $10 $101 $101 1973 $515 PG Drama $1 $115 $115 Ghostbusters 1984 $515 PG SciFTFantasy $30 $292 $239 The Robe 1953 $513 UR Drama $5 $36 $36 Pirates of the Carbbean Dead 2006 $513 PG-13 Action $225 $1,066 $423 Man's Chest Around the World in 1956 $507 G Action $6 $42 $42 80 Days LOTR: The Retum of 2003 $496 PG-13 SciFTFantasy $94 $1,129 $377 the King Blaing Saddles $496 R Comedy SciFFantasy 1974 $120 $120 Batman 1989 $494 PG-13 11 $413 $251 Werld Bex Offce US. Bax OfFre US. Ber Office Receipts Receipts (Nen- ILitation Adjusted Inflation Adjusted MEns 5) Budget (Ne Receipts (Inflation Released Adjusted MEons 5) Rating Year (Nan-Inlation AGested Mons $) Tile Geare MEons $) $1,650 G $1,426 PG $1,145 G $1,132 PG $1,096 PG-13 Gone With the Wind 1939 Drama $3 $391 $199 Star Wars 1977 SciFFantasy $11 $798 $461 The Sqund ofMusic 1965 Musical $163 $163 ET. 1982 SciFFantasy $757 $435 Tianic 1997 Drama $200 $2,185 $659 The Ten 1956 $1,053 G Drama $14 $80 $80 Commandments Jaws 1975 $1,029 PG Action $12 $471 $260 Doctor Zhivago 1965 $973 PG-13 Drama $11 $112 $112 The Jungle Book 1967 $871 G Animated $206 $142 Spow White and the 1937 $854 G Animated $1 $185 $185 Seven Dwarfs Ben-Hur 1959 $844 G Drama $15 $70 $70 One Hundred and 1961 $825 G Animated $215 $153 One Dalmatians The Exorrist 1973 $809 R Horror $12 $358 $205 Avatar 2009 $804 PG-13 Action $230 $2,778 $761 The Empire Stikes 1980 $772 PG SciFFantasy $18 $534 290 Back Retum of the Jedi 1983 $741 PG SciFFantasy $33 $573 $309 The Lion King 1994 $722 G Animated $45 $952 $423 Star Wars. The 1999 $720 PG ScifiFantasy $110 $1,027 $475 Phartom Menace The Sting 1973 $715 PG Drama $6 $160 $160 Mary Poppins Raiders of the Lost 1964 $686 G Mnsical $102 $102 1981 $683 PG Action $20 $384 $248 Ark Jurassic Park 1993 $676 PG-13 Action $63 $920 $357 The Gradnate 1967 $671 PG Drama $104 $104 Fantasia 1940 $651 G Animated $2 $76 $76 Marvels The 2012 $623 PG-13 ScifFantasy $220 $1,512 $623 Avengers The Godfather $6 $55 1972 $623 R Drama $135 $135 Forest Gump 1994 $618 PG-13 Drama $680 $330 Close EncountErs of 1977 $612 PG Drama $300 $128 the Third Kind The Dark Knight Sleeping Beanty 2008 $589 PG-13 SciFFantasy $150 $1,002 $533 1959 $570 G Animated $6 $52 $52 Grease 1978 $562 PG Comedy $6 $380 $182 Shrek 2 2004 $557 PG Animated $75 $912 $437 Butch Cassidy and the Sundance Kid 1969 $553 PG Western $102 $102 Spider-Man 2002 $552 PG-13 SciFFantasy $139 $807 $404 Bambi 1942 $552 G Animated $268 $103 SciFFantasy Independence Day Love Story 1996 $549 PG-13 $75 $813 $306 1970 $549 PG Drama $106 $106 Beverly Hils Cop 1984 $548 R Сomedy $316 $235 Pinocchio 1940 $529 G Aninated $3 $84 $84 Home Alone 1990 $528 PG Comedy $534 $286 $527 UR $44 $58 $58 Cleopatra Aiport American Grafffiri 1963 Drama 1970 $518 G Drama $10 $101 $101 1973 $515 PG Drama $1 $115 $115 Ghostbusters 1984 $515 PG SciFTFantasy $30 $292 $239 The Robe 1953 $513 UR Drama $5 $36 $36 Pirates of the Carbbean Dead 2006 $513 PG-13 Action $225 $1,066 $423 Man's Chest Around the World in 1956 $507 G Action $6 $42 $42 80 Days LOTR: The Retum of 2003 $496 PG-13 SciFTFantasy $94 $1,129 $377 the King Blaing Saddles $496 R Comedy SciFFantasy 1974 $120 $120 Batman 1989 $494 PG-13 11 $413 $251

Answer rating: 100% (QA)

a The scatter plot indicated upside down trend line which predicted that by time US inflation box office receipts for top fifty movies decreases b The ... View the full answer