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

estimate the regression in problem 5 based on Table 5-6 using Excel s regression function in the Data Analysis menu. b. Using the coefficients found in the regression estimate, enter a formula based...

1 answer below »

estimate the regression in problem 5 based on Table 5-6 using Excel s regression function in the Data Analysis menu. b. Using the coefficients found in the regression estimate, enter a formula based in cells C6 though J6 to forecast the sales revenue when quality control goes from $2 million to $9 million a year. c. Graph both the actual data and the forecast using the graphing tool. Does the forecast vary much from the actual data

additional information is attached such as Problem 5, Table 5-6 and cells C6 through J6

005_crax85k-tt5euxuo.pdf 005_trax85k-4iiyfio4.jpg
Answered Same Day Dec 24, 2021

Solution

Robert answered on Dec 24 2021
131 Votes
Regression Statistics
Multiple R 0.807582
R Square 0.652189
Adjusted R Square 0.623205
Standard E
or 6.686129
Observations 40
The first part of the output is the regression statistics.
These are standard statistics which are given by most
programs.
ANOVA
ANOVA
df SS MS F Significance F
Regression 3 3017.745 1005.915 22.50151 2.22E-08
Residual 36 1609.355 44.70432

Total 39 4627.1


The ANOVA table comes next. This gives a test of
significance of the R2. Note that Excel uses scientific
notation, by default, so when it says 2.22E-08 it means,
2.22 * 10-8. (i.e. 0.0000000222).
Coefficients
Coefficients
Standard
E
or
t
Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 12.39 3.90 3.18 0.00 4.48 20.29 4.48 20.29
HASSLES -0.06 0.34
-
0.19 0.85 -0.75 0.62 -0.75 0.62
HASSLES2 0.00 0.01 0.06 0.95 -0.02 0.02 -0.02 0.02
HASSLES3 0.00 0.00...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File