MeanStdDevCI

# MeanStdDevCI - 0.50 1 50/100 32 t from student table...

This preview shows page 1. Sign up to view the full content.

Using Excel for Descriptive Statisics 1 Mean and Standard Deviation(B) Result (C) Formula Used(D) 2 %Fe 3 25.26 4 24.98 5 25.12 6 25.23 7 25.32 8 25.08 9 10 11 Mean 25.17 =AVERAGE(B3:B8) 12 Std. Deviation 0.13 =STDEV(B3:B8) 13 14 15 Confidence Interval Calculation 16 Glycoprotein 17 12.6 18 11.9 19 13.0 20 12.7 21 12.5 22 23 24 Mean 12.54 =AVERAGE(B17:B21) 25 Std. Deviation 0.40 =STDEV(B17:B21) 26 27 Number, n 5 =COUNT(B17:B21) 28 Degrees of Freedom (D.F.), n-1 4 =C27-1 29 Probability= 1-C.L./100) 30 Probability for C.L. of 90% 0.10 1- 90/100 31 Probability for C.L. of 50%
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.50 1- 50/100 32 t from student table =TINV(probability,D.F.) 33 Confidence Value =t*s/(n)^1/2 34 Confidence Value (90%) 0.38 =TINV(0.10,C28)*C25/SQRT(C27) 35 Confidence Upper Limit (90%) 12.92 =C24+C34 36 Confidence Lower Limit (90%) 12.16 =C24-C34 37 38 39 Confidence Value (50%) 0.13 =TINV(0.50,C28)*C25/SQRT(C7) 40 Confidence Upper Limit (50%) 12.67 =C24+C39 41 Confidence Lower Limit (50%) 12.41 =C24-C39...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online