试验设计与数据处理第二版课后习题答案VIP

2100415003550033600312003020028900277RE1750025500297003760042400509006180022X1234MX1/X20MMY882838MY1/Y5MM试验设计与数据处理课后习题答案第二章习题答案10000100000000101RE关系曲线79588058181582825838350246YX与Y的关系图系列123发酵时间/D012345PH值54586595857残糖量/（G/L）245133112101958124树脂型号DA201NKA9AB8D4006D101S8NKA吸附量/MG/G17141777187137105513333670246X52535455565758596610510152025300510PH值发酵时间/D发酵时间与PH值及残糖量的关系图残糖量PH值02468101214161820DA201NKA9AB8D4006D101S8NKA吸附量/MG/G树脂型号25甲乙花生油2935棉子油6362蓖麻油0105菜籽油53526应用领域橡胶工业合成表面活性剂润滑油脂肥皂及洗涤剂金属皂其他比例固点/植物油树脂型号29630153356205576543210123456花生油棉子油蓖麻油菜籽油凝固点/植物油两个产地几种植物油的凝固点数据图甲乙18112122比例/橡胶工业合成表面活性剂润滑油脂3131颜色橘黄色265287251291272粉色312283308279296绿色279251285242265无色308296324317328方差分析单因素方差分析SUMMARY组观测数求和平均方差行15136627322672行25147829562143行35132226443298行45157331461658方差分析差异源SSDFMSFPVALUEFCRIT组间7684553256151710486200004663238872组内3908416244275总计11592951932乙炔流量/（L/MIN）891011121811815803807715814818794791759275761754754708销售额/万元空气流量/（L/MIN）第三章习题答滑油脂肥皂及洗涤剂金属皂其他25604679687698687方差分析无重复双因素分析SUMMARY观测数求和平均方差行15399979983137行25397679525507行35372774544528行45335567114485列14297974475967425列24307376825422625列34303875952789667列44304376075214625列542924731159方差分析差异源SSDFMSFPVALUEFCRIT行5376375317921252861486944E063490295列354734886825141599402874223259167误差75155126262917总计64826551933铝材材质去离子水自来水123561185321553215483187432374方差分析可重复双因素分析SUMMARY去离子水自来水总计1观测数224求和4110915平均205545375方差012500453912观测数224求和3101131平均155053275方差00125424253观测数224求和41148189平均205744725方差0125095825总计观测数66求和112358平均18666666675966667方差01306666671298667方差分析差异源SSDFMSFPVALUEFCRIT样本437166666722185833312261900006735143253列5043150437204286177E075987378交互2355211775168214300034675143253内部0426007总计57576666671141C/XT/（Y196105420510622310722511089263109627811072911115110111112浓度与沸点温度之间的关系IXYXI2YI2XIYI119610543841611109162065842205106420251123621733223107249729114918423905642511089630011185921273339526310966916912012162882486278110777284122544930774672911115846811243225324465总和1707759342430582395111856738平均24385711084714286SUMMARYOUTPUT回归统计MULTIPLER0999752712RSQUARE0999505486ADJUSTEDRSQUARE0999406583标准误差0056916528观测值7方差分析DFSSMSFSIGNIFICANCEF回归分析1327380932738091010594185E09残差500161970003239总计63275429COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT929113793801562715945544255E1392509679331309XVARIABLE1063808051700063471005283185E090621764065439710510610710810911017222732T/C/系列142T/KC/LNTLNC273202436163130103SUMMARYOUTPUT2832524517861397942933124668681491362回归统计3133424955441531479MULTIPLER09877153334625224441662758RSQUARE0975583535825477751763428ADJUSTEDRSQUARE0969475标准误差0029578观测值6方差分析DF回归分析1残差4总计5COEFFICIENTSINTERCEPT81419XVARIABLE13887206SUMMARYOUTPUT回归统计MULTIPLER0987714594RSQUARE097558012ADJUSTEDRSQUARE0969475149标准误差0029578225观测值6方差分析DFSSMSFSIGNIFICANCEF回归分析1013980501398051598010000225残差400034990000875总计50143305COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT81418961590764781064610000441102653601853XVARIABLE1388720636030750212641240000225303344447409690000291101001001000C/T/K某物质的溶解度与绝对温度之间的关系系列1388720643试验号煎煮时间/MINX1煎煮次数X2加水量/倍X3含量/MG/LY1301815240211373503746460110265702634680395779031257SUMMARYOUTPUT回归统计MULTIPLER0992299718RSQUARE0984658731ADJUSTEDRSQUARE0969317462标准误差2742554455观测值7方差分析DFSSMSFSIGNIFICANCEF回归分析31448292482764164183660003211残差322564817521605总计61470857COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT1261111111535291823559300997672964654424264XVARIABLE101750066911261539600793150037940387942XVARIABLE2137129629615612688783223000310987443121868161XVARIABLE3128703703705371472396060096215042241299647944试验号T/NA2OX1/SIO2X2/CAOX3/X1X1X2X1X211029147291141008210111472811410083101614727114100841006147338814102625993147336814102626100414733811410262796714733711410262899914733611410262999214743781410402109801474711410361198014746114103612984147471141036139651571611510651410061571911510651598815727115108016984157291151080179671572811510801898715727115108019979157281151080209881572611510802196815738115109522940157371151095239561573611510952495615738115109525925157361151095SUMMARYOUTPUT回归统计MULTIPLER0866175908RSQUARE0750260704ADJUSTEDRSQUARE0714583661标准误差1279120464观测值25方差分析DFSSMSFSIGNIFICANCEF回归分析3103220934406962102923157E06残差2134359131636149总计2413758COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT155705891196995561605289289E1313553461758772XVARIABLE1386453237415362782515516002009366966667059398XVARIABLE211212663080249355449666000019816398306027XVARIABLE364842365252688135241216900250908939541207452所以得到的线性回归方程表达式为Y1557063865X1112X1X2648X3根据偏回归系数的大小，可知三个因素的主次顺序为X1X3X2。51优选过程1、首先在试验范围0618处做第一个实验，这一点的温度为X13404203400618389442、在这点的对称点，即0382处做一个实验，这一点的温度为X14204203400618370563、比较两次的实验结果，发现第一点比第二点的合成率高，故舍去37056以下部分，在37056420之间，找X1的对称X3420420370560618389446084、比较两次的实验结果，发现第一点比第三点的合成率高，故舍去38944608以下部分，在38944608420之间，找X1的对称X4420420389446080618401117677445、比较两次的实验结果，发现第一点比第四点的合成率高，故舍去40111767744以上部分，在3894460840111767744之间，找X1的对称X5401117677444011176774438944608061839378752电解质温度657480电解率943989815目标函数1014993X7062664887则下一个实验点为7063。54黄金分割法首先在实验范围的0618处做第一个实验，这一点的碱液用量为Y02274X232121X10328020406080100120020406080100电解率电解质温度212131323212221321232232214XXYXXYXXYXXYXXYXXYXX120802006185708ML在这一点的对称点，即0382处做第二个实验，这一点的碱液用量为X280802006184292ML比较两次试验结果，第二点较第一点好，则去掉5708以上的部分，然后在20ML与5708ML之间，找X2的对称点X35708570820061834165ML比较第二点与第三点，第二点较好，则去掉34165以下的部分，然后在34165ML与5708ML之间，找X2的对称点X434165570834165061848326ML比较第二点与第四点，第四点较好，则去掉4229以下的部分，然后在4229ML与5708ML之间，找X4的对称点X542295708422906185143ML由于X5属于50ML到55ML之间，则为最佳点。55对开法在直角坐标系中画出一矩形代表优选范围20X2X3X4又X3X4对应的偏回归系数不显著，故归入残差项，重新进行回归分析如下SUMMARYOUTPUT回归统计MULTIPLER0986424302RSQUARE0973032904ADJUSTEDRSQUARE0964043872标准误差2046677524观测值9方差分析DFSSMSFSIGNIFICANCEF回归分析2906866745343331082467196E05残差625133334188889总计8932COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT203933333325497367998213000020414154352663231丙烯酸用量X1/ML1720122041409371797E0614213782018622引发剂用量X2/103333333330510073386860014733177989286779简化后的方程非常显著，两偏回归系数也都显著，所以得到最终的二元线性方程YY185851644X111667X272序号废弃塑料质量X1/KG改性剂用量X2/KG增塑剂用量X3/KG混合剂用量X4/KGX1X2X3X3114712589814421610186816032431813556234254205146610019652281954176361624118642646472615165239025682862062168400930910502701001032121760384289SUMMARYOUTPUT回归统计MULTIPLER0997692974RSQUARE0995391271ADJUSTEDRSQUARE0986173814标准误差3039793997观测值10方差分析DFSSMSFSIGNIFICANCEF回归分析65987179997863210798980001361残差327721049240348总计960149COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT275851306146783055896394000973812696684247359废弃塑料质量X1/KG916404958812880227114820005714132631506499改性剂用量X2/KG219032459433784736483180007449326551111514增塑剂用量X3/KG21142610926037578120040003905294289128563混合剂用量X4/KG14028777920191033734364400052180794926201083X1X211645860301381498429919000350307249341604238X3X307275238170097581745562000499604169791038069回归方程Y2758519164X121903X221143X31403X4116X1X2073X32因素主次X1X2X3X4X1X2方程非常显著，偏回归系数也非常显著，所以四个因素对试验结果都有非常显著地影响。下面用规划求解来求得最大值X114127179X25X35X46881第八章习题答案试验号Z1Z2Z1Z2Z3Z1Z3灰化温度X1/111111700211111700311111700411111700511111300611111300711111300811111300SUMMARYOUTPUT回归统计MULTIPLER0994230144RSQUARE0988493579ADJUSTEDRSQUARE0959727528标准误差0007905694观测值8方差分析DFSSMSFSIGNIFICANCEFZ1100007610000761951E05Z21000911300091130001139Z3100001810000181226E05Z1Z2100002650000265331E05Z1Z3100004210000421526E05回归分析5001073900021483436320028518残差20000125625E05总计70010864COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT05047500027951805848307E0504927240516776Z10009750002795348826600732660002280021776Z200337500027951207477000678900217240045776Z1Z20004750002795169941202313420007280016776Z3000575000279520571801759390017780006276Z1Z30007250002795259383901220180004780019276回归方程Y050475000975Z1003375Z2000475Z1Z2000575Z3000725Z1Z3由该回归方程中偏回归系数绝对值的大小，可以得到各因素和交互作用的主次顺序为由方差分析的结果可知，只有Z2因素对试验指标有非常显著的影响，故可把其他因素归入残差项，重新进行方差分析得到如下表第二次方差分析表DFSSMSF显著性Z21000911300091133362546残差E600016260000271总计70010864因素Z2对试验指标Y有非常显著的影响，因此回归方程可以简化为Y050475003375Z2又Z2X22100/300,回带得方程Y0268500001125X282试验号Z1Z2Z3提取率Y/111182111733111694111645111696111657111681115190006610000651100066SUMMARYOUTPUT回归统计MULTIPLER0990265441RSQUARE0980625644ADJUSTEDRSQUARE0972322348标准误差0121074733观测值11方差分析DFSSMSFSIGNIFICANCEFZ11210125210125DIV/0Z21231125231125DIV/0Z31078125078125DIV/0回归分析35193751731251181008234E06残差701026140014659总计105296364COEFFICIENTS标准误差TSTATPVALUELOWER95UPPER95INTERCEPT66181818180036505181293241E14653186670