数据模型与决策作业

《数据模型与决策作业》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、数据模型与决策作业一、Cropain公司基建部问题1、首先将60组数据单独列出，找到因变量Y（earn）和自变量X（size、p15、inc、nrest、price）,数据如下所示：STOREARNSIZEP15INCNRESTPRICE128.312998027.64516.102-1.591129028.32711.40368.9140294030.2521.704202.1184357027.6711.805115.8144170033.92516.606221.7160464032.5822.107292.994360033.18924.308134.410034

2、5029.71416.40937.485193028.44312.9010181.092352028.37613.0011246.9167397038.3922.8012178.3199319032.11110.1013214.983492036.0816.70140.6141121035.31131.0015252.3240415035.91614.0016124.282279033.4613.3017258.196418035.4912.3018193.078465029.75128.801954.899132028.81712.802045.475221029.81

3、321.702166.352418028.62615.9022123.7177145034.91412.902357.8111167026.44111.702475.28472028.06416.7025115.695262028.25010.9026140.995399029.62123.202794.167349026.91816.0028250.8154395027.76414.3029-43.093257025.2533.4030145.667199036.56111.1031147.661479032.8317.7032175.1116446027.71912.

4、9033117.992205033.6511.203479.578337029.54520.0035140.5103245034.91332.9036399.2191485034.59618.2037246.3263288038.82922.603877.626177031.01320.6039108.3169177031.81019.3040188.697433030.82910.5041143.5117331029.93619.5042175.5116155034.04412.504394.176405031.01911.7044214.2144392030.0267

5、.604563.387323025.53218.7046237.173515035.21410.5047208.859345034.47111.7048110.683407029.54425.0049165.4125280033.81211.3050-11.456215029.91214.1051216.3146280032.12611.605265.762202032.77018.005367.696232030.0713.6054127.986248034.41716.505582.988187028.81612.8056-2.972331028.71024.3057

6、247.7119362033.46313.3058343.0285416027.64018.3059193.1193195028.73412.5060277.592489036.03114.10打开EXCEL表格-工具-数据分析-回归-确定-Y值区域为EARN列，X值区域为SIZE到PRICE列，点标志-确定，生成数据如下：SUMMARYOUTPUT回归统计MultipleR0.92532RSquare0.856217AdjustedRSquare0.842903标准误差36.20023观测值60方差分析　dfSSMSFSignificanceF回归分析5421397.1

7、84279.4164.3131.64E-21残差5470764.671310.457总计59492161.7　　　　Coefficients标准误差tStatP-valueLower95%Upper95%下限95.0%上限95.0%Intercept-353.8248.33297-7.320471.24E-09-450.722-256.918-450.722-256.918SIZE0.7718770.0896468.61031.03E-110.5921480.9516060.5921480.951606P150.0441750