Pronostico de Venta
3
PRONOSTICO DE VENTA Años X Y (Ingresos) XY X² Y² 2010 0 $ 595,000.00 0 0 $ 354,025,000,000.00 2011 1 $ 624,750.00 $ 624,750.00 1 $ 390,312,562,500.00 2012 2 $ 655,987.50 $ 1,311,975.00 4 $ 430,319,600,156.25 2013 3 $ 688,786.88 $ 2,066,360.639 $ 474,427,359,172.27 2014 4 $ 723,226.22 $ 2,892,904.88 16 $ 523,056,163,487.42 = Ƹ 10 $ 3,287,750.59 $ 6,895,990.50 30 $ 2,172,140,685,315.94 A = X² Y- X XY Ԑ Ԑ Ԑ Ԑ = $ 29,672,612.81 = $ 593,452.26 n x²-(x)² Ԑ Ԑ 50 = n x!-x ! Ԑ Ԑ Ԑ = $ 1,602,446.56 = $ 32,048.93 n x²-(x)² Ԑ Ԑ 50 "## # "%&A' A# % e = Y²- !-* x! Ԑ Ԑ Ԑ + n-2 % e = $ 8,552,032.57 = $ 2,850,677.52 = 1688.39 + 3 A 6 Y = *x Y = 593452.26 32048.93(6) Y = $ 785,745.84 ! ± %e 785745.84/1688.39(2) $ 789,122.62 - $ 782,369.06
-
Upload
eduardo-metelin -
Category
Documents
-
view
1 -
download
0
description
PRONC
Transcript of Pronostico de Venta
PRONOSTICO DE VENTA
AosXY (Ingresos)XYXY
20100 $ 595,000.00 00 $ 354,025,000,000.00
20111 $ 624,750.00 $ 624,750.00 1 $ 390,312,562,500.00
20122 $ 655,987.50 $ 1,311,975.00 4 $ 430,319,600,156.25
20133 $ 688,786.88 $ 2,066,360.63 9 $ 474,427,359,172.27
20144 $ 723,226.22 $ 2,892,904.88 16 $ 523,056,163,487.42
=10 $ 3,287,750.59 $ 6,895,990.50 30 $ 2,172,140,685,315.94
A=XY-XXY= $ 29,672,612.81 = $ 593,452.26
nx-(x)50
B=nxy-xy= $ 1,602,446.56 = $ 32,048.93
nx-(x)50
ERROR ESTANDAR
Se=Y-ay-bxy
\n-2
Se= $ 8,552,032.57 = $ 2,850,677.52 =1688.39
\3
AO 6
Y=a+bx
Y= 593452.26+32048.93(6)
Y= $ 785,745.84
ySez
785745.841688.39(2)
+ $ 789,122.62
- $ 782,369.06
AO 7
Y=a+bx
Y= 593452.26+32048.93(7)
Y= $ 817,794.78
ySez
817794.781688.39(2)
+ $ 821,171.56
- $ 814,418.00
AO 8
Y=a+bx
Y= 593452.26+32048.93(8)
Y= $ 849,843.71
ySez
849843.711688.39(2)
+ $ 853,220.49
- $ 846,466.93
AO 9
Y=a+bx
Y= 593452.26+32048.93(9)
Y= $ 881,892.64
ySez
881892.641688.39(2)
+ $ 885,269.42
- $ 878,515.86
AO 10
Y=a+bx
Y= 593452.26+32048.93(10)
Y= $ 913,941.57
ySez
913941.571688.39(2)
+ $ 917,318.35
- $ 910,564.79
AosPesimistaNormalOptimista
6 $ 782,369.06 $ 785,745.84 $ 789,122.62
7 $ 814,418.00 $ 817,794.78 $ 821,171.56
8 $ 846,466.93 $ 849,843.71 $ 853,220.49
9 $ 878,515.86 $ 881,892.64 $ 885,269.42
10 $ 910,564.79 $ 913,941.57 $ 917,318.35
