《（专业财务模板）销售量与利润总额回归分析.xlsx》由会员分享，可在线阅读，更多相关《（专业财务模板）销售量与利润总额回归分析.xlsx（2页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、销量与利润总额统计表月月份份销销售售量量（万万件件）利利润润总总额额（万万元元）1191413.5822144203254433428443553134656334534SUMMARY OUTPUT回归统计Multiple R0.847572272R Square0.718378757Adjusted R Square 0.624505009标准误差28.1163583观测值5方差分析dfSSMSF Significance F回归分析16049.611188 6049.611 7.652605 0.069782残差32371.588812 790.5296总计48421.2Coefficie
2、nts标准误差t StatP-value Lower 95%Intercept228.671659683.63346088 2.734213 0.071686-37.48731910.8174708380.295506887 2.766334 0.069782-0.12296RESIDUAL OUTPUTPROBABILITY OUTPUT观测值预测 413.58残差标准残差百分比排位1403.610418916.38958112 0.673098102436.3092524-3.309252386-0.13591303460.8333775-25.83337752-1.06094504484
3、.5400318-19.54003181-0.80248705501.706919432.29308059 1.32623390191 Line Fit Plot4003503002502001501005000100200300400500600191413.58利润总额预测利润总额Upper 95%下限 95.0%上限 95.0%494.8307-37.4873 494.83071.757906-0.12296 1.757906413.58420433435465534Normal Probability Plot10090807060504030201000100200300400500600Sample Percentile413.58Significance FPROBABILITY OUTPUT191 Line Fit Plot4003503002502001501005000100200300400500600191413.58利润总额预测利润总额