FORECASTING MODEL
Y = a +
b X
Sales
= a + b Time
|
Year
|
Time (X)
|
Sales (Y)
|
XY
|
X2
|
|
2001
|
1
|
450
|
|
|
|
2002
|
2
|
480
|
|
|
|
2003
|
3
|
475
|
|
|
|
2004
|
4
|
490
|
|
|
|
2005
|
5
|
486
|
|
|
|
2006
|
6
|
499
|
|
|
|
2007
|
7
|
495
|
|
|
|
2008
|
8
|
510
|
|
|
|
2009
|
9
|
504
|
|
|
|
2010
|
10
|
526
|
|
|
|
|
|
|
|
|
b = ( N
ΣXY -
ΣX ΣY ) / (
N ΣX2 - (ΣX)2 ) ( N = 10)
b =
a = ( ΣY - b ΣX ) / N
a =
We get…
Y = 456.33 + 6.39 X
Solving Equation
Y = 456.33 + 6.39 (11) Y =
526.67
|
Year
|
Time (X)
|
Forecasting
|
|
2011
|
11
|
526.67
|
|
2012
|
12
|
|
|
2013
|
13
|
|
|
2014
|
14
|
|
|
2015
|
15
|
|
No hay comentarios:
Publicar un comentario