questions: 1. 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?

2. Create a PivotTable for these data. Use the PivotTable to generate a cross tabulation 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?

3. 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.

World Box Office Receipts I Box Genre Budget (Non- U.S. Box Office JOffice Receipts Inflation Adjusted Inflation Adjusted Adjusted Millions S) Millions S) Millions S) (Non-Inflation Receipts (Non- Drama 3 390,5 198.7 U.S. Box Office Budget Year Title (Inflation Receipts (Inflation Released Adjusted (Inflation Rating Adjusted Millions Millions S) S) Adjusted Millions S) Gone With the 1939 12.672 Wind 3,241.72 1,649.5 G Star Wars 1977 19.658 2.468.487 1.425.9 PG The Sound of 1965 1,144.5 Music 1,144.5 G ET . 1982 1.970,045 1,131.8 PG 1997 100.284 3,636.139 1,095.8 PG-13 The Ten 1956 184.24 1,052.8 Commandment 1,052.8 G 11 797.9 460.9 SciFi/Fantasy Musical 163,2 163.2 SciFi/Fantasy Drama 757 2.185.4 4349 658.6 Titanic 200 Drama 14 80 80 1975 26.224 1,864.617 1,029.3 PG Action 12 471 260 1965 95.839 973.2 973.2 PG-13 Drama 11 111.7 111.7 Jaws Doctor Zhivago The Jungle Book 1967 1.263.391 870.5 G Animated 205.8 141.8 Snow White and the Seven Dwarfs 1937 4.621 854.4 854.4G 854.4 G Animated 1 184,9 184.9 Ben-Hur 1959 180.9 844.2 844,2 G Drama 15 70 70 One Hundred and One Dalmatians 1961 1.162.071 824.8 G Animated 215 152.6 The Exorcist 1973 2009 27.145 66.569 1,412 361 2.937.476 808.7 R 804.1 PG-13 Horror Action 12 230 357,5 2,778.2 204.7 760.5 1980 26.017 1.419.747 771.7 PG SciFi/Fantasy 18 533.9 290.2 The Empire Strikes Back Return of the Jedi 1983 42.647 1,372.716 740.5 PG SciFi/Fantasy 33 573 309.1 The Lion King 1994 34.147 1.625.622 722.1 G Animated 45 951.6 422.7 Star Wars: The Phantom Menace 1999 77.075 1.557.49 719,6 PG SciFi/Fantasy 110 1,027 474.5 1973 26,88 715 715 PG Drama 6 159.6 159.6 The Sting Mary Poppins 1964 686 686 G Musical 102.3 102.3 1981 35.594 1,057.741 683.4 PG Action 20 384 248.1 Raiders of the Lost Ark Jurassic Park 1993 46.271 1.740.812 675.7 PG-13 Action 63 920 357.1 The Graduate 1967 670,7 670.7 PG Drama 104,4 104.4 Fantasia 1940 17.042 651 651 G Animated 2 76.4 76,4 Marvel's The Avengers 2012 90.718 1,511.8 623.4 PG-13 SciFi/Fantasy 220 1,511.8 623.4 The Godfather 1972 27.721 623.725 622.8 R Drama 6 134,8 134,6 Forrest Gump 1994 50,01 1,275.232 618.3 PG-13 Drama SS 680 329.7 Close Encounters of the Third Kind 1977 1,430.553 611.8 PG Drama 300 128.3 2008 88.182 1.106.542 589 PG-13 SciFi/Fantasy ISO 1.001.9 533.3 The Dark Knight Sleeping Beauty Grease Shrek 2 1959 66.244 569.7 Animated 6 51.6 51.6 8.877 1978 2004 1.175.811 1,164.602 569.7 G 561.9 PG 557.4 PG Comedy Animated 6 75 379.8 912 181.5 436.5 45.839 Butch Cassidy and the Sundance Kid 1969 553 553 PG Western 102.3 102.3 1942 2002 1,439.066 1.103.043 552 G 552 PG-13 268 806.7 102.8 403.7 95.113 139 Animated SciFi/Fantasy SciFi/Fantasy Drama 1996 50.649 1.458.586 549.1 PG-13 75 813.1 306.1 1970 548.7 548.7 PG 106.4 106.4 1984 738.042 Comedy 316.4 234.8 Bambi Spider-Man Independence Day Love Story Beverly Hills Cop Pinocchio Home Alone Cleopatra Airport American Graffiti Ghostbusters 18.808 3 1940 1990 1963 1970 528.5 986.353 526.7 518,2 547.7 R 528.5 G 528.1 PG 526.7 UR 518.2 G 515.2 PG 84.3 533.8 57.8 100.5 Animated Comedy Drama Drama Drama 84,3 285,8 57.8 100.5 44 400,948 51.562 10 1973 4.48 515.2 1 115 115 1984 53.004 629.641 515.2 PG SciFi/Fantasy 30 291.6 238.6 36 The Robe 1953 71.25 513 513 UR Drama 5 36 Pirates of the Caribbean: Dead Man's Chest 2006 108.204 1,290.27 512.5 PG-13 Action 225 1,065.7 423.3 1956 72.371 506.6 506.6 G Action 6 42 42 Around the World in 80 Days LOTR: The Return of the King Blazing Saddles Batman 2003 41.273 1.485.033 495.8 PG-13 SciFi/Fantasy 94 1.129.2 377 1974 Comedy 119.5 495.6 811.367 495.6 R 493.5 PG-13 119.5 251.2 1989 SciFi/Fantasy 413 World Box Office Receipts I Box Genre Budget (Non- U.S. Box Office JOffice Receipts Inflation Adjusted Inflation Adjusted Adjusted Millions S) Millions S) Millions S) (Non-Inflation Receipts (Non- Drama 3 390,5 198.7 U.S. Box Office Budget Year Title (Inflation Receipts (Inflation Released Adjusted (Inflation Rating Adjusted Millions Millions S) S) Adjusted Millions S) Gone With the 1939 12.672 Wind 3,241.72 1,649.5 G Star Wars 1977 19.658 2.468.487 1.425.9 PG The Sound of 1965 1,144.5 Music 1,144.5 G ET . 1982 1.970,045 1,131.8 PG 1997 100.284 3,636.139 1,095.8 PG-13 The Ten 1956 184.24 1,052.8 Commandment 1,052.8 G 11 797.9 460.9 SciFi/Fantasy Musical 163,2 163.2 SciFi/Fantasy Drama 757 2.185.4 4349 658.6 Titanic 200 Drama 14 80 80 1975 26.224 1,864.617 1,029.3 PG Action 12 471 260 1965 95.839 973.2 973.2 PG-13 Drama 11 111.7 111.7 Jaws Doctor Zhivago The Jungle Book 1967 1.263.391 870.5 G Animated 205.8 141.8 Snow White and the Seven Dwarfs 1937 4.621 854.4 854.4G 854.4 G Animated 1 184,9 184.9 Ben-Hur 1959 180.9 844.2 844,2 G Drama 15 70 70 One Hundred and One Dalmatians 1961 1.162.071 824.8 G Animated 215 152.6 The Exorcist 1973 2009 27.145 66.569 1,412 361 2.937.476 808.7 R 804.1 PG-13 Horror Action 12 230 357,5 2,778.2 204.7 760.5 1980 26.017 1.419.747 771.7 PG SciFi/Fantasy 18 533.9 290.2 The Empire Strikes Back Return of the Jedi 1983 42.647 1,372.716 740.5 PG SciFi/Fantasy 33 573 309.1 The Lion King 1994 34.147 1.625.622 722.1 G Animated 45 951.6 422.7 Star Wars: The Phantom Menace 1999 77.075 1.557.49 719,6 PG SciFi/Fantasy 110 1,027 474.5 1973 26,88 715 715 PG Drama 6 159.6 159.6 The Sting Mary Poppins 1964 686 686 G Musical 102.3 102.3 1981 35.594 1,057.741 683.4 PG Action 20 384 248.1 Raiders of the Lost Ark Jurassic Park 1993 46.271 1.740.812 675.7 PG-13 Action 63 920 357.1 The Graduate 1967 670,7 670.7 PG Drama 104,4 104.4 Fantasia 1940 17.042 651 651 G Animated 2 76.4 76,4 Marvel's The Avengers 2012 90.718 1,511.8 623.4 PG-13 SciFi/Fantasy 220 1,511.8 623.4 The Godfather 1972 27.721 623.725 622.8 R Drama 6 134,8 134,6 Forrest Gump 1994 50,01 1,275.232 618.3 PG-13 Drama SS 680 329.7 Close Encounters of the Third Kind 1977 1,430.553 611.8 PG Drama 300 128.3 2008 88.182 1.106.542 589 PG-13 SciFi/Fantasy ISO 1.001.9 533.3 The Dark Knight Sleeping Beauty Grease Shrek 2 1959 66.244 569.7 Animated 6 51.6 51.6 8.877 1978 2004 1.175.811 1,164.602 569.7 G 561.9 PG 557.4 PG Comedy Animated 6 75 379.8 912 181.5 436.5 45.839 Butch Cassidy and the Sundance Kid 1969 553 553 PG Western 102.3 102.3 1942 2002 1,439.066 1.103.043 552 G 552 PG-13 268 806.7 102.8 403.7 95.113 139 Animated SciFi/Fantasy SciFi/Fantasy Drama 1996 50.649 1.458.586 549.1 PG-13 75 813.1 306.1 1970 548.7 548.7 PG 106.4 106.4 1984 738.042 Comedy 316.4 234.8 Bambi Spider-Man Independence Day Love Story Beverly Hills Cop Pinocchio Home Alone Cleopatra Airport American Graffiti Ghostbusters 18.808 3 1940 1990 1963 1970 528.5 986.353 526.7 518,2 547.7 R 528.5 G 528.1 PG 526.7 UR 518.2 G 515.2 PG 84.3 533.8 57.8 100.5 Animated Comedy Drama Drama Drama 84,3 285,8 57.8 100.5 44 400,948 51.562 10 1973 4.48 515.2 1 115 115 1984 53.004 629.641 515.2 PG SciFi/Fantasy 30 291.6 238.6 36 The Robe 1953 71.25 513 513 UR Drama 5 36 Pirates of the Caribbean: Dead Man's Chest 2006 108.204 1,290.27 512.5 PG-13 Action 225 1,065.7 423.3 1956 72.371 506.6 506.6 G Action 6 42 42 Around the World in 80 Days LOTR: The Return of the King Blazing Saddles Batman 2003 41.273 1.485.033 495.8 PG-13 SciFi/Fantasy 94 1.129.2 377 1974 Comedy 119.5 495.6 811.367 495.6 R 493.5 PG-13 119.5 251.2 1989 SciFi/Fantasy 413