Title Gone With the Wind Star Wars The Sound of Music E.T. Titanic The Ten Commandments Doctor Zhivago The Jungle Book S
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Title Gone With the Wind Star Wars The Sound of Music E.T. Titanic The Ten Commandments Doctor Zhivago The Jungle Book S
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 M Around the World in 80 Days LOTR The Return of the King Blaring Saddles 1993 1967 1940 2012 1972 1994 1977 2008 1959 1978 2004 1969 2002 1942 1996 1970 1984 1940 1990 1963 1970 1973 1984 1953 2006 1956 2001 1974 1989 $676 PG-13 5671 PG $651 G $623 PG-13 $623 R $618 PG-13 $612 PG $589 PG-131 $570 G $562 PG $557 PG 5553 PG $552 PG-13 $552 G 5549 PG-13 $549 PG $548 R $529 G $528 PG $527 UR $518 G $515 PG $515 PG $513 UR $513 PG-13 $507 0 $496 PG-13 $496 R $494 PG-13 Action Drama Animated SciFi/Fantasy Drama Drama Drama SciFi/Fantasy Animated Comedy Animated Western SciFi/Fantasy Animated SciFi/Fantasy Drama Comedy Animated Comedy Drama Drama Drama SciFi/Fantasy Drama Action Action SciFi/Fantasy Comedy SciFi/Fantary $63 $2 $220 $6 $55 $150 $6 $6 $75 $139 $75 $3 $44 $10 $1 530 $5 $225 $6 504 $920 $104 $76 $1,512 $135 $680 $300 $1,002 $52 $380 $912 $102 $807 $268 5813 $106 $316 $84 $534 $58 $101 $115 $292 $36 $1,066 $42 $1,129 $120 5413 $357 $104 $76 $623 $135 $330 $128 <533 352 $182 $437 $102 $404 $103 $306 $106 $235 584 $286 $58 $101 $115 $239 $36 $423 542 $377 $120 5251
Data from fifty of the top box office receipt generating movies are provided in the file. Quantitative variables for the movie's release year, inflation- and noninflations-adjusted box office receipts in the United States, budget and the world box office receipts are also included. Perform the following analyses: 1. Create a scatter chart to examine the relationship between the year released (x variable) and the inflation-adjusted U.S. box office receipts (y variable). Include a trendline. What does that chart indicate about U.S. inflations-adjusted receipts over time for these top 50 movies? 2. Create a frequency distribution, percent frequency distribution, and histogram for World Box Office Receipts (Non- Inflation Adjusted Millions $). Use bin sizes of $100 million. Interpret the results. Does there appear to be any outliers? Summarize the results. 3. Create scatter chart to examine the relationship between the U.S. Box Office Receipts (Non-Inflation Adjusted Millions $) [x variable] and World Box Office Receipts (Non-Inflation Adjusted Millions $) [y variable]. Include a trendline. What does this scatter chart indicate about the relationship between these two variables? 4. Your director believes that U.S. Box Office Receipts can predict World Box Office Receipts. Therefore using Microsoft Excel's Data Analysis Regression tool, run a simple linear regression for these two variables. Assume U.S. Box Office Receipts (Non-Inflation Adjusted Millions $) is the x variable, and World Box Office Receipts (Non-Inflation Adjusted Millions $) is the y variable. Note that use of Microsoft Excel's Data Analysis Regression tool is required. Provide/Interpret the following as a part of your analysis: - What is the null hypothesis, HO and the alternative hypothesis, H1? - State the obtained linear equation and interpret it - Is there a linear relationship between these two variables? Justify your response. - State and interpret the obtained R-squared value. - State and interpret the obtained standard error value. - What do you tell your director? Can we use U.S. Box Office Receipts predict World Box Office Receipts? Justify your response.