财务预测分析表

A产品成本预测分析

销

RESIDUAL OUTPUT

观测值

1

2

3

4

5

6

7

8

9

10

11

12

SUMMARY OUTPUT

回归统计

Multiple R0.996935

R Square0.993879

Adjusted R 0.993267

标准误差12426.05

观测值12

方差分析

df SS MS F Significance F

回归分析1 2.51E+11 2.51E+111623.63 2.12E-12

残差10 1.54E+09 1.54E+08

总计11 2.52E+11

Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限 95.0%上限 95.0% Intercept-3180.7112085.85-0.263180.797758-30109.723748.24-30109.723748.24销售量75.98698 1.885840.294292.12E-1271.7851580.188871.7851580.1888 RESIDUAL OUTPUT

观测值预测 销售成本残差

1340508.4-3997.2

2241877.310962.7

3396586.83249.214

4347271.2-11517.6

5470598.1-6714.1

6428273.4-14915

7374550.611199.04

8395599-9346.16

9665048.817365.62

10487391.218759.17

11651903-10500.6

12742783.5-4545.06

.0%