Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Number Theory

Authors: William J LeVeque

1st Edition

0486141500, 9780486141503

More Books

Students also viewed these Mathematics questions

Question

What do you plan on doing upon receiving your graduate degree?

Answered: 1 week ago

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago