Case Problem All-Time Movie Box-Office Data

The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds of movies each year, many of which cost hundreds of millions of dollar sto produce and distribute. Some of these movies will go on to earn hundreds of millions of dollars in box office revenues, while others will earn much less than their production cost.

Data from 50 of the top box-office-receipt-generating movies are provided in the fileTop50Movies. The following table shows the first 10 movies contained in this data set.The categorical variables included in the data set for each movie are the rating and genre. quantitative variables for the movies release year, inflation- and non-inflation-adjusted box-office receipts in the United States, budget, and the world box-office receipts are also included.

Managerial Report:

Use the data-visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following in your report:

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 overtime for these top 50 movies?

2. Create a scatter chart to examine the relationship between the non-inflation adjusted budget and the non-inflation-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 (Non-Inflation Adjusted Millions $) and then creating a scatter chart using only the movies that include data for Budget (Non-Inflation Adjusted Millions $).) What does this scatter chart indicate about the relationship between the movies budget and the world box-office receipts?

3. Create a scatter chart to examine the relationship between the inflation-adjusted budget and the inflation-adjusted world box-office receipts. What does this scatter chart indicate about the relationship between the movies inflation-adjusted budget and the inflation-adjusted world box-office receipts? Is this relationship different than what was shown for the non-inflation-adjusted amounts? If so, why?

4. 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?

5. 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 in1980 or later. What combinations of genre and rating are most represented for movies after1980? What does this indicate about how the preferences of moviegoers may have changed over time?

6. Use the PivotTable to display the average inflation-adjusted U.S. box-office receipts for each genrerating pair for all movies in the data set. Interpret the results.

Transcribed image text: Year Released 1939 1977 1965 1982 1997 1956 1975 1965 1967 U.S. Box Office Receipts (Inflation Adjusted Millions S) Rating $1,650 G $1,426 PG $1,145 G $1,132 PG $1,096 PG-13 $1,053 G $1,029 PG $973 PG-13 $871 G $854 G $844 G $825 G $809 R $804 PG-13 $772 PG $741 PG $722 G $720 PG Genre Drama SciFvFantasy Musical SciFiFantasy Drama Drama Action Drama Animated Animated World Box Office Receipts (Non- Budget (Non-Inflation Inflation Adjusted Adjusted Millions S) Millions S) $3 $391 $11 $798 $163 $757 $200 $2,185 $14 $80 $12 $471 $11 $112 $206 $1 $185 U.S. Box Office Receipts (Non-Inflation Adjusted Millions S) $199 $461 $163 $435 $659 $80 $260 $112 $142 1937 $185 Drama $15 $70 $70 $215 $153 1959 1961 1973 2009 1980 1983 1994 $12 $230 $18 $33 $45 $110 $358 $2,778 $534 $573 $952 $205 $761 $290 $309 $423 1999 $475 $6 Title Gone With the Wind Star Wars The Sound of Music E.T Titanic The Ten Jaws Doctor Zhivago The Jungle Book Snow White and the Seven Dwarf Ben-Hur One Hundred and One Dalmatians The Exorcist Avatar The Empire Strikes Return of the Jedi The Lion King Star Wars: The Phantom Menace The Sting Mary Poppins Raiders of the Lost Ark Jurassic Park The Graduate Fantasia Marvel's The Avengers The Godfather Forrest Gump Close Encounters of the Third Kind The Dark Knight Sleeping Beauty Grease Shrek 2 Butch Cassidy and the Sundance Kid Spider-Man Bambi Independence Day Love Story Beverly Hills Cop Pinocchio Home Alone Cleopatra Airport American Graffiti Ghostbusters The Robe Pirates of the Caribbean: Dead Man's Around the World in 80 Days LOTR: The Return of the King Blaring Saddles Batman Animated Horror Action SciF Fantasy SciFi Fantasy Animated SciFbFantasy Drama Musical Action Action Drama Animated SciFiFantasy Drama Drama $20 $63 1973 1964 1981 1993 1967 1940 2012 1972 1994 $2 $220 $6 $55 $1,027 $160 $102 $384 $920 $104 $76 $1,512 $135 $680 $300 $1.002 $52 $380 $912 $160 $102 $248 $357 $104 $76 $623 $135 $330 $128 $533 $52 $182 $437 $102 1977 2008 1959 1978 2004 Drama SciFiFantasy Animated Comedy Animated $715 PG $686 G $683 PG $676 PG-13 $671 PG $651 G $623 PG-13 $623 R 3618 PG-13 $612 PG $589 PG-13 $570 G $562 PG 5557 PG $353 PG $552 PG-13 $552 G $549 PG-13 $549 PG $548 R $529 G $528 PG $527 UR $518 G $515 PG $515 PG $513 UR $513 PG-13 $150 S6 $6 $75 Western $139 $75 1969 2002 1942 1996 1970 1984 1940 1990 1963 1970 1973 1984 1953 $102 $807 $268 $813 $106 $316 $84 $534 SciFiFantasy Animated SciFiFantasy Drama Comedy Animated Comedy Drama Drama Drama SciFvFantasy Drama $3 $404 $103 $306 $106 $235 $84 $286 $58 $101 $115 $239 $36 $58 $44 $10 $1 $30 $5 $101 $115 $292 $36 2006 Action $225 $1.066 $423 1956 $507 G Action S6 $42 $42 2003 $496 PG-13 $94 $377 1974 1989 $496 R $494 PG-13 SciFi/Fantasy Comedy SciFvFantasy $1,129 $120 $413 $120 $251