Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Marketer Hours of Training (X) Sales Revenue (Y) 1 3 157643 2 6 127253 3 4 97777 4 3 167183 5 8 171802 6 2
Marketer | Hours of Training (X) | Sales Revenue (Y) |
1 | 3 | 157643 |
2 | 6 | 127253 |
3 | 4 | 97777 |
4 | 3 | 167183 |
5 | 8 | 171802 |
6 | 2 | 138011 |
7 | 2 | 151582 |
8 | 10 | 107909 |
9 | 5 | 117778 |
10 | 5 | 118944 |
11 | 8 | 122820 |
12 | 3 | 146171 |
13 | 9 | 136366 |
14 | 5 | 72333 |
15 | 3 | 89541 |
16 | 7 | 185653 |
17 | 12 | 128204 |
18 | 6 | 121559 |
19 | 4 | 148737 |
20 | 4 | 80936 |
21 | 8 | 148105 |
22 | 6 | 165422 |
23 | 9 | 128784 |
24 | 10 | 154596 |
25 | 4 | 104001 |
26 | 3 | 113926 |
27 | 12 | 205264 |
28 | 9 | 217471 |
29 | 5 | 90178 |
30 | 7 | 129313 |
31 | 6 | 123686 |
32 | 3 | 136791 |
33 | 8 | 101543 |
34 | 6 | 143833 |
35 | 7 | 121203 |
36 | 3 | 118528 |
37 | 11 | 126951 |
38 | 10 | 101837 |
39 | 5 | 108181 |
40 | 5 | 110495 |
41 | 3 | 128540 |
42 | 4 | 143944 |
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.24 | |||||||
R Square | 0.06 | |||||||
Adjusted R Square | 0.03 | |||||||
Standard Error | 30180.01 | |||||||
Observations | 42.00 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 2157936031 | 2.16E+09 | 2.369189 | 0.131625497 | |||
Residual | 40 | 36433325185 | 9.11E+08 | |||||
Total | 41 | 38591261216 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 115590.35 | 11164.94 | 10.35 | 0.00 | 93025.16 | 138155.54 | 93025.16 | 138155.54 |
Hours of Training (X) | 2592.88 | 1684.55 | 1.54 | 0.13 | -811.71 | 5997.48 | -811.71 | 5997.48 |
1.With reference to your estimated equation, calculate (using a calculator) a 90& confidenceintervalforthecoefficientofX(i.e.2)inthemodel. Inperformingthis calculation,usetherelevantestimatedstandarderroroftheestimatorofthe coefficientofXgiveninyoursummaryExcel regressionoutput.Givean interpretation of theconfidenceintervalyoucalculate. (2 marks)
2.Giveaninterpretationoftherealizedcoefficientofdeterminationvalue(r2)givenin yoursummaryExcel regression output. (2 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started