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 dollars to 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 fifty of the top box office receipt generating movies are provided in the file \"Ch3 Top50Movies\". The categorical variables included in the data set for each movie are the rating and genre. Quantitative variables for the movie's release year, inflation- and noninflation-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 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. Grading Rubric for Case Study Assignments Criteria Good 20 Fair 15 Unacceptable 0 Score Substance 25% of grade Answers are meaningful and reflect insight and careful analysis of the issues posed; contains rich and fully developed ideas which are extremely well written and presented. Answers are meaningful and reflect insight and analysis of the issues posed; contains fully developed ideas which are well written and presented. Answers are vague and reflect sloppy analysis of the issues posed; needs further development. Answers lack any worthwhile analysis. Results & Predictions 25% of grade Mathematical results are correct and clearly stated and explained. Intelligent predictions are made with full support of the correct data results. Proper graphs used, which are accurate for given scenario. Neat and easy to read. Includes all applicable labels and characteristics of a good graph. Correct mathematical results are stated and partially explained. Predictions are made with some support of the correct data results. Some incorrect mathematical results. Predictions made with incorrect mathematical results of the data. No mathematical results are discussed. No intelligent predictions are made based on the data results. Proper graphs used, which are accurate for given scenario. Neat and easy to read. Some omitted applicable labels and characteristic of a good graph. Improper graph used for given scenario; omitted labels and characteristic of a good graph. No appropriate graphs used. Writing 25% of grade The usage of grammar, sentence structure, and spelling, are excellent. Citations (if any) are properly cited using proper APA formatting. The usage of grammar, sentence structure and spelling contain minimal errors. Citations (if any) are properly cited using proper APA formatting. Prose and grammar need significant revisions. Grammar, sentence structure, spelling and citations (if any) are unacceptable. Total The usage of grammar, sentence structure, and spelling are improper and needs some revision. Improper citation (if any) formatting. Graphs 25% of grade Excellent 25 Title Gone With the Wind Star Wars The Sound of Music E.T. Titanic The Ten Commandments Jaws Doctor Zhivago The Jungle Book Snow White and the Seven Dwarfs Ben-Hur One Hundred and One Dalmatians The Exorcist Avatar The Empire Strikes Back Return of the Jedi The Lion King Year Released 1939 1977 1965 1982 1997 U.S. Box Office Receipts (Inflation Adjusted Millions $) Rating $1,650 G $1,426 PG $1,145 G $1,132 PG $1,096 PG-13 Genre Drama SciFi/Fantasy Musical SciFi/Fantasy Drama Budget (Non-Inflation Adjusted Millions $) $3 $11 --$200 World Box Office Receipts (NonInflation Adjusted Millions $) $391 $798 $163 $757 $2,185 U.S. Box Office Receipts (Non-Inflation Adjusted Millions $) $199 $461 $163 $435 $659 1956 $1,053 G Drama $14 $80 $80 1975 1965 1967 $1,029 PG $973 PG-13 $871 G Action Drama Animated $12 $11 -- $471 $112 $206 $260 $112 $142 $1 $185 $185 $15 $70 $70 -- $215 $153 $12 $230 $358 $2,778 $205 $761 1937 $854 G Animated 1959 $844 G Drama 1961 $825 G Animated 1973 2009 $809 R $804 PG-13 Horror Action 1980 $772 PG SciFi/Fantasy $18 $534 $290 1983 1994 $741 PG $722 G SciFi/Fantasy Animated $33 $45 $573 $952 $309 $423 Star Wars: The Phantom Menace 1999 $720 PG SciFi/Fantasy $110 $1,027 $475 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 1973 1964 1981 1993 1967 1940 2012 1972 1994 $715 $686 $683 $676 $671 $651 $623 $623 $618 Drama Musical Action Action Drama Animated SciFi/Fantasy Drama Drama $6 -$20 $63 -$2 $220 $6 $55 $160 $102 $384 $920 $104 $76 $1,512 $135 $680 $160 $102 $248 $357 $104 $76 $623 $135 $330 1977 $612 PG Drama -- $300 $128 2008 1959 1978 2004 $589 $570 $562 $557 SciFi/Fantasy Animated Comedy Animated $150 $6 $6 $75 $1,002 $52 $380 $912 $533 $52 $182 $437 1969 $553 PG Western -- $102 $102 2002 1942 1996 1970 1984 1940 1990 1963 1970 1973 1984 1953 $552 $552 $549 $549 $548 $529 $528 $527 $518 $515 $515 $513 SciFi/Fantasy Animated SciFi/Fantasy Drama Comedy Animated Comedy Drama Drama Drama SciFi/Fantasy Drama $139 -$75 --$3 -$44 $10 $1 $30 $5 $807 $268 $813 $106 $316 $84 $534 $58 $101 $115 $292 $36 $404 $103 $306 $106 $235 $84 $286 $58 $101 $115 $239 $36 PG G PG PG-13 PG G PG-13 R PG-13 PG-13 G PG PG PG-13 G PG-13 PG R G PG UR G PG PG UR Pirates of the Caribbean: Dead Man's Chest 2006 $513 PG-13 Action $225 $1,066 $423 Around the World in 80 Days $507 G Action $6 $42 $42 LOTR: The Return of the King 2003 $496 PG-13 SciFi/Fantasy $94 $1,129 $377 Blazing Saddles Batman $496 R $494 PG-13 Comedy SciFi/Fantasy --- $120 $413 $120 $251 1956 1974 1989