分析工具库模板.xls

学号高等数学 计算机原理 法学概论高等数学计算机原理2005010198939520050102737995平均78.27778 平均20050103747195标准误差 1.529449 标准误差20050104878395中位数79 中位数20050105938890众数83 众数20050106858295标准差11.23911 标准差20050107999095方差126.3176 方差20050108838195峰度0.067846 峰度20050109919295偏度-0.36481 偏度20050110758285区域52 区域20050111668085最小值48 最小值20050112727795最大值100 最大值20050113887395求和4227 求和20050114867995观测数54 观测数20050115696390置信度(95.0%)3.067687 置信度(95.0%)2005011676708520050117686095200501188782852005011978789520050120787685200501218381902005012272709520050123697990200501245864952005012583788520050126747595200501276585902005012882769520050129707495200501308975952005013169889520050132817695200501337670952005013410079952005013585749520050136668690200501378580952005013882739520050139488085200501407574852005014184759520050142758095200501439371852005014480799520050145557195200501466671952005014784849520050148779295200501498470952005015057788520050151927695200501529191952005015368758520050154838995法学概论78.11111 平均92.407410.999534 标准误差 0.55671978 中位数9579 众数957.345045 标准差4.09103353.94969 方差16.736550.036383 峰度-0.538070.034158 偏度-1.1188533 区域1060 最小值8593 最大值954218 求和499054 观测数542.004811 置信度(95.0%)1.116637计算机原理学号高等数学 计算机原理 法学概论接收频率2005010198939559.542005010273799569.592005010374719579.5142005010487839589.5192005010593889099.5720050106858295其他1200501079990952005010883819520050109919295200501107582852005011166808520050112727795200501138873952005011486799520050115696390200501167670852005011768609520050118878285200501197878952005012078768520050121838190200501227270952005012369799020050124586495200501258378852005012674759520050127658590200501288276952005012970749520050130897595200501316988952005013281769520050133767095200501341007995200501358574952005013666869020050137858095200501388273952005013948808520050140757485200501418475952005014275809520050143937185200501448079952005014555719520050146667195直方图59.569.579.589.599.5其他05101520接收频率2005014784849520050148779295200501498470952005015057788520050151927695200501529191952005015368758520050154838995组距59.569.579.589.599.5直方图59.569.579.589.599.5其他05101520接收频率病例号治疗前x治疗后yt-检验:成对双样本均值分析2438913312029603145122治疗前x治疗后y10703100105平均132.0833 120.083329153156133方差379.1742 175.356129648127108观测值121215693122110泊松相关系数0.92648726255142135假设平均差016364110105df1124400136122t Stat4.74566418871166145P(T=t)单尾0.00030263137138128t 单尾临界1.79588514829110108P(T=t)双尾0.000604t 双尾临界2.200985序号标准方法 改进方法F-检验 双样本方差分析188.189.1282.491.0标准方法 改进方法386.287.3平均86.2389.43484.389.1方差3.324556 2.224556587.490.0观测值1010688.489.1df99786.089.1F1.494481885.587.3P(F=f)单尾 0.279511986.790.2F 单尾临界3.1788931087.392.1序号标准方法 改进方法t-检验:双样本等方差假设188.189.1282.491.0标准方法 改进方法386.287.3平均86.2389.43484.389.1方差3.324556 2.224556587.490.0观测值1010688.489.1合并方差2.774556786.089.1假设平均差0885.587.3df18986.790.2t Stat-4.295741087.392.1P(T=t)单尾 0.000218t 单尾临界1.734064P(T=t)双尾 0.000435t 双尾临界2.100922序号 青霉素 四环素 链霉素 红霉素 氯霉素方差分析：单因素方差分析129.627.35.821.629.2224.332.66.217.432.8SUMMARY328.530.81118.325组观测数求和平均43234.88.31924.2青霉素4114.428.6四环素4125.531.375链霉素431.37.825红霉素476.319.075氯霉素4111.227.8方差分析差异源SSdfMS组间1480.8234 370.2057组内135.822515 9.054833总计1616.64519方差10.3533310.055835.68253.262515.92FP-valueF crit40.88488 6.74E-08 3.055568施肥方案1 施肥方案2 施肥方案3 施肥方案4方差分析：可重复双因素分析剪枝方案136.635.032.230.8剪枝方案132.233.031.030.2SUMMARY施肥方案1剪枝方案130.332.029.030.9剪枝方案1剪枝方案233.533.529.828.3观测数3剪枝方案231.832.028.327.5求和99.1剪枝方案229.230.527.527.8平均33.03333剪枝方案329.128.529.829.5方差10.44333剪枝方案329.828.128.628.5剪枝方案328.227.828.026.5剪枝方案2观测数3求和94.5平均31.5方差4.69剪枝方案3观测数3求和87.1平均29.03333方差0.643333总计观测数9求和280.7平均31.18889方差6.998611方差分析差异源SS样本69.89389列38.8075交互20.78833内部55.88总计185.3697施肥方案2 施肥方案3 施肥方案4 总计3331210092.291.9383.233.33333 30.73333 30.63333 31.933332.333333 2.613333 0.143333 4.542424333129685.683.6359.732 28.53333 27.8666729.9752.25 1.363333 0.163333 5.0711363331284.486.484.5342.428.1333328.8 28.16667 28.533330.1233330.84 2.333333 0.884242999280.4264.226031.15556 29.35556 28.888896.647778 2.285278 2.388611dfMSFP-valueF crit2 34.94694 15.00942 5.92E-05 3.4028263 12.93583 5.555834 0.004847 3.0087876 3.4647221.488070.22448 2.50818924 2.32833335方差分析：可重复双因素分析年度销售额19874119884819895319905119915850.219925753.419936456.619946959.81995676319966965.21997766919987370.819997972.820008476.220018679.620028781.820039285.620049588.8200510192.2200610796.4移动平均1 2 3 4 5 6 7 8 91011121314151617181920020406080100120数据点值实际值预测值移动平均1 2 3 4 5 6 7 8 91011121314151617181920020406080100120数据点值实际值预测值年度销售额1987411988484119895345.919905150.8719915850.96119925755.88819936456.66619946961.819956766.8419966966.95219977668.38619987373.71619997973.21520008477.26420018681.97920028784.79420039286.33820049590.301200510193.59200610798.777指数平滑1 2 3 4 5 6 7 8 9 1011121314151617181920020406080100120数据点值实际值预测值指数平滑1 2 3 4 5 6 7 8 9 1011121314151617181920020406080100120数据点值实际值预测值TYX1X2X3SUMMARY OUTPUT111954.50.86371.743.92214922.30.89357.723.77回归统计316917.80.94364.323.39Multiple R 0.911940526418598.40.95393.103.97R Square0.831635523521662.50.94378.264.93Adjusted R Square0.768498844626651.90.96379.973.87标准误差11743.07731734560.50.98387.373.17观测值12846670.01.04373.463.64957494.91.13387.283.96方差分析1066850.51.15414.393.45df1173142.71.12401.743.74回归分析31278017.81.01412.423.62残差8总计11103618.21.20420.00CoefficientsIntercept-306717.449X1142124.3822X2570.9199106X3-4222.676239RESIDUAL OUTPUT观测值预测 Y111190.3963528083.232107320562.1396435965.30623522017.84174630312.63925740335.8076838937.11674958267.16791078740.859211166030.414761257000.87851SSMSFSignificance F5.45E+09 1.82E+09 13.171987 0.00183921.1E+09 1.38E+086.55E+09标准误差t StatP-valueLower 95%Upper 95%下限 95.0%上限 95.0%89148.8-3.44051 0.0088172-512294.9-101139.9-512294.9-101139.951901.06 2.738372 0.0255134 22440.334 261808.43 22440.334 261808.43271.5682 2.102308 0.0686905-55.31741 1197.1572-55.31741 1197.15728323.401-0.50733 0.6256129-23416.47 14971.122-23416.47 14971.122残差标准残差764.10360.07636839.068 0.682915-3644.34-0.36391-17366.9-1.73417-355.342-0.03548-3660.74-0.36554-5775.31-0.576697732.883 0.772166-772.268-0.07711-11890.4-1.187317112.285 0.71019721016.92 2.098643X1 Residual Plot1.41.210.80.60.40.20-2000002000040000X1残差X2 Residual Plot420.00410.00400.00390.00380.00370.00360.00350.00340.00330.00320.00-2000002000040000X2残差X3 Residual Plot5.554.543.532.521.510.50-2000002000040000X3残差X1 Line Fit Plot1.41.210.80.60.40.200.050000.0100000.0X1YY预测 YX2 Line Fit Plot420.00370.00320.000.050000.0100000.0X2YY预测 YX3 Line Fit Plot65432100.050000.0100000.0X3YY预测 YX1 Residual Plot1.41.210.80.60.40.20-2000002000040000X1残差X3 Line Fit Plot65432100.050000.0100000.0X3YY预测 YTYX1X2X3Y111954.50.86371.743.92Y1214922.30.89357.723.77X10.855801925316917.80.94364.323.39X20.80936037418598.40.95393.103.97X3-0.270279785521662.50.94378.264.93626651.90.96379.973.87734560.50.98387.373.17846670.01.04373.463.64957494.91.13387.283.961066850.51.15414.393.451173142.71.12401.743.741278017.81.01412.423.62X1X2X310.6849661-0.22602-0.16711TYX1X2X3SUMMARY OUTPUT111954.50.86371.743.92214922.30.89357.723.77回归统计316917.80.94364.323.39Multiple R 0.908965802418598.40.95393.103.97R Square0.826218828521662.50.94378.264.93Adjusted R Square0.78760079626651.90.96379.973.87标准误差11248.16781734560.50.98387.373.17观测值12846670.01.04373.463.64957494.91.13387.283.96方差分析1066850.51.15414.393.45df1173142.71.12401.743.74回归分析21278017.81.01412.423.62残差9总计1188543.051.20420.00CoefficientsIntercept-327701.5357X1146213.7762X2573.304887SSMSFSignificance F5.41E+09 2.71E+09 21.394635 0.00038021.14E+09 1.27E+086.55E+09标准误差t StatP-valueLower 95%Upper 95%下限 95.0%上限 95.0%75644.37-4.33213 0.0018992-498821.1-156581.9-498821.1-156581.949110.47 2.977242 0.0155189 35118.091 257309.46 35118.091 257309.46260.084 2.204307 0.0549532-15.04647 1161.6562-15.04647 1161.6562