The sales in billions of dollars of Keller Overhead Door Inc

The sales, in billions of dollars, of Keller Overhead Door Inc. for 2009 to 2014 are:

Use the trend equation to calculate the points for 2011 and 2014. (Round your answers to 3 decimal places.)

Year	Sales	Year	Sales
2009	7.75		2012	7.74
2010	7.23		2013	7.86
2011	8.87		2014	7.00

Solution

Regression Analysis

r²

0.061

n

6

r

-0.247

k

1

Std. Error

0.702

Dep. Var.

sales

ANOVA table

Source

SS

df

MS

F

p-value

Regression

0.1277

1  

0.1277

0.26

.6375

Residual

1.9714

4  

0.4928

Total

2.0991

5  

Regression output

confidence interval

variables

coefficients

std. error

   t (df=4)

p-value

95% lower

95% upper

Intercept

8.0407

0.6536

12.303

.0003

6.2261

9.8552

year

-0.0854

0.1678

-0.509

.6375

-0.5514

0.3805

Predicted values for: sales

95% Confidence Intervals

95% Prediction Intervals

year

Predicted

lower

upper

lower

upper

Leverage

3

7.784

6.95525

8.61352

5.66622

9.90254

0.181

6

7.528

6.11741

8.93878

5.12203

9.93417

0.524

9

7.272

4.58848

9.95514

3.95527

10.58835

1.895

a.            Determine the least squares trend equation. (Round your answers to 4 decimal places.)

sales = 8.0407 – 0.0854*t           

b.            Use the trend equation to calculate the points for 2011 and 2014. (Round your answers to 3 decimal places.)

                For 2011, predicted y = 7.784 and for 2014, predicted y =7.528

c.             Estimate the net sales for 2017. (Round your answer to 3 decimal places.)

predicted y =7.272

               

Regression Analysis
	r²	0.061	n	6
	r	-0.247	k	1
	Std. Error	0.702	Dep. Var.	sales
ANOVA table
Source	SS	df	MS	F	p-value
Regression	0.1277	1	0.1277	0.26	.6375
Residual	1.9714	4	0.4928
Total	2.0991	5
Regression output				confidence interval
variables	coefficients	std. error	t (df=4)	p-value	95% lower	95% upper
Intercept	8.0407	0.6536	12.303	.0003	6.2261	9.8552
year	-0.0854	0.1678	-0.509	.6375	-0.5514	0.3805
Predicted values for: sales
		95% Confidence Intervals	95% Prediction Intervals
year	Predicted	lower	upper	lower	upper	Leverage
3	7.784	6.95525	8.61352	5.66622	9.90254	0.181
6	7.528	6.11741	8.93878	5.12203	9.93417	0.524
9	7.272	4.58848	9.95514	3.95527	10.58835	1.895