月份产品A（X1）产品B（X2）成本Y146.32415436SUMMARYOUTPUT255.34516430352.381026512回归统计457.15817465MultipleR0.9641728567555.47816983RSquare0.9296292975654.64817427AdjustedRSquare0.9139913636763.72919632标准误差2541.8653495767870.071223074观测值12999.62163365310103.331734616方差分析11115.352035141dfSSMSFSignificanceF12120.452238427回归分析2768184441.5682583384092220.7841291459.44706661430.0000065052残差958149715.098408416461079.455378712总计11826334156.6666667X1、X2与Y的复相关系数0.964173产品A单位变动成本22.4842086339Coefficients标准误差tStatP-valueLower95%Upper95%下限95.0%上限95.0%产品B单位变动成本1326.4502588879Intercept7526.84408077473081.05336087432.44294505780.0371845688557.017165758114496.6709957912557.017165758114496.6709957912固定成本7526.8440807747XVariable122.4842086339114.70326788290.19602064570.8489484951-236.9926098733281.961027141-236.9926098733281.961027141二元回归方程Y=22.4842X1+1326.4502*X2+7526.85XVariable21326.4502588879531.28346038762.4966902940.0340462154124.60357595292528.296941823124.60357595292528.296941823月份业务量X1业务量X2业务量X3业务量X4业务量X5成本费用YSUMMARYOUTPUT146.3241.505.112423.00255.3451.554.512580.00回归统计352.38102.002.222600.00MultipleR0.9982736831457.1581.684.112650.00RSquare0.9965503463555.4781.703.612610.00AdjustedRSquare0.9936756348654.6481.68322650.00标准误差60.4121447497763.7291.782.822800.00观测值12870.07121.902.723000.00999.62162.502.6534000.00方差分析10103.33172.552.634100.00dfSSMSFSignificanceF11115.35202.601.534050.00回归分析56325917.1532671321265183.4306534263346.66100119070.000000268412120.45222.901.244500.00残差621897.76339953463649.6272332558总计116347814.916666667Coefficients标准误差tStatP-valueLower95%Upper95%下限95.0%上限95.0%Intercept5.169523745273.53584708110.01889888950.9855345559-664.1485809019674.4876283918-664.1485809019674.4876283918X1、X2、X3、X4、X5与Y的复相关系数0.9982736831XVariable114.80118774994.6723584343.16781941260.01937217153.36833854726.23403695293.36833854726.2340369529X1的单位变动成本14.8011877499XVariable221.833648775535.10926530210.62187711950.5568988121-64.0756284118107.7429259627-64.0756284118107.7429259627X2的单位变动成本21.8336487755XVariable3419.0759021934259.41056556161.6154928050.1573312646-215.67888376911053.830688156-215.67888376911053.830688156X3的单位变动成本419.0759021934XVariable4174.489353478464.31948833862.71285356870.034973197617.1052355063331.873471450617.1052355063331.8734714506X4的单位变动成本174.4893534784XVariable5206.519806397776.2306658072.70914341640.03514606719.9900871731393.049525622219.9900871731393.0495256222X5的单位变动成本206.5198063977固定成本5.169523745多元回归方程Y=14.8*X1+21.83*X2+419.08*X3+174.49*X4+206.52*X5+5.17
本文档为【EXCEL财务模型库--量本利之多业务量成本分解】，请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑，
图片更改请在作品中右键图片并更换，文字修改请直接点击文字进行修改，也可以新增和删除文档中的内容。
该文档来自用户分享，如有侵权行为请发邮件ishare@vip.sina.com联系网站客服，我们会及时删除。
[版权声明] 本站所有资料为用户分享产生，若发现您的权利被侵害，请联系客服邮件isharekefu@iask.cn，我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
浙公网安备 33021202002483