PROYECCION.xlsx
11
AÑO N° Poblacion Demanda 2006 1 18654 12330.00 2007 2 19117 15662.60 2008 3 19832 31850.60 2009 4 20137 35816.22 2010 5 20354 34225.19 2011 6 21125 24170.13 2012 7 21987 37850.14 2013 8 23207 40689.75 2014 9 23598 38675.26 2015 10 24199 42356.20 N° POBLACION X Y XY X^2 1 18654 18654 1 2 19117 38234 4 3 19832 59496 9 4 20137 80548 16 5 20354 101770 25 6 21125 126750 36 7 21987 153909 49 8 23207 185656 64 9 23598 212382 81 10 24199 241990 100 ∑ 55 212210 1219389 385 Y = bX + a n= 10 b= 633.14 a= 17738.73 y= 633.14 X + PROYECCION DE POBLACI
-
Upload
ronald-broncano-obregon -
Category
Documents
-
view
212 -
download
0
Transcript of PROYECCION.xlsx
AÑO N° Poblacion Demanda Oferta TM
2006 1 18654 12330.00 9117.502007 2 19117 15662.60 12442.102008 3 19832 31850.60 27989.802009 4 20137 35816.22 32356.162010 5 20354 34225.19 31222.572011 6 21125 24170.13 20876.732012 7 21987 37850.14 33798.242013 8 23207 40689.75 38351.362014 9 23598 38675.26 34720.482015 10 24199 42356.20 32820.66
N° POBLACION
X Y XY X^2 Y^21 18654 18654 1 3479717162 19117 38234 4 3654596893 19832 59496 9 3933082244 20137 80548 16 4054987695 20354 101770 25 4142853166 21125 126750 36 4462656257 21987 153909 49 4834281698 23207 185656 64 5385648499 23598 212382 81 556865604
10 24199 241990 100 585591601∑ 55 212210 1219389 385 4537239562
Y = bX + a
n= 10
b= 633.14
a= 17738.73
y= 633.14 X + 17738.73
PROYECCION DE POBLACION
0 2 4 6 8 10 120
5000
10000
15000
20000
25000
30000
f(x) = 633.139393939394 x + 17738.7333333333R² = 0.974661959695041
Chart Title
3212.503220.503860.803460.063002.623293.404051.902338.393954.789535.54
PROYECCION N° COBRE TM
AÑO X POBLACION AÑO X Y2016 11 24703.2633 2016 1 9117.502017 12 25336.4027 2017 2 12442.102018 13 25969.5421 2018 3 27989.802019 14 26602.6815 2019 4 32356.162020 15 27235.8209 2020 5 31222.572021 16 27868.9603 2021 6 20876.732022 17 28502.0997 2022 7 33798.242023 18 29135.2391 2023 8 38351.362024 19 29768.3785 2024 9 34720.482025 20 30401.5179 2025 10 32820.66
55 273695.65.5
POBLACION
Y(11) 24703.2633Y(12) 25336.4027 n= 10Y(13) 25969.5421Y(14) 26602.6815 b= 2515.55Y(15) 27235.8209Y(16) 27868.9603 a= 13534Y(17) 28502.0997Y(18) 29135.2391 y= 2515.55
DEMANDAINSATISFECHA
PROYECCION DE POBLACION
PROYECCION DE COBRE
Y(19) 29768.3785Y(20) 30401.5179
0 2 4 6 8 10 120
5000
10000
15000
20000
25000
30000
f(x) = 633.139393939394 x + 17738.7333333333R² = 0.974661959695041
Chart Title
0 2 4 6 8 10 120.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
40000.00
45000.00
R² = 0.590631357721758f(x) = 2515.54727272727 x + 13534.05
PROYECCION DE OFERTA
PROYECCION Poblacion
XY X^2 Y^2 AÑO X COBRE TM X9117.5 1 83128806.3 2016 11 18654
24884.2 4 154805852 2017 12 1911783969.4 9 783428904 2018 13 19832
129424.64 16 1046921090 2019 14 20137156112.85 25 974848877 2020 15 20354125260.38 36 435837855 2021 16 21125236587.68 49 1142321027 2022 17 21987306810.88 64 1470826814 2023 18 23207312484.32 81 1205511731 2024 19 23598328206.6 100 1077195723 2025 20 24199
1712858.45 385 8374826681 212210
Y = bX + a
COBRE TM
Y(11) 41205.02 n=Y(12) 43720.5672727Y(13) 46236.1145455 b=
r= 0.7685 Y(14) 48751.6618182Y(15) 51267.2090909 a=Y(16) 53782.7563636Y(17) 56298.3036364
X + 13534 Y(18) 58813.8509091 y=
PROYECCION DE COBRE PROYECCION DE DEMANDA
Y(19) 61329.3981818Y(20) 63844.9454545
0 2 4 6 8 10 120.00
5000.00
10000.00
15000.00
20000.00
25000.00
30000.00
35000.00
40000.00
45000.00
R² = 0.590631357721758f(x) = 2515.54727272727 x + 13534.05
PROYECCION DE OFERTA
18000 19000 20000 21000 22000 23000 24000 250000.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
f(x) = 0.54492504233278 x − 7570.80532334391R² = 0.276498030464844
PROYECCION
Y XY X^2 Y^2 AÑO3212.50 59925975 347971716 10320156.25 20163220.50 61566298.5 365459689 10371620.25 20173860.80 76567385.6 393308224 14905776.64 20183460.06 69675228.22 405498769 11972015.20 20193002.62 61115327.4800001 414285316 9015726.86 20203293.40 69573075 446265625 10846483.56 20214051.90 89089125.3 483428169 16417893.61 20222338.39 54267016.73 538564849 5468067.79 20233954.78 93324898.44 556865604 15640284.85 20249535.54 230750532.46 585591601 90926523.09 2025
39930.49 865854862.73 4537239562 195884548.11
Y = bX + a
10
0.544925042332774 r=0.5258
-7570.8
0.544925042332774 X - 7570.8
demandainsatisfecha
PROYECCION DE DEMANDA
18000 19000 20000 21000 22000 23000 24000 250000.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
f(x) = 0.54492504233278 x − 7570.80532334391R² = 0.276498030464844
PROYECCION
X DEMANDA24703.26333 5890.62681825336.40273 6235.64032925969.54212 6580.6538426602.68152 6925.66735127235.82091 7270.68086227868.9603 7615.69437328502.0997 7960.707884
29135.23909 8305.72139529768.37848 8650.73490630401.51788 8995.748417
61.2 25.6 14.88384 5358.1824
0.00909612
