Case Problem All-Time Movie Box-Office Data CASE PROBLEM ALL-TIME MOVIE BOX- OFFICE DATA The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds 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 of movies each year, many of which cost hundreds of millions of dollars Data from 50 of the top box-office-receipt-generating movies are provided in the file Top50Movies. The following table shows the first 10 movies contained in this data set. DATA file The categorical variables included in the data set for each movie are the rating and genre. Top S0Movies 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 U.S. Box- Office World U.S. Box- Office Receipts inflation- Budget ReceiptsReceipts (noninflation- (noninflation- (noninflation- adjusted adjusted adjusted Year adjusted Released millions S) Rating Genremillions S) Title millions S) millions S) Gone with the 19391,650 G Drama 391 199 Star Wars 1977 1,426 PG Scifi/fantasy 11 1965 1,145 G Musical 461 163 798 The Sound of 163 ET 1962 1,132 PG Scif/tantasy 1997 1,096 PG-13 Drama 1956 1,053 G Drama 757 2.185 80 435 659 80 200 The Ten 14 1975 1,029 PG Action 12 Doctor Zhivago 1965 973 PG-13 Drama The Angle Book 1967 Soe White and1937 854 471 112 206 185 260 112 142 185 871 G Animated Seven bats 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 1. Create a scatter c hart to examine the relationship between the year released and the your report: inflation-adjusted U.S. box oftice receipts. Include a trendline for this seatter 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. Case Problem All-Time Movie Box-Office Data CASE PROBLEM ALL-TIME MOVIE BOX- OFFICE DATA The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds 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 of movies each year, many of which cost hundreds of millions of dollars Data from 50 of the top box-office-receipt-generating movies are provided in the file Top50Movies. The following table shows the first 10 movies contained in this data set. DATA file The categorical variables included in the data set for each movie are the rating and genre. Top S0Movies 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 U.S. Box- Office World U.S. Box- Office Receipts inflation- Budget ReceiptsReceipts (noninflation- (noninflation- (noninflation- adjusted adjusted adjusted Year adjusted Released millions S) Rating Genremillions S) Title millions S) millions S) Gone with the 19391,650 G Drama 391 199 Star Wars 1977 1,426 PG Scifi/fantasy 11 1965 1,145 G Musical 461 163 798 The Sound of 163 ET 1962 1,132 PG Scif/tantasy 1997 1,096 PG-13 Drama 1956 1,053 G Drama 757 2.185 80 435 659 80 200 The Ten 14 1975 1,029 PG Action 12 Doctor Zhivago 1965 973 PG-13 Drama The Angle Book 1967 Soe White and1937 854 471 112 206 185 260 112 142 185 871 G Animated Seven bats 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 1. Create a scatter c hart to examine the relationship between the year released and the your report: inflation-adjusted U.S. box oftice receipts. Include a trendline for this seatter 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