實(shí)驗(yàn)設(shè)計(jì)與大數(shù)據(jù)處理

1、試驗(yàn)設(shè)計(jì)與數(shù)據(jù)處理學(xué)院班級(jí)學(xué)號(hào)學(xué)生姓名指導(dǎo)老師第一章4、相對(duì)誤差:x =18.2mg 0.1% = 0.0182mg故100g中維生素 C的質(zhì)量范圍為：18.2 _0.0182mg。5、1）、壓力表的精度為 1.5級(jí)，量程為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(shù) = 9.8m/ s2則:

2、:xmax =9.8 10 KPaAx 9.8漢10亠Er1.225 10x86.樣本測(cè)疋值3.48算數(shù)平均值3.4216666673.37幾何平均值3.4214068943.47調(diào)和平均值3.4211475593.38標(biāo)準(zhǔn)差s0.0462240923.4標(biāo)準(zhǔn)差廳0.042196633.43樣本萬差S0.002136667總體萬差0.001780556算術(shù)平均誤差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)兩個(gè)人測(cè)量值沒有顯著性差異，即兩個(gè)人的測(cè)量方法的精密度沒有顯著性差異。分析人員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-檢驗(yàn)：雙樣本異方差假設(shè)變量1變量2平均0.0256846152.291111111萬差0.0000058610.031611111觀測(cè)值139假設(shè)平均差0df8t Stat-38.22288611P(Tv=t)單尾0t單尾臨界1.859548033P(T<=t)雙尾0t雙尾臨界2.306004133F-檢驗(yàn)雙樣本方差分析此時(shí)變量1變量2平均0.0256846152.291111111方差0.0000058610.031611111觀測(cè)值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.檢驗(yàn)新方法是否可行，即檢驗(yàn)新方法是否有系統(tǒng)誤差，這里采用秩和檢驗(yàn)。 求出各數(shù)據(jù)的秩，如下表所示：n = 9, n2 = 9, n =18R =1 5 6.5 9 11 12 14 15 18 = 91.5R2 =79.5對(duì)于a =0.05，查臨界值表得：T1=66, T2=102。則,<R<T2，故新方法與舊方法的數(shù)據(jù)無顯著性差異, 即新方法與舊方法的數(shù)據(jù)無顯著差異，即新方法無系統(tǒng)誤差。10.格拉布斯檢驗(yàn)法：

6、(1) 、檢驗(yàn) 62.2計(jì)算包括62.2在內(nèi)的平均值為69.947，即標(biāo)準(zhǔn)差2.7853，查表得G(0.05,10) = 2.176 所以 G(0.05,10)s =6.06則 |dp |=| Xp -69.947 |=7.7476.06，故 62.2 這個(gè)值應(yīng)被剔除。(2) 、檢驗(yàn) 69.49用同樣的方法檢驗(yàn)得，應(yīng)被剔除。(3) 、檢驗(yàn) 70.370.3不應(yīng)被剔除。第二章1.2.3.8.308.258.208.158.108.058.00ph值殘?zhí)橇? ( g/l)6.16.0 -5.9 -5.8 -5.7 -5.6 -5.5 -5.4 -5.3 -5.2 -02468發(fā)酵時(shí)間/d24222

7、01 .1 .1pg八量糖殘|吸附量（mg/g ）DA-201NKA-9AB-8 D-4006D-101S-8 NKA- H樹脂型號(hào)5.兩個(gè)產(chǎn)地幾種植物油的凝固點(diǎn)數(shù)據(jù)-2-4-63.520花生油棉子油-0.10.55.3菜子油蓖麻油-8-6.3 -6.2植物油6.比例/%23橡膠工業(yè)合成表面活性劑潤(rùn)滑油（脂）肥皂及洗滌劑金屬皂其他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方差分析：?jiǎn)我蛩胤讲罘治鯯UMMARY組觀測(cè)數(shù)求和平

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組內(nèi)72.87333107.287333總計(jì)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方差分析：無重復(fù)雙因素分析SUMMARY觀測(cè) 數(shù)求和平均方差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總計(jì)17706.79243.鋁材材質(zhì)去離子水自來水12.35.611.85.321.55.321.54.831.87.432.37.4方差分析：可重復(fù)雙因素分析SUMMARY1去離子水自來水總計(jì)觀測(cè)數(shù)224求和4.110.915平均2.055.453.75方差0.1250.0453.912觀測(cè)數(shù)224求和310.113.1平均1.55.053.275方差00.1254.24253觀測(cè)數(shù)224求和4.114.818.9平均2.057.44.725方差0.12509.5825總計(jì)觀測(cè)數(shù)66求和11.235.8平均1.8666675.966666667方差0.1306671.298666667差異