Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

To get a sense of the data, provide two well labeled scatter-plots of 1) revenue vs. budget, and 2) revenue vs. screens. Also, provide a correlation matrix of these three variables b) After speaking...

1 answer below »

To get a sense of the data, provide two well labeled scatter-plots of 1) revenue vs. budget, and 2) revenue vs. screens. Also, provide a correlation matrix of these three variables

b) After speaking to an industry expert, they tell you that budget and screens are the most important determinants of film success at the box office (advertising is important too, the expert tells you, but you don’t have data on that). Produce a regression with ‘revenue’ as the dependent variable and ‘budget’ and ‘screens’ as the independent variables. Interpret the regression coefficients.

c) With your regression results of part b), provide residual plots vs. each independent variable. Also, provide a histogram of the (standardised) residuals. Comment on the nature of the residuals based upon these three plots.

d) You show your results and plots to your econometrics professor at university and he tells you that you may have an issue with non-normal errors caused by outliers. He suggests you transform the revenue, screens, and budget data into natural logarithms and re-estimate the equation, which you do. Provide results of the new regression and interpret the regression coefficients [Hint: d lnY/d lnX = (dY/dX)*(X/Y) = (dY/Y)/(dX/X)].

e) With your new regression results of part d), provide residual plots vs. each independent variable. Also, provide a histogram of the (standardised) residuals. Comment on the nature of the new residuals based upon these three plots.

Document Preview:

Example Regression Output

Answered Same Day Dec 23, 2021

Solution

Robert answered on Dec 23 2021
118 Votes
a) Scatter Plots are given below

Figure 1: Scatter Plot of Revenue and Budget.


Figure 2: Scatter Plot of Revenue and Screens.

The Co
elation Matrix for Revenue, Budget and Screens is as given in Table 1.









Co
elations
REVENUE BUDGET SCREENS
REVENUE Pearson Co
elation 1 .518 .745
BUDGET Pearson Co
elation .518 1 .685
SCREENS Pearson Co
elation .745 .685 1
Table 1: Co
elation Matrix.
) A multiple linear regression is fitted with Revenue as dependent variable and
Budget and Screen as predictor variables.
Model
Unstandardized Coefficients
Standardized
Coefficients
t Sig. B Std. E
or Beta
1 (Constant) -3.644E6 356720.901 -10.216 .000
BUDGET .003 .005 .015 .529 .597
SCREENS 56394.411 2237.948 .734...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here