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 cam 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 file Top5OMovies. 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 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 Receipts World U.S. Box- Office Receipts (inflation- adjusted Released millions $) Rating Genre Box-Office Receipts (noninflation- (noninflation- (noninflation- adjusted millions S) Budget adjusted millions $) adjusted millions S) Year Title 1,650 Drama 3 391 199 Gone with the Wind 1939 Star Wars 1977 1,426 PG Scifi/fantasy 11 798 461 The Sound of 1965 1,145 Musical 163 163 Music E.T. 1,132 PG Scifi/fantasy 757 435 1982 1997 1,096 PG-13 Drama 200 2,185 659 Titanic 1956 1,053 G Drama 14 80 B0 The Ten Commandments 1975 1,029 PG Action 12 471 260 Jaws 973 PG-13 Drama 11 112 112 Doctor Zhivago 1965 871 G Animated 206 142 The Jungle Book 1967 Animated 185 185 Snow White and 1937 854 the Seven Dwarfs 1939 1,650 Drama 3. 391 1977 1,426 PG 11 798 461 Scifi/fantasy 163 163 1965 1,145 Musical 757 435 1982 1,132 PG Scifi/fantasy 1997 1,096 PG-13 Drama 200 2,185 659 1956 1,053 G Drama 14 80 80 12 471 260 1975 1,029 PG Action 1965 973 PG-13 Drama 11 112 112 206 142 1967 871 G Animated 185 185 1937 854 Animated 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.