（专业财务模板）指数平滑法预测产品销量.xlsx

《（专业财务模板）指数平滑法预测产品销量.xlsx》由会员分享，可在线阅读，更多相关《（专业财务模板）指数平滑法预测产品销量.xlsx（2页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、产产品品销销量量预预测测月月份份产产品品销销量量指指数数平平滑滑预预测测标标准准误误差差131730.00233370.0031730.00330340.1533370.00435020.0030340.15535220.0035020.003355.124789632920.0035220.003220.817031731809.7532920.003012.805781834000.0031809.751479.037419937010.0034000.001942.4941121039920.0037010.002242.7624431147010.0039920.002727.9659

2、741243320.0047010.004753.8160111347066.5043320.004910.9503491446792.6547066.505096.4190781539017.5046792.653040.1401321642850.0039017.504985.4526241748000.0042850.005007.1950761849082.5548000.005821.326131指指数数平平滑滑1 2 3 4 5 6 7 8 9 10111213141516170.00 10000.00 20000.00 30000.00 40000.00 50000.00 600

3、00.00 数数据据点点值值实际值预测值产产品品销销量量预预测测1234567891011121314151617180.00 10000.00 20000.00 30000.00 40000.00 50000.00 60000.00 0.027xy=29886e0.027x产品销量Expon.(产品销量)指指数数平平滑滑1 2 3 4 5 6 7 8 9 10111213141516170.00 10000.00 20000.00 30000.00 40000.00 50000.00 60000.00 数数据据点点值值实际值预测值产产品品销销量量预预测测1234567891011121314151617180.00 10000.00 20000.00 30000.00 40000.00 50000.00 60000.00 0.027xy=29886e0.027x产品销量Expon.(产品销量)