20140760数学1402魏婷上机

《20140760数学1402魏婷上机》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、预测与决策基础实验EXECEL在预测中的应用一【实验目的】了解简单移动平均、加权移动平均、指数平滑的实际应用【实验内容】根据已知数据按要求给出各种预测及比较【实验要求】在EXCEL中给出相应的计算函数或应用对应的数据分析宏完成符合题目要求的计算和比较结果。在规定题目完成后有能力的同学可以验证例题或自己搜集数据进行类似的预测。3-5：一痰3・5(P$O誠服酗解駐诡齡觀册肮酬脚紡)■彌就竝JtTtH(TtiHt)*2ItW(TuHt)*2Ttlul(TuHt)*21651267’66>363’6566F96

2、5111]469’66651H6.SK16568他566M6.6666666766.M1777777778"66.4"jj663r65.568.530.25’価购666766.6666(667!!««««'W66.41L56)764他565.52256566.6666(667111111111165.466410870’6763.542.2565•蹶66667K2566.865.42L1611973‘7L56736M65.6666(667517777777867.6価83S.44121069r7171.

3、56.25r,0.66666667M067.8616L%131175727116农70.6666(匍18.777皿‘70.267.85L8414127271572F0727133030.1111111111U70.212415137373.50.2573.66666667?2472.67184.8416H7畑73r07373.6666(66772.6TU0.1617篩162.25141.M4444137.2』8利11520312.8585858615.244444441A193-6躬骷6：P58）孵生每

4、月肝眠福版般吓痂；讷alf汛3,0.6』.9三个稀系螂般怖个月披出錮1（瞬彳船柳酬聘干前三个朋斯就金藏砌i）20.30.60.93競支出鉢mwmm商臆41655267654654654636365.66.7666.210.2466.814.447469618217.472464.2822278463.3831.5844856866.0743.70947667.1120.78854468.4380.191844966366.651813.3356467.644821.5741768.043825.4399

5、21076465.55626242194564.857920.73602763.504380.2456391187065.0893824.1141764.3431?31.9997563.95044』59721297366.5625741.4405467.7372727.6963669.39504199571113106968.49380.25624170.894913.59067272639513.2459914117568.6456640.3776669.7579627.4789569.363953L

6、7650515127270.551962.09681872.903190.81574374.43645.93602116137470.986379.08195172.361272.68512372.243643.08480217147371.89046L23107773.344510.11868773.824360.6795763-7:CUVurvn1练习题3・7(P58)某公司投资額预测。已知某公司2004^的月投资额如下表所示，(1)试用一次.二次移动平均法预测下一年度一月份的投资額。2一次移动平均

7、34n=2n=356月份1投资额平均值28452预测值残差平方平均值预测值残差平方7228635r28543.58328279r2845728543.569960.25勺8455.3333319一104530475'2937733210"31842.52845729377407232414691889々9129.6666728455.33

8、勺0654.6666729129.6714079053)1664912011632053r32631.531842.544310.25§1912.6666730654

9、.67195533612137832503r3227835340r33921.532631.53227816512.259375844§2588.6666731912.67*33298.6666732588.67348493.4756983514938726r3703333921.523083220.253552333298.6729455947151040736r39731370331371220938267.33333355232717