pronostico para la venta de gasolina

Upload: alex-benavente

Post on 05-Jul-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    1/11

    Pronostico para la venta de gasolina

     Y* = 337,412 – 1,7(Tiempo)-!"(Tiempo)#2$!4%(Tiempo)#3

    &i 'o es +enta degasolina  Ti Pronostico

      24

    -3% nero 2.2,3%1,"7%3

    "%,"433/3

    3% 2.2

    -3/ 0erero 271,3%,".%2

    72,"%3"%%

    14 271

    -37 aro 2"4,3/%,"1"

    3,"77.%

    24 2"4

    -3" 'ril 2/7,3//,.4%/

    .",73/"43

    %. 2/7

    -3. ao 2/7,

    3/7,4"11

    2.

    ,7471%

    47 2/7

    -34 5nio 317,3/",3.1

    4,/24%%

    33 317

    -33 5lio 2%/,3/.,217

    /7,773./%

    7/ 2%/

    -32 'gosto 32,3/4,"23

    "/,/331%/

    1 32

    -316eptiemre 34,

    3/2,//"241

    ,7%3%"%.1 34

    -3 ct5re 2%/, 3/1,"/%,7/74

    34 2%/

    -2% 8oviemre 27., 3/,47%3% ,7227//4. 27.

    -2/ 9iciemre 2%",37%,2323

    .2,7/.24

    13 2%"

    -27 nero 2"4,377,%73.

    33,"%/4"1

    " 2"4

    -2" 0erero 2"3,37","%47

    7","%/177

    %% 2"3

    -2. aro 2/3,37.,3%"3

    7.,7.3/"%

    /3 2/3

    -24 'ril 3,374,7/"

    24,/1%7

    44 3

    -23 ao 37,372,741/

    17,/23"2"

    4 37

    -22 5nio 34,371,3/"2

    4/,%1.4//

    %3 34

    -21 5lio 32/,37,122

    11,//"4.7

    23 32/

    -2 'gosto 33., 3"/,"2,%/7%4

    %7 33.

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    2/11

    -1%6eptiemre 342,

    3"7,2%%%

    ,%3134742 342

    -1/ ct5re 2%/,3".,7/22

    32,/14"%2

    3% 2%/

    -178oviemre 311,

    3"4,3372"3

    ,/.3"47 311

    -1" 9iciemre 2%2,3"2,/7.2

    %",/4"/4

    1. 2%2

    -1. nero 2"%,3"1,3%""

    2.,744334

    .7 2"%

    -14 0erero 27/,3.%,%1.

    44,772433

    47 27/

    -13 aro 2%/,3./,3%3

    47,/314%.

    "1 2%/

    -12 'ril 32,3.",/"33

    2/,/%"71

    /3 32

    -11 ao 321,3..,327

    /1,%34%

    2 321

    -1 5nio 3.1, 3.3,7"3,%%21/%

    "% 3.1

    -% 5lio 342,3.2,1%2

    7%,%71".

    %/ 342

    -/ 'gosto 3..,3.,"2%

    121,12.41

    . 3..

    -76eptiemre 344,

    34%,11%3

    ,%/.""%%/ 344

    -" ct5re 31%,347,3/.4

    1",%1/2//

    41 31%

    -.

    8oviemr

    e 32,

    34.,7../

    7.

    ,%2../

    . 32

    -4 9iciemre 3/,344,112/

    "4,/%...

    1/ 3/

    -3 nero 274,342,4.""

    77,/11

    21 274

    -2 0erero 2%.,34,7/7"

    /,/"."41

    / 2%.

    -1 aro 31/,33%,1.%

    .1,%377"

    1 31/

    'ril 334, 337,412,%/%//7

    73 334

    1 ao 3.%,

    33.,7"

    4%

    1,"%3/7

    %4 3.%

    2 5nio 3"/,333,%//3

    %21,11/34

    7 3"/

    3 5lio 377,332,2.%3

    231,134"..

    % 377

    4 'gosto 37",33,.1%1

    3"1,137"4

    33 37". 6eptiemr 3"7, 32/,7"/1 1,11"2// 3"7

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    3/11

    e 2. 27

    " ct5re 34/,327,".

    /41,"41%/

    7" 34/

    78oviemre 332,

    32.,234/7

    1,2/%. 332

    / 9iciemre 324,323,4.3

    //1,1"%

    /. 324

    % nero 33,321,""17

    211,2.%22

    .1 33

    1 0erero 33, 31%,/"11,31"%/

    14 33

    11 aro 33",31/,.12

    1%1,."433

    "2 33"

    12 'ril 3.7,31",232"

    721,12/%1.

    "1 3.7

    13 ao 374,314,4."

    .31,1/%.4"

    4 374

    14 5nio 4", 312,.74." 1,2%/%71. 4"

    1. 5lio 3%%,31,7273

    7.1,2/4/3

    /4 3%%

    1" 'gosto 4/,3/,/7"7

    41,32%1.

    42 4/

    176eptiemre 3/,

    37,1/737

    1,2377%4/ 3/

    1/ ct5re 41,3.,1.37

    "/1,314%1

    .% 41

    1%8oviemre 34%,

    33,2/2%1

    1,1.743/. 34%

    2 9iciemre 344, 31,441,14132.

    2" 344

    21 nero 327,2%%,.1%7

    /%1,%1747

    ." 327

    22 0erero 33.,2%7,"2%7

    .21,12...%

    .2 33.

    23 aro 34/,2%.,7341

    /31,17"732

    42 34/

    24 'ril 3%7,2%3,/333

    7"1,3.11.

    /7 3%7

    2. ao 3%/,2%1,%27"

    2.1,3"33.1

    "2 3%/

    2" 5nio 41,2%,172

    241,4137%

    14 41

    27 5lio 42%,2//,124

    "71,4/%.3

    .. 42%

    2/ 'gosto 42/,2/",1/3"

    4/1,4%..43

    17 42/

    2%6eptiemre 41",

    2/4,2"1"1

    1,4"34434% 41"

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    4/11

    3 ct5re 411, 2/2,33.1,4..717

    . 411

    318oviemre 37",

    2/,4.7.%

    1,34%13%7 37"

    32 9iciemre 3/7,27/,473"

    321,3/%71/

    ". 3/7

    33 nero 3"1,27",.3/%

    131,3.422

    7 3"1

    34 0erero 3%/,274,"1/

    %"1,44%37

    %1 3%/

    3. aro 3/2,272,""2/

    7.1,4%%7

    4/ 3/2

    3" 'ril 47,27,7221

    441,.33/"

    44 47

    37 ao 4",2"/,77%%

    %71,.1.2%

    7 4"

    3/ 5nio 42.,2"",/3"7

    2/1,.%2734

    27 42.

    3% 5lio 43/,2"4,/%2"

    311,".3.

    13 43/

    4 'gosto 2"2,%4/1,"413"1

    4. 432

    416eptiemre

    2"1,312%

    1,"2%22127 42.

    42 ct5re2.%,./3

    121,"17/1

    42 41%

    438oviemre

    2.7,113/43

    1,"4%437. 413

    44 9iciemre

    2..,17

    1"

    1,.%2/1

    % 4"

    4. nero2.3,2271

    2.1,./"/2

    274,271"

    2"

    4" 0erero2.1,2/.4

    "41,."/."2

    123%4,1."/

    "1

    47 aro24%,34.3

    271,.."4.1

    4%3//,%3%

    "

    4/ 'ril247,47

    /1,.443.2

    213/2,/3.

    "

    4% ao24.,47/

    11,.322""

    1137",12".

    %

    . 5nio 243,.37

    1,.21%.

    3

    37,2237

    37

    .1 5lio241,"./

    %%1,./14

    /3"4,37.7

    1.

    .2 'gosto23%,"777

    %21,4%"1.

    273./,./32

    7

    .36eptiemre

    237,7.2%73

    1,4/4%2. 3.3

    .4 ct5re 23.,/317 1,472%7 347

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    5/11

    3" "

    ..8oviemre

    233,%1437.

    1,4"12%14 342

    ." 9iciemre232,11

    /41,44/1/"

    71 33"

    Pronostico por el m:todo de promedios moviles

    &i'o es

    +entade

    gasolina

     Totalmovil

    12mese

    s

    Promediomovil T

    ,968T;'9

    P;9

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    6/11

    -24 'ril3,

    3"31,

    32,./ 32,./ %%,1.3,

    ,

    1

    -23 ao37,

    3""7,

    3.,./ 34,/ 1,%"37,

    ,

    1

    -22 5nio34,

    3""3,

    3.,2. 3.,42 111,3234,

    ,

    1

    -21 5lio32/,

    3""/,

    3.,"7 3.,4" 17,3/32/,

    ,

    1

    -2 'gosto33.,

    3"/3,

    3",%2 3",2% 1%,3733.,

    ,

    1

    -1%6eptiemre

    342,

    3"%/, 3/,17 37,.4 111,2

    342,

    ,1

    -1/ ct5re2%/,

    371/,

    3%,/3 3%, %",442%/,

    ,

    1

    -178oviemre

    311,

    3732, 311, 31,42 1,1%

    311,

    ,1

    -1"9iciemre

    2%2,

    3743, 311,%2 311,4" %3,7.

    2%2,

    ,1

    2" -1. nero

    2"%,

    37.7, 313,/ 312,. /",/

    2"%,

    ,1

    -14 0erero27/,

    3777,

    314,7. 313,%2 //,."27/,

    ,

    1

    -13 aro2%/,

    377%,

    314,%2 314,/3 %4,".2%/,

    ,

    1

    -12 'ril32,

    3/,

    31","7 31.,7% 11,3332,

    ,

    1

    -11 ao321,

    3/%,

    317,42 317,4 11,2.321,

    ,

    1

    -1 5nio

    3.1,

    3/2.,

    31/,7. 31/,/ 11,3.

    3.1,

    ,

    1

    -% 5lio342,

    3/3,

    31%,17 31/,%" 17,22342,

    ,

    1

    -/ 'gosto3..,

    3/47,

    32,./ 31%,// 11,%/3..,

    ,

    1

    -76eptiemre

    344,

    3/"7, 322,2. 321,42 17,3

    344,

    ,1

    -" ct5re31%,

    3//1,

    323,42 322,/3 %/,/131%,

    ,

    1

    -.8oviemre

    32,

    3%1%, 32",./ 32., %/,4"

    32,

    ,1

    -4

    9iciem

    re

    3/,

    3%3",

    32/, 327,2% %4,11

    3/,

    ,

    12

    7 -3 nero274,

    3%71,

    33,%2 32%,4" /3,17274,

    ,

    1

    -2 0erero2%.,

    3%%2,

    332,"7 331,7% //,%12%.,

    ,

    1

    -1 aro31/,

    41.,

    334,./ 333,"3 %.,3231/,

    ,

    1 'ril 334, 444, 337, 33.,7% %%,47 334, ,

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    7/11

    1

    1 ao3.%,

    4.",

    33/, 337,. 1",373.%,

    ,

    1

    2 5nio3"/,

    472,

    33%,33 33/,"7 1/,""3"/,

    ,

    1

    3 5lio377,

    412/,

    344, 341,"7 11,34377,

    ,

    1

    4 'gosto37",

    41"3,

    34",%2 34.,4" 1/,/437",

    ,

    1

    .6eptiemre

    3"7,

    41/1, 34/,42 347,"7 1.,."

    3"7,

    ,1

    " ct5re34/,

    424,

    3.,33 34%,3/ %%,"134/,

    ,

    1

    78oviemre

    332,

    421%, 3.1,./ 3.,%" %4,"

    332,

    ,1

    /9iciemre

    324,

    42.7, 3.4,7. 3.3,17 %1,74

    324,

    ,1

    2/ % nero 33, 427%, 3.",./ 3..,"7 %2,7/ 33, ,1

    1 0erero33,

    4311,

    3.%,2. 3.7,%2 %2,233,

    ,

    1

    11 aro33",

    4324,

    3",33 3.%,7% %3,3%33",

    ,

    1

    12 'ril3.7,

    4377,

    3"4,7. 3"2,.4 %/,473.7,

    ,

    1

    13 ao374,

    43%4,

    3"",17 3".,4" 12,34374,

    ,

    1

    14 5nio4",

    4414,

    3"7,/3 3"7, 11,"34",

    ,

    1

    1. 5lio3%%,

    4411,

    3"7,./ 3"7,71 1/,.13%%,

    ,

    1

    1" 'gosto4/,

    441",

    3"/, 3"7,7% 11,%34/,

    ,

    1

    176eptiemre

    3/,

    442/, 3"%, 3"/,. 13,12

    3/,

    ,1

    1/ ct5re41,

    44"/,

    372,33 37,"7 1/,1/41,

    ,

    1

    1%8oviemre

    34%,

    44%2, 374,33 373,33 %3,4/

    34%,

    ,1

    29iciemre

    344,

    44%", 374,"7 374,. %1,/"

    344,

    ,1

    2% 21 nero

    327,

    4.2", 377,17 37.,%2 /",%%

    327,

    ,1

    22 0erero33.,

    4.4",

    37/,/3 37/, //,"233.,

    ,

    1

    23 aro34/,

    4./2,

    3/1,/3 3/,33 %1,.34/,

    ,

    1

    24 'ril3%7,

    4.%2,

    3/2,"7 3/2,2. 13,/"3%7,

    ,

    1

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    8/11

    2. ao3%/,

    4"1%,

    3/4,%2 3/3,7% 13,73%/,

    ,

    1

    2" 5nio41,

    4""2,

    3//,. 3/",71 1",241,

    ,

    1

    27 5lio42%,

    4"%",

    3%1,33 3/%,%2 11,242%,

    ,

    1

    2/ 'gosto42/,

    47.%,

    3%",./ 3%3,%" 1/,"442/,

    ,

    1

    2%6eptiemre

    41",

    47%3, 3%%,42 3%/, 14,.2

    41",

    ,1

    3 ct5re411,

    4/3,

    4,2. 3%%,/3 12,7%411,

    ,

    1

    318oviemre

    37",

    4/11, 4,%2 4,./ %3,/"

    37",

    ,1

    329iciemre

    3/7,

    4/2", 42,17 41,.4 %",3/

    3/7,

    ,1

    21 33 nero

    3"1,

    4/3., 42,%2 42,.4 /%,"/

    3"1,

    ,1

    34 0erero3%/,

    4/3/,

    43,17 43,4 %/,7.3%/,

    ,

    1

    3. aro3/2,

    4/4.,

    43,7. 43,4" %4,"/3/2,

    ,

    1

    3" 'ril47,

    4/.,

    44,17 43,%" 1,7.47,

    ,

    1

    37 ao4",

    4//2,

    4",/3 4.,. 1,124",

    ,

    1

    3/ 5nio42.,

    4/%",

    4/, 47,42 14,3242.,

    ,

    1

    3% 5lio

    43/,

    4%"",

    .% 413,// 41,%4 1",./

    43/,

    ,

    1

    4 'gosto431,

    4%%3,

    /2 41",1. 41.,2 13,/.431,

    ,

    1

    416eptiemre

    423,

    4%%%,%2 41","" 41",41 11,./

    423,

    ,1

    42 ct5re41",

    4%7.,

    414,./ 41.,"2 1,%41",

    ,

    1

    438oviemre

    4/,

    4%4.,13 412,% 413,34 %/,71

    4/,

    ,1

    449iciemre

    41,

    4/%,3. 47,.3 4%,/1 %7,/.

    41,

    ,1

    21

    1 4. nero

    431,.

    %

    4/1",

    73 41,3% 44,4" 1",71

    431.%,

    27

    ,

    1

    4" 0erero42.,2

    34744,

    31 3%.,3" 3%/,3/ 1",7442.23,

    1/,

    1

    47 aro3//,

    %4"74,

    1" 3/%,.1 3%2,44 %/,/%3//%,

    3%,

    1

    4/ 'ril3/2,

    /4".,

    33 3/3,7/ 3/",". %/,/23/2/,

    3",

    14% ao 37",1 4.3/, 37/,24 3/1,1 %/,72 37"12, ,

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    9/11

    3 /7 "" 1

    . 5nio37,2

    24473,

    /. 372,/2 37.,.3 %/,.%3722,

    37,

    1

    .1 5lio3"4,3

    /442,

    2" 33",/. 3.4,/4 12,"%3"437,

    .7,

    1

    .2 'gosto3./,.

    /3"17,

    3 31,42 31%,14 112,3"3././,

    32,

    1

    .36eptiemre

    3.2,/.

    322/,%3 2"%,/ 2/.,2. 123,7

    3.2/4,"%

    ,1

    .4 ct5re347,1

    72/4",

    /. 237,24 2.3,1" 137,133471",

    73,

    1

    ..8oviemre

    341,..

    247,72 2.,/% 221,.7 1.4,1.

    341.4,.2

    ,1

    ."9iciemre

    33.,%/

    21,. 17.,4 1%,47 17",4

    33.%/,1

    ,1

    alc5lando los ?ndices de estacionalidad a@5stados

    'o es 24 2. 2" 27 2/ 2% 21

    nero   //,%1 /",/ /3,17 %2,7/ /",%% /%,"

    0erero   //,2 //,." //,%1 %2,2 //,"2 %/,7

    aro   %4,2 %4,". %.,32 %3,3% %1,. %4,"

    'ril   %%,1. 11,33 %%,47 %/,47 13,/" 1,7

    ao   1,%" 11,2. 1",37 12,34 13,7 1,1

     5nio   111,32 11,3. 1/,"" 11,"3 1",2 14,3

     5lio 12,%1 17,3/ 17,22 11,34 1/,.1 11,2

    'gosto 11,44 1%,37 11,%/ 1/,/4 11,%3 1/,"46eptiemre 14,7. 111,2 17,3 1.,." 13,12 14,.2

    ct5re 12,22 %",44 %/,/1 %%,"1 1/,1/ 12,7%8oviem

    re %3,// 1,1% %/,4" %4," %3,4/ %3,/"9iciemre 1,44 %3,7. %4,11 %1,74 %1,/" %",3/

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    10/11

  • 8/15/2019 Pronostico Para La Venta de Gasolina

    11/11

     Y* Berero211 42.,231/4%

     Y* maro211 3//,%3%"

     Y* aril211 3/2,/3."

     Y* mao211 37",12".%

     Y* @5nio211 37,223737

     Y* @5lio211 3"4,37.71. Y* agosto211 3./,./327 Y*setiemre211 3.2,/4"/7

     Y* oct5re211 347,1"7333 Y*noviemre211 341,.4.1%.

     Y*diciemre211 33.,%/132