The file P02_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. (If you use Stat Tools, it will warn you about missing data, but donĂ˘â‚¬â„˘t worry about it.) 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 scatterplot 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 scatterplots 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?
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You wonâ€™t have to worry about the quality and deadlinesOrder Paper Now