Data visualization methods

Case Problem Data

Title	Year Released	U.S. Box Office Receipts (inflation-adjusted millions $)	Rating	Genre	Budget (noninflation-adjusted millions $)	World Box Office Receipts (noninflation adjusted millions $)	U.S. Box Office Receipts (noninflation-adjusted millions $)
Gone with the Wind	1939	1650	G	Drama	3	391	199
Star Wars	1977	1426	PG	Scifi/fantasy	11	798	461
The Sound of Music	1965	1145	G	Musical	163	163
E.T.	1982	1132	PG	Scifi/fantasy	757	435
Titanic	1997	1096	PG-13	Drama	200	2185	659
The Ten Commandments	1956	1053	G	Drama	14	80	80
Jaws	1975	1029	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
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. You can do this by first sorting the data using Budget and then creating a scatter chart using only the movies that include data for Budget.) What does this scatter chart indicate about the relationship between the movie’s budget and the world box office receipts? 3. 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? 4. Create a PivotTable for these data. Use the PivotTable to generate a crosstabulation 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? 5. Use the PivotTable to display the average inflation-adjusted U.S. box office receipts for each genre–rating pair for all movies in the dataset. Interpret the results.

Scatter Chart #1

Title	Year Released X	U.S. Box Office Receipts (inflation-adjusted millions $) Y
Gone with the Wind	1939	1650
Star Wars	1977	1426
The Sound of Music	1965	1145
E.T.	1982	1132
Titanic	1997	1096
The Ten Commandments	1956	1053
Jaws	1975	1029
Doctor Zhivago	1965	973
The Jungle Book	1967	871
Snow White and the Seven Dwarfs	1937	854

1939 1977 1965 1982 1997 1956 1975 1965 1967 1937 1650 1426 1145 1132 1096 1053 1029 973 871 854

Year Released

Inflation-Adjusted U.S. Box Office Receipts

Scatter Chart #2

Title	World Box Office Receipts (noninflation adjusted millions $)	Budget (noninflation-adjusted millions $)
Snow White and the Seven Dwarfs	185	1
Gone with the Wind	391	3
Star Wars	798	11
Doctor Zhivago	112	11
Jaws	471	12
The Ten Commandments	80	14
Titanic	2185	200
The Sound of Music	163
E.T.	757
The Jungle Book	206

185 391 798 112 471 80 2185 1 3 11 11 12 14 200

World Box Office Receipts (noninflation-adjusted millions)

Budget (noninflation-adjusted millions)

Frequency Dist.% Dist.Histo #3

Bins (Movie)	Frequency (U.S. Box Office Receipts inflation-adjusted)	Relative Frequency of a bin=Frequency of the Bin / n	% Distribution	Approximate Bin Width Largest data value-smallest data value / Number of Bins
Gone with the Wind	1650	0.1469409565	15	1650-854 (=796)	0.071
Star Wars	1426	0.1269926084	13	11229
The Sound of Music	1145	0.1019681183	10
E.T.	1132	0.1008104016	10
Titanic	1096	0.0976044171	10
The Ten Commandments	1053	0.0937750468	9
Jaws	1029	0.0916377238	9
Doctor Zhivago	973	0.0866506367	9
The Jungle Book	871	0.077567014	8
Snow White and the Seven Dwarfs	854	0.0760530769	7
11229	1	100
100,000,000

Sheet7