小波神经网络一周预测一天.xls

Sheet3 Sheet2 Sheet1 A3 D1 D2 D3 实际 预测 MAX MIN 预测值 实际值 误差 % 总误差 646.74 642.16 637.35 632.39 625.82 617.95 616.07 620.73 628.66 641.92 655.88 670.34 689.43 712.24 727.36 734.27 737.81 734.93 733.40 733.61 729.03 721.26 717.68 718.14 720.16 725.56 728.29 728.06 729.38 730.93 732.63 734.98 737.10 739.09 742.14 746.20 750.82 756.26 757.38 753.69 747.81 738.29 727.97 717.03 702.77 685.75 674.03 668.01 757.38 616.07 2.50 -9.88 8.77 3.36 -4.72 -5.46 8.63 -4.78 3.61 -4.56 5.08 -6.30 4.99 -.24 -.79 -1.76 2.21 -1.16 -1.25 3.60 -6.03 12.32 -10.25 -4.12 5.40 9.65 -11.66 -2.39 4.69 8.50 -9.38 -6.88 7.65 11.53 -12.64 -5.98 10.90 -3.25 -.87 2.26 -.68 -.58 4.32 -16.65 12.98 9.83 -14.14 2.68 12.98 -16.65 .90 1.25 .12 -2.94 -.25 8.40 6.09 -6.68 -10.00 -6.26 -1.96 6.47 9.78 7.13 .81 -11.85 -9.26 9.87 10.09 -5.56 -8.62 -4.34 -.86 6.10 8.44 5.22 1.19 -5.80 -10.16 -11.27 -5.29 10.00 16.34 14.22 3.93 -19.26 -19.73 3.60 9.61 4.47 3.05 -1.10 -1.43 3.53 -2.28 -18.15 -12.15 14.97 16.34 -19.73 5.86 8.47 8.76 7.19 3.15 -3.89 -6.79 -5.27 -3.28 .91 3.01 2.48 2.80 2.88 2.62 2.34 1.24 -.64 -2.24 -3.65 -5.38 -7.24 -6.57 -3.12 2.00 9.57 11.18 6.12 -.91 -12.15 -15.96 -11.11 -5.10 5.16 11.58 13.04 16.01 18.40 15.88 8.58 -3.18 -20.61 -27.87 -23.92 -17.47 -4.43 3.27 4.34 18.40 -27.87 .39 .35 6.84E-03 .31 .29 .23 .22 .12 .26 .36 .35 .45 .72 .65 .83 .79 .91 .87 .85 .90 1.00 .87 .83 .88 1.00 .89 .90 .91 .89 .89 .85 .89 .90 .88 .89 .84 .89 .84 .81 .78 .77 .71 .73 .70 .54 .56 .45 .57 744.58 599.78 670.50 665.95 617.04 659.44 656.83 647.86 647.37 632.68 652.76 667.42 665.25 679.63 718.42 708.07 732.90 727.42 744.14 738.34 736.86 743.45 757.18 738.82 732.92 740.38 757.38 741.87 743.39 744.31 742.48 741.77 735.76 741.46 743.53 740.43 741.48 734.37 741.73 734.83 733.03 757.38 616.07 618.07 726.26 724.23 716.67 719.06 715.08 693.06 694.60 680.34 696.63 757.38 616.07 616.07 .60 .47 .06 .45 .85 .59 .61 .62 .41 .56 .65 .43 .22 .80 .11 .79 .27 .25 .72 .96 .06 .64 .79 .53 .61 .58 .77 .08 .83 .95 .01 .80 .28 .68 .46 .69