实验设计与大数据处理

1、试验设计与数据处理学院班级学号学生姓名指导老师第一章4、相对误差:x =18.2mg 0.1% = 0.0182mg故100g中维生素 C的质量范围为：18.2 _0.0182mg。5、1）、压力表的精度为 1.5级，量程为0.2MPa，则| dp |=| Xp - 69.947 | = 7.747 606.%ax =0.2 1.5% =0.003MPa =3KPaAx 3Er0.375x 82）、1mm勺汞柱代表的大气压为 0.133KPa，所以.%ax =0.133KPax 0.133x 一 8=1.6625 1023)、1mm水柱代表的大气压为 Pgh，其中g = 9.8m/ s2则:

2、:xmax =9.8 10 KPaAx 9.8汉10亠Er1.225 10x86.样本测疋值3.48算数平均值3.4216666673.37几何平均值3.4214068943.47调和平均值3.4211475593.38标准差s0.0462240923.4标准差厅0.042196633.43样本万差S0.002136667总体万差0.001780556算术平均误差0.038333333极差R0.117、S? 2 = 3.733 , S? 2 = 2.303F = S? 2 / S? 2=3.733/2.303=1.62123而 F 0.975( 9.9 ) =0.248386 , F0.025

3、 (9.9)=4.025994所以F 0.975(9.9 ) < F <F 0.025 (9.9)两个人测量值没有显著性差异，即两个人的测量方法的精密度没有显著性差异。分析人员A分析人员B_t、/ r、/,. _ _ _87.5样本方差13.73333387.5样本万差22.302778104.5Fa值0.2483864.025994104F值1.6212365.568470567.565.5888. 旧工艺新工艺2.69%2.62%2.28%2.25%2.57%2.06%2.30%2.35%2.23%2.43%2.42%2.19%2.61%2.06%2.64%2.32%2.72%

4、2.34%3.02%2.45%2.95%2.51%t-检验：双样本异方差假设变量1变量2平均0.0256846152.291111111万差0.0000058610.031611111观测值139假设平均差0df8t Stat-38.22288611P(Tv=t)单尾0t单尾临界1.859548033P(T<=t)双尾0t双尾临界2.306004133F-检验双样本方差分析此时变量1变量2平均0.0256846152.291111111方差0.0000058610.031611111观测值139df128F0.000185422P(F<=f)单尾0F单尾临界0.3510539341

5、23456780.730.770.790.740.750.760.790.810111213141516170.840.850.870.910.830.860.920.969.检验新方法是否可行，即检验新方法是否有系统误差，这里采用秩和检验。 求出各数据的秩，如下表所示：n = 9, n2 = 9, n =18R =1 5 6.5 9 11 12 14 15 18 = 91.5R2 =79.5对于a =0.05，查临界值表得：T1=66, T2=102。则,<R<T2，故新方法与旧方法的数据无显著性差异, 即新方法与旧方法的数据无显著差异，即新方法无系统误差。10.格拉布斯检验法：

6、(1) 、检验 62.2计算包括62.2在内的平均值为69.947，即标准差2.7853，查表得G(0.05,10) = 2.176 所以 G(0.05,10)s =6.06则 |dp |=| Xp -69.947 |=7.7476.06，故 62.2 这个值应被剔除。(2) 、检验 69.49用同样的方法检验得，应被剔除。(3) 、检验 70.370.3不应被剔除。第二章1.2.3.8.308.258.208.158.108.058.00ph值残糖量/ ( g/l)6.16.0 -5.9 -5.8 -5.7 -5.6 -5.5 -5.4 -5.3 -5.2 -02468发酵时间/d24222

7、01 .1 .1pg八量糖残|吸附量（mg/g ）DA-201NKA-9AB-8 D-4006D-101S-8 NKA- H树脂型号5.两个产地几种植物油的凝固点数据-2-4-63.520花生油棉子油-0.10.55.3菜子油蓖麻油-8-6.3 -6.2植物油6.比例/%23橡胶工业合成表面活性剂润滑油（脂）肥皂及洗涤剂金属皂其他8.ol Y第三章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组观测数求和平

8、均方差26.5389.929.966673.24333328.738327.666675.36333325.1391.730.566673.84333329.1383.827.9333314.0633327.2388.929.633339.923333方差分析差异源SSdfMSFP-valueF crit组间19.76444.9410.6780260.6225853.47805组内72.87333107.287333总计92.63733142.乙炔流量/空气流量/（L/min）（L/min）89101112181.181.580.380771.581.481.879.479.175.92757

9、6.175.475.470.82.560.467.968.769.868.7方差分析：无重复双因素分析SUMMARY观测 数求和平均方差550102.515399.979.983.1371.55397.679.525.50725372.774.544.5282.55335.567.114.485空气流量/（ L/min ）5305.961.18956.3425316.363.26951.7435313.862.76890.8035315.363.06863.0485304.460.88758.567方差分析差异源SSdfMSFP-valueF crit行17586.1644396.541733

10、.90666.68E-183.006917列24.778446.19461.0340530.4200323.006917误.差95.8496165.9906总计17706.79243.铝材材质去离子水自来水12.35.611.85.321.55.321.54.831.87.432.37.4方差分析：可重复双因素分析SUMMARY1去离子水自来水总计观测数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.8666675.966666667方差0.1306671.298666667差异