Answers for 4, 5, and 6 please. Please use Excel Data Analysis toolpack, and ple
ID: 3319967 • Letter: A
Question
Answers for 4, 5, and 6 please. Please use Excel Data Analysis toolpack, and please do not round any numbers. Thanks!
Name: Month Jan Feb Mar Apr May Jun Sales Advertising $ 3,000 5,000 7,000 9,000 11,000 13,000 15,000 17,000 19,000 21,000 23,000 9,000 11,200 18,500 29,500 41,900 74,000 90,400 148,000 200,500 295,000 340,000 Do not change the data sets. Instructions: 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. 1Aug 2 Sep 3 1Oct 4 Nov 5Dec Questions are worth 1 point each for a total of 15. This is an open book/notes test. You may use Excel or SPSS to complete this exam. This is an individual effort, so no collaborating with others. Keep answers within the yellow spaces 7 J State the null and alternative hypotheses for this study 18 Ho 19 Ha 21.2. Run the regression analysis using a 95% confidence level and include the report.Explanation / Answer
Result:
Answers for 4, 5, and 6 please. Please use Excel Data Analysis toolpack, and please do not round any numbers. Thanks!
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
4). Correlation coefficient = 0.930629
5). Intercept =-99645.9
6). Slope = 16.46227
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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.