Question

Title	Year Released	U.S. Box Office Receipts (Inflation Adjusted Millions $)	Rating	Genre	Budget (Non-Inflation Adjusted Millions $)	World Box Office Receipts (Non-Inflation Adjusted Millions $)	U.S. Box Office Receipts (Non-Inflation Adjusted Millions $)
Gone With the Wind	1939	$1,650	G	Drama	$3	$391	$199
Star Wars	1977	$1,426	PG	SciFi/Fantasy	$11	$798	$461
The Sound of Music	1965	$1,145	G	Musical	--	$163	$163
E.T.	1982	$1,132	PG	SciFi/Fantasy	--	$757	$435
Titanic	1997	$1,096	PG-13	Drama	$200	$2,185	$659
The Ten Commandments	1956	$1,053	G	Drama	$14	$80	$80
Jaws	1975	$1,029	PG	Action	$12	$471	$260
Doctor Zhivago	1965	$973	PG-13	Drama	$11	$112	$112
The Jungle Book	1967	$871	G	Animated	--	$206	$142
Snow White and the Seven Dwarfs	1937	$854	G	Animated	$1	$185	$185
Ben-Hur	1959	$844	G	Drama	$15	$70	$70
One Hundred and One Dalmatians	1961	$825	G	Animated	--	$215	$153
The Exorcist	1973	$809	R	Horror	$12	$358	$205
Avatar	2009	$804	PG-13	Action	$230	$2,778	$761
The Empire Strikes Back	1980	$772	PG	SciFi/Fantasy	$18	$534	$290
Return of the Jedi	1983	$741	PG	SciFi/Fantasy	$33	$573	$309
The Lion King	1994	$722	G	Animated	$45	$952	$423
Star Wars: The Phantom Menace	1999	$720	PG	SciFi/Fantasy	$110	$1,027	$475
The Sting	1973	$715	PG	Drama	$6	$160	$160
Mary Poppins	1964	$686	G	Musical	--	$102	$102
Raiders of the Lost Ark	1981	$683	PG	Action	$20	$384	$248
Jurassic Park	1993	$676	PG-13	Action	$63	$920	$357
The Graduate	1967	$671	PG	Drama	--	$104	$104
Fantasia	1940	$651	G	Animated	$2	$76	$76
Marvel's The Avengers	2012	$623	PG-13	SciFi/Fantasy	$220	$1,512	$623
The Godfather	1972	$623	R	Drama	$6	$135	$135
Forrest Gump	1994	$618	PG-13	Drama	$55	$680	$330
Close Encounters of the Third Kind	1977	$612	PG	Drama	--	$300	$128
The Dark Knight	2008	$589	PG-13	SciFi/Fantasy	$150	$1,002	$533
Sleeping Beauty	1959	$570	G	Animated	$6	$52	$52
Grease	1978	$562	PG	Comedy	$6	$380	$182
Shrek 2	2004	$557	PG	Animated	$75	$912	$437
Butch Cassidy and the Sundance Kid	1969	$553	PG	Western	--	$102	$102
Spider-Man	2002	$552	PG-13	SciFi/Fantasy	$139	$807	$404
Bambi	1942	$552	G	Animated	--	$268	$103
Independence Day	1996	$549	PG-13	SciFi/Fantasy	$75	$813	$306
Love Story	1970	$549	PG	Drama	--	$106	$106
Beverly Hills Cop	1984	$548	R	Comedy	--	$316	$235
Pinocchio	1940	$529	G	Animated	$3	$84	$84
Home Alone	1990	$528	PG	Comedy	--	$534	$286
Cleopatra	1963	$527	UR	Drama	$44	$58	$58
Airport	1970	$518	G	Drama	$10	$101	$101
American Graffiti	1973	$515	PG	Drama	$1	$115	$115
Ghostbusters	1984	$515	PG	SciFi/Fantasy	$30	$292	$239
The Robe	1953	$513	UR	Drama	$5	$36	$36
Pirates of the Caribbean: Dead Man's Chest	2006	$513	PG-13	Action	$225	$1,066	$423
Around the World in 80 Days	1956	$507	G	Action	$6	$42	$42
LOTR: The Return of the King	2003	$496	PG-13	SciFi/Fantasy	$94	$1,129	$377
Blazing Saddles	1974	$496	R	Comedy	--	$120	$120
Batman	1989	$494	PG-13	SciFi/Fantasy	--	$413	$251

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, H0 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.

Answer 1

1. Presented below is the scatter chart showing the relationship between year of release and inflation adjusted box office receipts:

As is evident from the trendline, the inflation adjusted receipts have decreased over the years.

2) Frequency distribution table & Histogram for world box office receipts

Bin Sizes	Frequency	% frequency
1-100	8	16%
101-200	12	24%
201-300	5	10%
301-400	5	10%
401-500	2	4%
501-600	3	6%
601-700	1	2%
701-800	2	4%
801-900	2	4%
901-1000	3	6%
1001-1100	3	6%
1101-1200	1	2%
1501-1600	1	2%
2101-2200	1	2%
2701-2800	1	2%
Total	50	100%

It is observed in the data point that there are 3 outliers. One in the range of 1501-1600, while the other two are above 2000.

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

As it is evident there is a direct co-relation between the two.