The file S02_02.xlsx contains data about 211 movies released in 2006 and 2007. The question to be explored in this problem is whether the total gross for a movie can be predicted from how it does in its first week or two.
a. Create a table of correlations between the five variables 7-day Gross, 14-day Gross, Total US
Gross, International Gross, and US DVD Sales. Does it appear that the last three variables are related to either of the first two?
b. Explore the basic question further by creating a scatter plot of each of Total US Gross, International Gross, and US DVD Sales (Y axis) versus each of 7-day Gross and 14-day Gross (X axis)—six scatter plots in all. Do these support the claim that you can tell how well a movie will do by seeing how it does in its first week or two?