Do not round the values further when calculating. Use them as they are in the output. Round yo final answer to two decimal places. $263.91 $5168.65 263.91 months 4634.40 months $4634.40 Question 44 Continue referring to the regression results in the prior question. For each additional [Select] [Select] by ✓ [Select] one $1.44 $6.61 $4050.07 [Select 1 on average. predicted to

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
The first box options are: month of experience, salesperson in the territory, and dollar in sales. The 2nd select box answer options are Sales are, Experience is, Number of Salespeople are. The third select box answers are decrease, and increase. The 4th select box options are displayed in the attached image.
Here is the Excel output again for the regression of Sales and Experience:
Regression Statistics
0.5966
0.3559
0.339
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Regression
Residual
Total
Intercept
Experience
(months)
497.9058
40
df
1
38
39
Standard
Error
4250.9742 180.2332
Coefficients
MS
5205388.04 5205388.04
9420585.51
247910.15
14625973.55
6.6108
SS
1.4427
t Stat
23.586
4.5822
P-value
2.71E-24
4.85E-05
F
20.9971
Significance F
4.85E-05
Lower 95% Upper 95%
3886.1113 4615.8372
3.6902
9.5313
Use the estimated regression equation given by this regression to predict sales if the territory
salesperson has 58 months of experience at the company.
Do not round the values further when calculating. Use them as they are in the output. Round your
final answer to two decimal places.
Transcribed Image Text:Here is the Excel output again for the regression of Sales and Experience: Regression Statistics 0.5966 0.3559 0.339 Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept Experience (months) 497.9058 40 df 1 38 39 Standard Error 4250.9742 180.2332 Coefficients MS 5205388.04 5205388.04 9420585.51 247910.15 14625973.55 6.6108 SS 1.4427 t Stat 23.586 4.5822 P-value 2.71E-24 4.85E-05 F 20.9971 Significance F 4.85E-05 Lower 95% Upper 95% 3886.1113 4615.8372 3.6902 9.5313 Use the estimated regression equation given by this regression to predict sales if the territory salesperson has 58 months of experience at the company. Do not round the values further when calculating. Use them as they are in the output. Round your final answer to two decimal places.
Do not round the values further when calculating. Use them as they are in the output. Round ye
final answer to two decimal places.
$263.91
$5168.65
263.91 months
O 4634.40 months
$4634.40
Question 44
Continue referring to the regression results in the prior question.
For each additional [Select]
[Select]
by
✓ [Select ]
one
$1.44
$6.61
$4250.97
$7.57
[Select 1
on average.
1
predicted to
Transcribed Image Text:Do not round the values further when calculating. Use them as they are in the output. Round ye final answer to two decimal places. $263.91 $5168.65 263.91 months O 4634.40 months $4634.40 Question 44 Continue referring to the regression results in the prior question. For each additional [Select] [Select] by ✓ [Select ] one $1.44 $6.61 $4250.97 $7.57 [Select 1 on average. 1 predicted to
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman