I have included all of the questions as a reference ti what is expected, but I O
ID: 3319974 • Letter: I
Question
I have included all of the questions as a reference ti what is expected, but I ONLY need answers for 10-13. Please use Excel Data Analysis toolpack, and please do not round any answers. Thanks!!
Sales Advertising $ 3,000 5,000 7,000 9,000 11,000 13,000 15,000 17,000 19,000 21,000 23,000 Month anie: 9,000 11,200 18,500 29,500 41,900 74,000 90,400 148,000 200,500 295,000 340,000 Jan Feb Do not change the data sets. Mar Instructions: Apr May Jun 0 Jul 1 Aug 12 Sep 13 Oct 14 Nov 15 Dec This is a study of whether advertising spending affects sales. Or, are other variables at play? The type of business is your call -use your imagination. Questions are worth 1 point each for a total of 15. This is an open book/notes test. You may use Excel SPSS to complete this exam. This is an individual elfort, so no collaborating with others. Keep answers within the yellow spaces 17 L state the null and alternative hypotheses for this study. 18 Ho: 19 euel and include the report.Explanation / Answer
Result:
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.930629
R Square
0.866071
Adjusted R Square
0.85119
Standard Error
45264.26
Observations
11
ANOVA
df
SS
MS
F
Significance F
Regression
1
1.19E+11
1.19E+11
58.19979
3.23E-05
Residual
9
1.84E+10
2.05E+09
Total
10
1.38E+11
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
-99645.9
31196.24
-3.19416
0.010933
-170217
-29075.1
advertising
16.46227
2.157889
7.628879
3.23E-05
11.58079
21.34376
Regression line is Predicted sales =-99645.9+16.46227*sales
10). When advertising = 31000,
Predicted sales =-99645.9+16.46227*31000
=410684.5
11). When advertising = 33000,
Predicted sales =-99645.9+16.46227*33000
=443609
12). When advertising = 35000,
Predicted sales =-99645.9+16.46227*35000
=476533.6
13).
P= 0.0000323
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.930629
R Square
0.866071
Adjusted R Square
0.85119
Standard Error
45264.26
Observations
11
ANOVA
df
SS
MS
F
Significance F
Regression
1
1.19E+11
1.19E+11
58.19979
3.23E-05
Residual
9
1.84E+10
2.05E+09
Total
10
1.38E+11
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
-99645.9
31196.24
-3.19416
0.010933
-170217
-29075.1
advertising
16.46227
2.157889
7.628879
3.23E-05
11.58079
21.34376