Would like assistance on my stats assignment, all excel work should be copied onto a word document please. Thank you so much NOTE1: Please note that in parts h) and i) you can assume...

1 answer below »

View more »
Answered Same DayDec 29, 2021

Answer To: Would like assistance on my stats assignment, all excel work should be copied onto a word document...

Robert answered on Dec 29 2021
134 Votes
a) Scatter Plot between Revenue and Budget is as given below:


Scatter Plot of Revenue v/s Screens is as given below:



The Correlation Matrix for the three variables is as given below:

Correlations

REVENUE BUDGET SCREENS
REVENUE Pearson Correlation 1 .518 .745
BUDGET Pearson Correlation .518 1 .685
SCREENS Pearson Correlation .745 .685 1
b) Regression with Revenue as dependent variable and Budget and Screens as
independent variables is as follows:
Model Summary
Model R R Square
Adjusted R
Square
Std. Error of the
Estimate
1 .745
a
.555 .554 4879108.119
ANOVA
b

Model Sum of Squares df Mean Square F Sig.
1 Regression 2.932E16 2 1.466E16 615.821 .000
a

Residual 2.354E16 989 2.381E13
Total 5.286E16 991
Coefficients
a

Model
Unstandardized Coefficients
Standardized
Coefficients
t Sig. B Std. Error Beta
1 (Constant) -3.644E6 356720.901 -10.216 .000
BUDGET .003 .005 .015 .529 .597
SCREENS 56394.411 2237.948 .734 25.199 .000
a. Dependent Variable: REVENUE
The regression line is as follows:
Revenue = -3.64 * 10
6
+ .003* Budget + 56394.411*Screens
It can be seen that regression coefficient for Budget is not significant as p value for t statistic
is more than 0.05. Regression coefficient for Screens is significant at 5% level of
significance. This shows that a one unit change in Screens leads to a 56394.411 units change
in Revenue.
c) Scatter Plot of Residuals v/s Budget is as given below:

Scatter Plot of Residual v/s Screens is as given:

Histogram of standardized Residuals is given below:
From the histogram we can observe that Residuals do not follows Normal Distribution thus
the assumption of normality is violated. From the Scatter plot of Residuals v/s Screens and
Budget, it can be seen that there are many outliers. Thus the non normality of residuals could
be due to outliers.
d) Now, we transform the variables and take the natural logarithms and obtain the
regression line as follows:
ANOVA
b

Model Sum of Squares df Mean Square F Sig.
1 Regression 238.858 2 119.429 305.479 .000
a

Residual 386.656 989 .391
Total 625.515 991
a. Predictors: (Constant), LnScr,...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30