误差测量例题赛证链接需求预测数据 2

型号,日期,用量,简单移动平均法,(At-Ft)^2,加权移动平均法,(At-Ft)^2,一次指数平滑法（a=0.4）,(At-Ft)^2

前大灯,2023/6/1,18034,,,,,,

,2023/6/2,12885,,,,,,

,2023/6/3,12885,,,,,,

,2023/6/4,14982,,,,,,

,2023/6/5,14982,,,,,,

,2023/6/6,14293,,,,,,

,2023/6/7,14642,,,,,,

,2023/6/8,17314,,,,,,

,2023/6/9,12536,,,,,,

,2023/6/10,13531,,,,,,

,2023/6/11,19778,,,,,,

,2023/6/12,18175,,,,,,

,2023/6/13,14535,,,,,,

,2023/6/14,14356,,,,,40000,

,2023/6/15,18413,15747,7107556,45157,715241536,31366,167780209

,2023/6/16,10446,15904,29789764,49243,1505207209,22998,157552704

,2023/6/17,19326,15605,13845841,41260,481100356,21530,4857616

,2023/6/18,13695,16433,7496644,48642,1221292809,18396,22099401

,2023/6/19,12004,15564,12673600,45092,1094815744,15840,14714896

,2023/6/20,14190,14683,243049,41364,738426276,15180,980100

,2023/6/21,12042,14633,6713281,40137,789329025,13925,3545689

,2023/6/22,15496,14303,1423249,38255,517972081,14554,887364

,2023/6/23,15963,13886,4313929,42381,697910724,15118,714025

,2023/6/24,12390,14674,5216656,45462,1093757184,14027,2679769

,2023/6/25,10734,13683,8696601,42296,996159844,12710,3904576

,2023/6/26,10428,13260,8020224,36473,678342025,11798,1876900

,2023/6/27,19807,13035,45859984,32571,162919696,15002,23088025

,2023/6/28,10985,13838,8139609,45506,1191699441,13396,5812921

,2023/6/29,11005,13687,7193124,41499,929884036,12440,2059225

,2023/6/30,12354,13045,477481,37396,627101764,12406,2704

,2023/7/1,,12529,156975841,35029,1227030841,7444,55413136

,MSE,,,1