Q3: The following table (on the next paçe) can be pastec into excel, for calaula
ID: 3047825 • Letter: Q
Question
Q3: The following table (on the next paçe) can be pastec into excel, for calaulation speec, or feel free to make calculations by-hand. The table indluces cata on box offioe revenue (in dollars) for movies anc an index of star power (The Higher the incex, the greater the star power) anc an incex of action (the higher the incex the more action scenes) A) Annotate a mocel, in econometric notation, that describes box offioe revenue as a linear function of star power anc action. B) Annotate a mocel, in econometric notation, that describes star power as a linear function of action, and the reverse (please use cifferent parameter symbols) C) Estimate the variances of each of variables in the regression from part B D) Estimate the covariance for the variables from regression in pert B E) Calculate the recression parameters from the regression in part3 F) What are the estimeted OLS models from pert B? G) Wrat are the resicuals from both regressions in part H) Calculate the parameters between box office revenue anc the aspect of star power that is uncorrelatec with action, and the era eters Detween Doxce revenue and the as )(OL action unoorrelated with ster power, ie from reçression in part A (hint = ( ri! yi)/( rii )), where r is the residual from oart ) Wrat is the estimatec OLS mocel for the regression in part A?Explanation / Answer
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
5444200.241
4616960.126
1.179
.255
Star Power Index
-5063.300
2600.505
-.331
-1.947
.068
Action Index
404393.708
106248.347
.647
3.806
.001
From above table we can write Box office Revenue as a linear regression in terms of Star power index and Action Index as follows,
It means that Star Power Index has insignificant reverse effect on Box office Revenue whereas Action Index has significant positive effect on it.
b)
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
363.325
409.612
.887
.387
Action Index
1.728
9.621
.042
.180
.859
a. Dependent Variable: Star Power Index
From above table we can write Star Power Index as a linear regression in terms of Action Index as follows,
Star Power Index = 363.325 + 1.728 Action Index ………….(1)
It means that Action Index has positive impact on Star Power Index. But this impact is insignificant.
SE of Star Power Index = 1033.51104
SE of Action Index = 9.621
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
34.711
6.162
5.633
.000
Star Power Index
.001
.006
.042
.180
.859
a. Dependent Variable: Action Index
From above table we can write Action Index as a linear regression in terms of Star Power Index as follows,
Action Index = 34.711 + 0.001 Star Power Index………….(2)
It means that Action Index has insignificant and very negligible positive impact on Star Power Index.
SE of Star Power Index = 0.006
SE of Action Index = 25.296
d) Covariance between Star Power Index and Action Index = 996.9825
e) Regression parameters are mentioned in equation (1) and (2)
f) Residuals in both models are as follows:
(1) 1068145.071
(2) 639.884
Coefficients
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
5444200.241
4616960.126
1.179
.255
Star Power Index
-5063.300
2600.505
-.331
-1.947
.068
Action Index
404393.708
106248.347
.647
3.806
.001
- Dependent Variable: Box Office Revenue
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.