12. REDES NEURONALES.xlsx

135
METOD CAUDAL M AÑO ENE FEB MAR ABR 1988 10.5 13.9 16.0 15.9 1989 16.8 30.5 35. !".6 1990 !!.8 1. 11.1 .! 1991 1.5 !0.9 16.3 16.3 199! 1"." 18. !.0 15.6 1993 9.5 6.9 .3 ".3 199" 8.3 .8 1.0 8.0 1995 ".5 3.3 .3 3.! 1996 5.6 15.0 1".6 10.1 199 1.1 36.! !5.9 !1." 1998 6. .8 15.! 9.6 1999 8.9 15." 1!. 11.5 !000 8.8 1.8 1!.1 ".5 !001 1!.6 16.5 1".5 11.1 !00! 6." !0." 18.9 1".6 !003 1".1 !5.3 !.! 15.1 !00" !0.8 !0.! !8.3 13.0 !005 5.! 1".0 1.9 11.3 !006 10.6 1.6 !".6 15. !00 6.0 1!." !1." 11.5

Transcript of 12. REDES NEURONALES.xlsx

REDES NEURONALESMETODO DE REDES NEURONALES

CAUDAL MEDIO MENSUAL HISTORICA(m3/s)

AOENEFEBMARABRMAYJUNJULAGOSETOCTNOVDICPROM198810.513.916.015.98.06.86.15.65.55.14.87.18.767198916.830.535.724.615.49.37.26.16.45.85.66.914.183199022.817.711.17.25.94.54.44.33.83.74.27.18.053FORMULAS:199117.520.916.316.37.35.95.44.53.53.83.65.49.202199214.418.727.015.67.66.85.65.45.15.65.94.510.19319939.56.97.34.33.83.93.63.83.64.68.88.35.680DONDE:19948.37.817.08.06.14.34.64.75.04.34.13.86.498g() es la funcin de transferencia 19954.53.37.33.22.42.52.42.42.32.32.32.23.097Xm,i es la entrada a la neurona m proveniente de la neurona i 19965.615.014.610.16.54.03.93.83.44.29.016.08.002H el nmero de neuronas en la capa oculta199717.136.225.921.49.87.05.95.45.44.64.44.312.273yout,m corresponde a la salida de la neurona m 19986.77.815.29.64.24.14.24.23.63.44.04.15.932wi,j el peso de la conexin entre la neurona i de la capa j 19998.915.412.711.54.53.94.04.04.03.83.74.66.75420008.817.812.14.53.53.53.53.73.53.84.96.86.368200112.616.514.511.14.14.04.04.34.24.14.45.07.40420026.420.418.914.67.24.44.54.64.75.04.76.18.4522.718-20.910200314.125.327.215.17.55.14.95.04.95.84.96.010.484200420.820.228.313.06.15.14.84.74.85.05.27.310.4361.0002.00020055.214.017.911.35.84.94.84.74.74.86.610.37.913200610.617.624.615.77.05.34.95.05.04.74.56.79.28320076.012.421.411.54.03.53.44.33.94.25.49.37.442

Jan-88Feb-88Mar-88Apr-88May-88Jun-88Jul-88Aug-88Set-88Oct-88Nov-88Dec-88Jan-89Feb-89Mar-89Apr-89May-89Jun-89Jul-89Aug-89Sep-89Oct-89Nov-89Dec-89Jan-90Feb-90Mar-90Apr-90May-90Jun-90Jul-90Aug-90Sep-90Oct-90Nov-90Dec-90Jan-91Feb-91Mar-91Apr-91May-91Jun-91Jul-91Aug-91Sep-91Oct-91Nov-91Dec-91Jan-92Feb-92Mar-92Apr-92May-92Jun-92Jul-92Aug-92Sep-92Oct-92Nov-92Dec-92Jan-93Feb-93Mar-93Apr-93May-93Jun-93Jul-93Aug-93Sep-93Oct-93Nov-93Dec-93Jan-94Feb-94Mar-94Apr-94May-94Jun-94Jul-94Aug-94Sep-94Oct-94Nov-94Dec-94Jan-95Feb-95Mar-95Apr-95May-95Jun-95Jul-95Aug-95Sep-95Oct-95Nov-95Dec-95Jan-96Feb-96Mar-96Apr-96May-96Jun-96Jul-96Aug-96Sep-96Oct-96Nov-96Dec-96Jan-97Feb-97Mar-97Apr-97May-97Jun-97Jul-97Aug-97Sep-97Oct-97Nov-97Dec-97Jan-98Feb-98Mar-98Apr-98May-98Jun-98Jul-98Aug-98Sep-98Oct-98Nov-98Dec-98Jan-99Feb-99Mar-99Apr-99May-99Jun-99Jul-99Aug-99Sep-99Oct-99Nov-99Dec-99Jan-00Feb-00Mar-00Apr-00May-00Jun-00Jul-00Aug-00Sep-00Oct-00Nov-00Dec-00Jan-01Feb-01Mar-01Apr-01May-01Jun-01Jul-01Aug-01Sep-01Oct-01Nov-01Dec-01Jan-02Feb-02Mar-02Apr-02May-02Jun-02Jul-02Aug-02Sep-02Oct-02Nov-02Dec-02Jan-03Feb-03Mar-03Apr-03May-03Jun-03Jul-03Aug-03Sep-03Oct-03Nov-03Dec-03Jan-04Feb-04Mar-04Apr-04May-04Jun-04Jul-04Aug-04Sep-04Oct-04Nov-04Dec-04Jan-05Feb-05Mar-05Apr-05May-05Jun-05Jul-05Aug-05Sep-05Oct-05Nov-05Dec-05Jan-06Feb-06Mar-06Apr-06May-06Jun-06Jul-06Aug-06Sep-06Oct-06Nov-06Dec-06Jan-07Feb-07Mar-07Apr-07May-07Jun-07Jul-07Aug-07Sep-07Oct-07Nov-07Dec-07Jan-08Feb-08Mar-08Apr-08May-08Jun-08Jul-08Aug-08Sep-08Oct-08Nov-08Dec-08AOENEFEBMARABRMAYJUNJULAGOSETOCTNOVDICPROM16.75030.49535.73324.58415.3769.2947.1586.1186.4175.7925.5646.91422.84717.70011.0507.2075.9054.5184.4164.2763.8233.6584.1517.09217.50020.92016.32516.2687.2985.9245.3824.5453.5143.7943.5675.39314.38218.74326.98915.6127.5866.7545.6195.3995.1335.6095.9474.5439.5246.8617.3054.2673.7933.8573.5763.7733.6194.5578.7578.2708.2717.79717.0217.9996.1424.2894.6204.6924.9764.2894.0743.8084.4793.3297.3023.2042.3712.5122.4462.3572.3242.2952.3042.2495.63414.98214.57810.1476.5073.9763.8523.7903.4284.1968.98215.95817.12936.17725.89021.4439.7726.9625.8885.3795.3864.5824.4084.2576.7057.75215.2429.5794.2434.1364.1694.2383.5713.4324.0074.1128.86515.36412.74511.5344.5323.8753.9834.0354.0453.8003.6674.6058.84717.78212.0874.5083.4903.5053.4703.6993.5233.8054.8596.84712.61516.50014.54411.1164.0634.0084.0064.2824.1724.1224.3815.0456.42020.36718.86114.5777.1914.4384.4834.5674.7495.0124.6596.10714.06525.34327.19315.0577.4525.1394.8895.0334.9445.8074.9005.98520.79720.19028.29213.0196.0735.0534.8224.7474.7815.0335.1797.2515.17613.97317.90511.2585.8064.8664.8114.7414.7154.8336.61810.25410.56117.60324.57915.6786.9965.3024.9064.9964.9514.6684.4926.6715.96212.37521.40011.5003.9633.5153.3924.3463.9364.1955.4189.300ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!0.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.00019889.00010.0004.0002.0001.0001.1001.1001.1001.1001.1001.1002.0002.8839.00010.0004.0002.0001.0001.1001.1001.1001.1001.1001.1002.0004.0007.00010.0003.0001.0001.1001.1001.1001.1001.0004.0002.0007.0003.0004.0001.0001.0001.1001.1001.1001.0990.9993.9986.0004.0001.0008.0003.0001.0001.1001.1001.1001.0981.0993.9942.0002.0002.0001.0001.0001.0001.1001.1001.1001.1001.1009.0002.0009.0009.0005.0002.9990.9991.0991.0981.0991.0981.1009.0009.00010.0009.0008.0005.0001.0001.1001.1001.1001.1001.1008.9952.9972.9994.9879.0002.9900.9831.0861.0841.0801.0791.0788.8226.8465.0007.00010.0005.0001.0001.0991.0991.0991.0981.1009.0003.0009.00010.0003.0001.0001.0001.1001.1001.1001.1001.1008.9972.9998.0009.0005.0002.0001.0001.0991.0991.1001.0981.0988.9944.99710.00012.0006.0004.0001.0001.0991.0991.0991.0991.0998.9885.99911.00014.00013.0003.9990.9981.0981.0981.0991.0981.0998.9993.0008.0005.00013.0004.0000.9991.0991.0991.1001.0991.0998.9975.0002.00010.00010.0006.0001.0001.1001.1001.1001.1001.1008.9983.0008.0005.0009.0001.0001.0001.1001.1001.1001.1001.1008.9996.0002.00010.0008.0001.0001.0001.1001.1001.1001.1001.1008.9997.0003.0009.0005.0001.0001.0001.1001.1001.1001.1001.1009.0006.0006.0007.0008.0001.0001.0001.1001.1001.1001.1001.1008.9984.0004.0004.00013.0002.0000.9991.0981.0981.1001.0991.0999.0002.000ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!19894.0007.00010.0003.0001.0001.1001.1001.1001.1001.0004.0002.0003.03319907.0003.0004.0001.0001.0001.1001.1001.1001.0990.9993.9986.0002.61619914.0001.0008.0003.0001.0001.1001.1001.1001.0981.0993.9942.0002.37419922.0002.0001.0001.0001.0001.1001.1001.1001.1001.1009.0002.0001.95819939.0009.0005.0002.9990.9991.0991.0981.0991.0981.1009.0009.0004.208199410.0009.0008.0005.0001.0001.1001.1001.1001.1001.1008.9952.9974.20819952.9994.9879.0002.9900.9831.0861.0841.0801.0791.0788.8226.8463.50319965.0007.00010.0005.0001.0001.0991.0991.0991.0981.1009.0003.0003.79119979.00010.0003.0001.0001.0001.1001.1001.1001.1001.1008.9972.9993.45819988.0009.0005.0002.0001.0001.0991.0991.1001.0981.0988.9944.9973.707199910.00012.0006.0004.0001.0001.0991.0991.0991.0991.0998.9885.9994.457200011.00014.00013.0003.9990.9981.0981.0981.0991.0981.0998.9993.0005.04120018.0005.00013.0004.0000.9991.0991.0991.1001.0991.0998.9975.0004.20820022.00010.00010.0006.0001.0001.1001.1001.1001.1001.1008.9983.0003.87520038.0005.0009.0001.0001.0001.1001.1001.1001.1001.1008.9996.0003.70820042.00010.0008.0001.0001.0001.1001.1001.1001.1001.1008.9997.0003.62520053.0009.0005.0001.0001.0001.1001.1001.1001.1001.1009.0006.0003.29220066.0007.0008.0001.0001.0001.1001.1001.1001.1001.1008.9984.0003.45820074.0004.00013.0002.0000.9991.0981.0981.1001.0991.0999.0002.0003.374

CALCULADOS POR REDES NEURALESESTACION PIASCOCHA