函数法预测销售额
函数法预测销售额GROWTH函数 LINEST函数月份 销售额 月份 销售额 A值1 991,000.00 1 991,000.00 900,277.132 958,500.00 2 958,500.003 912,035.00 3 912,035.004 899,663.00 4 899,663.005 1,006,107.00 5 1,006,107.006 1,126,101.00 6 1,126,101.007 1,095,884.00 7 1,095,884.008 1,025,655.00 8 1,025,655.009 1,175,793.00 9 1,175,793.0010 1,114,182.00 10 1,114,182.0011 1,164,317.67 11 1,160,706.8712 1,191,272.68 12 1,184,382.30B值23,675.43函数法预测销售额LINEST函数