What percentage of the variation in Sales is explained by Experience?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 4GP
icon
Related questions
Question
Here is the Excel output for the regression of Sales and Experience:
Regression Statistics
0.5966
0.3559
Multiple R
R Square
Adjusted R
Square
Standard Error
Observations 40
ANOVA
Regression
Residual
Total
Intercept
Experience
(months)
0.339
497.9058
df
1
38
39
Coefficients
MS
5205388.04 5205388.04
247910.15
6.6108
SS
Standard
Error
4250.9742 180.2332 23.586
9420585.51
14625973.55
1.4427
t Stat
4.5822
P-value
2.71E-24
4.85E-05
What percentage of the variation in Sales is explained by Experience?
F
20.9971
Lower 95% Upper 95%
3886.1113
Significance F
4.85E-05
3.6902
4615.8372
9.5313
Transcribed Image Text:Here is the Excel output for the regression of Sales and Experience: Regression Statistics 0.5966 0.3559 Multiple R R Square Adjusted R Square Standard Error Observations 40 ANOVA Regression Residual Total Intercept Experience (months) 0.339 497.9058 df 1 38 39 Coefficients MS 5205388.04 5205388.04 247910.15 6.6108 SS Standard Error 4250.9742 180.2332 23.586 9420585.51 14625973.55 1.4427 t Stat 4.5822 P-value 2.71E-24 4.85E-05 What percentage of the variation in Sales is explained by Experience? F 20.9971 Lower 95% Upper 95% 3886.1113 Significance F 4.85E-05 3.6902 4615.8372 9.5313
O 59.66%
O 35.59
O 33.9%
O .3559%
Transcribed Image Text:O 59.66% O 35.59 O 33.9% O .3559%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill