EXCEL

a1-top50movies.xlsx

Home >Business & Finance homework help >Management homework help >EXCEL

Data

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

Sheet1

Year Released	U.S. Box Office Receipts (Inflation Adjusted Millions $)
1939	$1,650
1977	$1,426
1965	$1,145
1982	$1,132
1997	$1,096
1956	$1,053
1975	$1,029
1965	$973
1967	$871
1937	$854
1959	$844
1961	$825
1973	$809
2009	$804
1980	$772
1983	$741
1994	$722
1999	$720
1973	$715	The scatter chart indicates that box office receipts for the top 50 movies have been relatively flat to slighty declining over time( adjusted for inflation).the vable for gone with the wind is somewhat of an outlier here, but even if we remove gone with the wind, the tred is flat to slightly decreasing. because this represtents the receipts for top movies, this seems to indicate that either the total revenues of box office movies are not increasing over time or that there is greater competition for box-office recepits among movies so the top movies are not deminating the total box office receipts.
1964	$686
1981	$683
1993	$676
1967	$671
1940	$651
2012	$623
1972	$623
1994	$618
1977	$612
2008	$589
1959	$570
1978	$562
2004	$557
1969	$553
2002	$552
1942	$552
1996	$549
1970	$549
1984	$548
1940	$529
1990	$528
1963	$527
1970	$518
1973	$515
1984	$515
1953	$513
2006	$513
1956	$507
2003	$496
1974	$496
1989	$494

U.S. Box Office Receipts (Inflation Adjusted Millions $) 1939 1977 1965 1982 1997 1956 1975 1965 1967 1937 1959 1961 1973 2009 1980 1983 1994 1999 1973 1964 1981 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 2003 1974 1989 1649.5 1425.9 1144.5 1131.8 1095.8 1052.8 1029.3 973.2 870.5 854.4 844.2 824.8 808.7 804.1 771.7 740.5 722.1 719.6 715 686 683.4 675.7 670.7 651 623.4 622.8 618.3 611.8 589 569.7 561.9 557.4 553 552 552 549.1 548.7 547.7 528.5 528.1 526.7 518.2 515.2 515.2 513 512.5 506.6 495.8 495.6 493.5

Sheet2

Budget (Non-Inflation Adjusted Millions $)	World Box Office Receipts (Non-Inflation Adjusted Millions $)
$1	$185
$1	$115
$2	$76
$3	$391
$3	$84
$5	$36
$6	$160
$6	$135
$6	$52
$6	$380
$6	$42
$10	$101
$11	$798
$11	$112
$12	$471
$12	$358
$14	$80
$15	$70
$18	$534
$20	$384
$30	$292
$33	$573
$44	$58
$45	$952
$55	$680
$63	$920
$75	$912
$75	$813
$94	$1,129
$110	$1,027
$139	$807
$150	$1,002
$200	$2,185
$220	$1,512
$225	$1,066
$230	$2,778
--	$163
--	$757
--	$206
--	$215
--	$102
--	$104
--	$300
--	$102
--	$268
--	$106
--	$316
--	$534
--	$120
--	$413

World Box Office Receipts (Non-Inflation Adjusted Millions $) 1 1 2 3 3 5 6 6 6 6 6 10 11 11 12 12 14 15 18 20 30 33 44 45 55 63 75 75 94 110 139 150 200 220 225 230 184.9 115 76.4 390.5 84.3 36 159.6 134.8 51.6 379.8 42 100.5 797.9 111.7 471 357.5 80 70 533.9 384 291.6 573 57.8 951.6 680 920 912 813.1 1129.2 1027 806.7 1001.9 2185.4 1511.8 1065.7 2778.2

Sheet3

U.S. Box Office Receipts (Inflation Adjusted Millions $)
$1,650
$1,426
$1,145
$1,132	max	1650
$1,096	Min	494
$1,053
$1,029
$973	Bin
$871	499
$854	599
$844	699
$825	799
$809	899
$804	999
$772	1099
$741	1199
$722	1299
$720	1399
$715	1499
$686	1599
$683	1699
$676
$671
$651
$623
$623
$618
$612
$589
$570
$562
$557
$553
$552
$552
$549
$549
$548
$529
$528
$527
$518
$515
$515
$513
$513
$507
$496
$496
$494