8/17/2019 PRONOSTICOS SED (1).xlsx
1/18
ACTIVIDAD PRONOSTICOS SED
GLADYS CECILIA GONZÁLEZ GONZÁLEZ
ASESOR: MANUEL ALBERTO RICO PINTO
FUNDACIÓN UNIVERSITARIA PANAMERICAFACULTAD DE CIENCIAS EMPRESARIALE
ADMINISTRACIÓN DE EMPRESASBOGOTÁ, COLOMBIA2016
8/17/2019 PRONOSTICOS SED (1).xlsx
2/18
8/17/2019 PRONOSTICOS SED (1).xlsx
3/18
8/17/2019 PRONOSTICOS SED (1).xlsx
4/18
8/17/2019 PRONOSTICOS SED (1).xlsx
5/18
16 2010 1820.75 103.8217 2030 1984.37 145.6818 2135 2060.02 96.6619 2525 2141.50 86.0420 2345 2435.76 231.7921 2450 2441.77 73.74
22 2555 2469.65 41.6423 2660 2541.89 63.0624 2815 2643.48 90.0325 2870 2790.56 129.9626 2975 2885.15 105.2127 3250 2979.61 97.6828 3185 3198.19 182.3129 3290 3243.65 86.5230 3395 3302.05 66.8431 3500 3387.17 79.63
32 3650
3490.04 95.9033 3710 3630.78 127.2934 3875 3724.42 103.7335 4015 3860.95 126.6936 4025 4006.79 140.1037 4230 4061.57 80.3738 4235 4203.58 123.5239 4360 4262.63 78.3940 4620 4354.31 87.6941 4550 4566.60 174.9142 4655 4607.45 81.0743 4760 4665.06 64.6444 4865 4750.91 79.4945 5025 4854.62 96.4446 5075 5002.82 132.6747 5180 5093.15 103.0348 5225 5184.85 95.1049 5390 5241.49 68.1750 5520 5365.90 107.5451 5825 5506.03 130.3652 5705 5768.42 222.78
53 5810 5790.86 82.5454 5915 5829.02 51.4855 6020 5904.65 68.3856 6125 6005.91 91.4057 6850 6116.69 104.9758 6335 6661.50 412.8559 6785 6556.81 50.57
60 6925 6731.71 137.61
8/17/2019 PRONOSTICOS SED (1).xlsx
6/18
8/17/2019 PRONOSTICOS SED (1).xlsx
7/18
Y=aX+b
8/17/2019 PRONOSTICOS SED (1).xlsx
8/18
3348900
107.46 211.72107.46 211.72
Beta 0.7
Ft E SED !St " aD t#1$ %1# a& %St#1 $ Gt#1&
319.19 5.81 !Gt " b%St # St#1& $ %1# b& Gt#1
433.57 48.57 '()n*st+,)- Ft t$t " S t $ t Gt486.08 73.92660.56 4.44788.58 18.58891.38 16.38
987.69 7.691086.32 1.321188.76 68.761210.30 84.701380.76 19.241514.83 9.831623.73 13.731723.17 8.171822.50 2.50
8/17/2019 PRONOSTICOS SED (1).xlsx
9/18
1924.57 85.432130.05 100.052156.67 21.672227.54 297.462667.55 322.552515.51 65.51
2511.29 43.712604.95 55.052733.52 81.482920.52 50.522990.36 15.363077.29 172.713380.50 195.503330.16 40.163368.88 26.123466.80 33.20
3585.94 64.063758.07 48.073828.16 46.843987.64 27.364146.89 121.894141.94 88.064327.10 92.104341.02 18.984442.00 178.004741.51 191.514688.52 33.524729.70 30.304830.40 34.604951.06 73.945135.49 60.495196.18 16.185279.96 54.965309.66 80.345473.44 46.565636.39 188.615991.19 286.19
5873.40 63.405880.50 34.505973.03 46.976097.31 27.696221.66 628.347074.35 739.356607.38 177.62
6869.32 55.68
8/17/2019 PRONOSTICOS SED (1).xlsx
10/18
MAD 92.44
8/17/2019 PRONOSTICOS SED (1).xlsx
11/18
8/17/2019 PRONOSTICOS SED (1).xlsx
12/18
8/17/2019 PRONOSTICOS SED (1).xlsx
13/18
8/17/2019 PRONOSTICOS SED (1).xlsx
14/18
8/17/2019 PRONOSTICOS SED (1).xlsx
15/18
8/17/2019 PRONOSTICOS SED (1).xlsx
16/18
8/17/2019 PRONOSTICOS SED (1).xlsx
17/18
8/17/2019 PRONOSTICOS SED (1).xlsx
18/18