Question

Please show all calculation for the Data Rejection Tests portion. Thank you!

GRAVIMETRIC DETERMINATION OF WATER IN A HYDRATE Identity ofhydrate Casa : 2tO Actual % Hao Results: Trial No. % H2O by drying in oven % H2O by drying with burner 20.qs 20.8 20,91 20.11 (q, 77 21.04 (A. 70 20. SS 25.02 4.18 4 20.04 9.S1 2o.0 Preliminary Statistical Analysis: Mean value of% H2O * Standard deviation s from calculator or computer Fc Drying in oven Drying with burner 20.54 o. S76 9.aS Data Rejection Tests: Do the results of any of the trials appear to be possible outliers? I so, identify them and perform both a Q test and a Grubbs test to see if they can be discarded. Show your work below and state your conclusions as to whether or not they should be rejected.

Answer 1

日つ ome Insert Page LayoutFormulas Data Review View Cut Σ AutoSum 11 AAWrap Text General נר Copy Paste J Format Painter B 1 프 替▼ ». Δ ㄧ 運泯 困Merge & Center, conditional Format Styles Styles 犭 $ . % , insert Delete Format Sort & Find & 2 Clear FilterSelect Editing Formatting as Table Clear Clipboard Cells J10 S.No. SH20 by drying in Oven(x) (x-mean)^2 S.No %H20 bydrying with burner(y) (y-mean)^2 0.070604084 0.181232657 0.181232657 0.599518361 0.245732657 0.71281836 0.00003265 20.97 19.97 20.04 9.59 20.01 0.000625 0.009025 9.77 21.04 19.7 20.55 0.004225 12 119.67 sum of allㅕΣ(x-mean)^2)-0.15935 19.945 standard deviation-0.17852 sum of all-(2v) 143.81 sum of all-(2ly-mean)42)-1.9911714 sum of all-(x) 20.54428571 standard deviation-0.57607 16 17 18 21 24 25 :4イト뉘 | Sheet1 Sheet2 Sheet3 12:00 PM 01 -Feb-18 .'וז