Compute all of the ? and complete the tables. Write the formulas and computations. Show all of your work and explain completely your results, insights amd meanings. Here, NA means not available. Estimate the level of DVD sales (measured in million dollars) for movies, by using the amount of annual revenue (measured in million dollars) generated by the box office gross. We randomly selected a sample of 43 movies for the same year. Excel (for α = 0.05) printed out: r 2 = 0.5123, SY.X = 12.2279, tcritical = 2.0195, hin = 0.026249, b0 = 4.8445, b1 = 0.1631. Assume normality and homoscedasticity are satisfied. a) Interpret the meaning for the coefficient of determination and also the standard error of prediction, for this problem. b) At the 0.05 level of significance, is there evidence of a linear relationship between the revenues of DVD sales and the box-office gross? c) Construct the 95% confidence interval of the actual mean revenue of DVD sales for all the movies that generated 100 million dollars box-office gross. d) Construct the 95% prediction interval for the actual revenue of DVD sales for a movie that generated 100 million dollars box-office gross. Source df Sum of Square Mean Squares F stat p - value F crit Regression Error 1 ? 6439.6133 ? ? ? ? N/A 4.0785 Total 42 12570.025
Compute all of the ? and complete the tables.
Write the formulas and computations.
Show all of your work and explain completely your results, insights amd meanings.
Here, NA means not available.
Estimate the level of DVD sales (measured in million dollars) for movies, by using the amount of annual revenue (measured in million dollars) generated by the box office gross. We randomly selected a sample of 43 movies for the same year.
Excel (for α = 0.05) printed out: r 2 = 0.5123, SY.X = 12.2279,
tcritical = 2.0195, hin = 0.026249, b0 = 4.8445, b1 = 0.1631.
Assume normality and homoscedasticity are satisfied.
a) Interpret the meaning for the coefficient of determination and also the standard error of prediction, for this problem. b) At the 0.05 level of significance, is there evidence of a linear relationship between the revenues of DVD sales and the box-office gross?
c) Construct the 95% confidence interval of the actual mean revenue of DVD sales for all the movies that generated 100 million dollars box-office gross.
d) Construct the 95% prediction interval for the actual revenue of DVD sales for a movie that generated 100 million dollars box-office gross.
|
Source |
df |
Sum of Square |
Mean Squares |
F stat |
p - value |
F crit |
|
Regression Error |
1 ? |
6439.6133 ? |
? ? |
? | N/A | 4.0785 |
| Total | 42 | 12570.025 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
