Question

Find:r, r2, p-value Determine if the is significant positive or negative linear correlation using the p-value method Find the regression equation. Make prediction for and find residuals for data points identifieded in problems. Explain b1 (slope) Give CV and test for correlation using the traditional method. The data for this in the Excel file under Content, 3B called “Data HW 3B” 1. The following is the budget and gross for the 10 movies with the largest budgets, according to http://www.the-numbers.com/movie/budgets/all Round all data to the nearest million dollar (123,456,789 would be 123). Find the residuals for Avatar, John Carter, and The Hobbbit:The Desolation of Smaug. Use α = 0.05. Release Date Movie Budget Gross 1

12/18/2009 Avatar $425,000,000 $760,507,625

5/24/2007 Pirates of the Caribbean: At World's End $300,000,000 $309,420,425

7/20/2012 The Dark Knight Rises $275,000,000 $448,139,099

7/2/2013 The Lone Ranger $275,000,000 $89,289,910

3/9/2012 John Carter $275,000,000 $73,058,679

11/24/2010 Tangled $260,000,000 $200,821,936

5/4/2007 Spider-Man 3 $258,000,000 $336,530,303

12/14/2012 The Hobbit: An Unexpected Journey $250,000,000 $303,003,568

7/15/2009 Harry Potter and the Half-Blood Prince $250,000,000 $301,959,197

12/13/2013 The Hobbit: The Desolation of Smaug $250,000,000 $258,366,855

Answer 1

Anser tron alpha, ke _pan -70 reject The null gretS T'este r TFan ion beComes Gross .8Budlyet + o Movie The hobbit The Drsolation t 258, 366,835 -。3,98s, onis (1445,614,唏u : 2”.too,oco Summau of output

SUMMARY OUTPUT Regression Statistics MultipleR R Square Adjusted R Square Standard Error Observations 0.761834888 0.580392396 0.527941446 133984865.9 10 ANOVA Significance F 0.01043901 MS Regression Residual Total 1 1.98646E+17 1.98646E+17 11.06543144 8 1.43616E+17 1.79519E+16 9 3.42262E+17 Coefficients Standard Error -485419922.1 242283277.8 -2.003522185 Lower 95% Ur95% Lower 95.0% Upper 95.0% -1044126163 73286318.41 -1044126163 73286318.41 2.815932157 0.846521537 3.326474325 0.01043901 0.863849993 4.768014321 0.863849993 4.768014321 t Stat P-value Intercept Budget