试验设计与数据处理(第二版)课后习题答案表格文件下载.xls

试验设计与数据处理(第二版)课后习题答案表格文件下载.xls

《试验设计与数据处理(第二版)课后习题答案表格文件下载.xls》由会员分享，可在线阅读，更多相关《试验设计与数据处理(第二版)课后习题答案表格文件下载.xls（68页珍藏版）》请在冰豆网上搜索。

试试验验设设计计与与数数据据处处理理课课后后习习题题答答案案第二章习题答案2.10.04150.03550.03360.03120.03020.02890.0277Re175002550029700376004240050900618002.2x1234Mx=1/x=20mmy88.28.38My=1/y=5mm关系曲线0.10.01100001000000Rex与y的关系图4.543.532.521.510.507.87.988.18.28.38.4xy系列12.3发酵时间/d012345PH值5.45.865.95.85.7残糖量/（g/l）24.513.311.210.19.58.12.4树脂型号DA-201NKA-9AB-8D-4006D-101S-8NKA-吸附量/（mg/g）17.1417.771.8713.710.5513.333.67发酵时间与PH值及残糖量的关系图98765432100510152025304.95.15.35.55.75.96.1发酵时间/dph值残糖量PH值DA-201NKA-9AB-8D-4006D-101S-8NKA-02468101214161820树脂型号吸附量/（mg/g）x与y的关系图4.543.532.521.510.507.87.988.18.28.38.4xy系列12.5植物油凝固点/甲乙花生油2.93.5棉子油-6.3-6.2蓖麻油-0.10.5菜籽油5.352.6应用领域橡胶工业合成表面活性剂润滑油（脂）肥皂及洗涤剂金属皂其他比例/%181152321222.9-6.3-0.15.33.5-6.20.55两个产地几种植物油的凝固点数据图花生油棉子油蓖麻油菜籽油-7-6-5-4-3-2-10123456植物油凝固点/甲乙18115232122比例/%橡胶工业合成表面活性剂润滑油（脂）肥皂及洗涤剂金属皂其他DA-201NKA-9AB-8D-4006D-101S-8NKA-02468101214161820树脂型号吸附量/（mg/g）3.1第三章习题答案3.1颜色销售额/万元橘黄色26.528.725.129.127.2粉色31.228.330.827.929.6绿色27.925.128.524.226.5无色30.829.632.431.732.8方差分析：

@#@单因素方差分析SUMMARY组观测数求和平均方差行15136.627.322.672行25147.829.562.143行35132.226.443.298行45157.331.461.658方差分析差异源SSdfMSFP-valueFcrit组间76.8455325.6151710.48620.0004663.238872组内39.084162.44275总计115.9295193.2乙炔流量空气流量/（L/min）/（L/min）89101112181.181.580.380771.581.481.879.479.175.927576.175.475.470.818115232122比例/%橡胶工业合成表面活性剂润滑油（脂）肥皂及洗涤剂金属皂其他2.560.467.968.769.868.7方差分析：

@#@无重复双因素分析SUMMARY观测数求和平均方差行15399.979.983.137行25397.679.525.507行35372.774.544.528行45335.567.114.485列14297.974.47596.7425列24307.376.82542.2625列34303.875.9527.89667列44304.376.07521.4625列54292.473.115.9方差分析差异源SSdfMSFP-valueFcrit行537.63753179.212528.614869.44E-063.490295列35.47348.868251.4159940.2874223.259167误差75.155126.262917总计648.2655193.3铝材材质去离子水自来水12.35.611.85.321.55.321.54.831.87.432.37.4方差分析：

@#@可重复双因素分析SUMMARY去离子水自来水总计1观测数224求和4.110.915平均2.055.453.75方差0.1250.0453.912观测数224求和310.113.1平均1.55.053.275方差00.1254.24253观测数224求和4.114.818.9平均2.057.44.725方差0.12509.5825总计观测数66求和11.235.8平均1.8666666675.966667方差0.1306666671.298667方差分析差异源SSdfMSFP-valueFcrit样本4.37166666722.18583331.226190.0006735.143253列50.43150.43720.42861.77E-075.987378交互2.35521.177516.821430.0034675.143253内部0.4260.07总计57.57666667114.1c/%（x）T/（y）19.6105.420.510622.3107.225.1108.926.3109.627.8110.729.1111.5浓度与沸点温度之间的关系3129272523211917102104106108110112c/%T/系列1ixyxi2yi2xiyi119.6105.4384.1611109.162065.84220.5106420.25112362173322.3107.2497.2911491.842390.56425.1108.9630.0111859.212733.39526.3109.6691.6912012.162882.48627.8110.7772.8412254.493077.46729.1111.5846.8112432.253244.65总和170.7759.34243.0582395.1118567.38平均24.38571108.4714286SUMMARYOUTPUT回归统计MultipleR0.999752712RSquare0.999505486AdjustedRSquare0.999406583标准误差0.056916528观测值7方差分析dfSSMSFSignificanceF回归分析132.7380932.7380910105.941.85E-09残差50.0161970.003239总计632.75429Coefficients标准误差tStatP-valueLower95%Upper95%Intercept92.911379380.156271594.55442.55E-1392.5096793.31309XVariable10.6380805170.006347100.52831.85E-090.6217640.654397浓度与沸点温度之间的关系3129272523211917102104106108110112c/%T/系列14.2T/Kc/%lnTlnc273202.4361631.30103SUMMARYOUTPUT283252.4517861.39794293312.4668681.491362回归统计313342.4955441.531479MultipleR0.987715333462.5224441.662758RSquare0.97558353582.5477751.763428AdjustedRSquare0.969475标准误差0.029578观测值6方差分析df回归分析1残差4总计5CoefficientsIntercept-8.1419XVariable13.887206SUMMARYOUTPUT回归统计MultipleR0.987714594RSquare0.97558012AdjustedRSquare0.969475149标准误差0.029578225观测值6方差分析dfSSMSFSignificanceF回归分析10.1398050.139805159.8010.000225残差40.0034990.000875总计50.143305Coefficients标准误差tStatP-valueLower95%Upper95%Intercept-8.1418961590.76478-10.64610.000441-10.2653-6.01853XVariable13.887206360.30750212.641240.0002253.0334444.7409690.000291某物质的溶解度与绝对温度之间的关系100010010100T/Kc/系列13.8872064.3试验号煎煮时间/min（x1）煎煮次数（x2）加水量/倍（x3）含量/（mg/L）y1301815240211373503746460110265702634680395779031257SUMMARYOUTPUT回归统计MultipleR0.992299718RSquare0.984658731AdjustedRSquare0.969317462标准误差2.742554455观测值7方差分析dfSSMSFSignificanceF回归分析31448.292482.764164.183660.003211残差322.564817.521605总计61470.857Coefficients标准误差tStatP-valueLower95%Upper95%Intercept-12.611111115.352918-2.355930.099767-29.64654.424264XVariable10.1750.0669112.6153960.079315-0.037940.387942XVariable213.712962961.5612688.7832230.0031098.74431218.68161XVariable31.2870370370.5371472.396060.096215-0.422412.9964794.4试验号T/Na2O（x1）/%siO2（x2）/%CaO（x3）/%X1=x1X2=x1x21102914729.11410082101114728.11410083101614727.1141008410061473.38.8141026.259931473.36.8141026.2610041473.38.1141026.279671473.37.1141026.289991473.36.1141026.299921474.37.8141040.21098014747.11410361198014746.11410361298414747.11410361396515716.115106514100615719.11510651598815727.11510801698415729.11510801796715728.11510801898715727.11510801997915728.11510802098815726.11510802196815738.11510952294015737.11510952395615736.11510952495615738.11510952592515736.1151095SUMMARYOUTPUT回归统计MultipleR0.866175908RSquare0.750260704AdjustedRSquare0.714583661标准误差12.7912046