DesStatsExcel

DesStatsExcel - %Fe 25.26 24.98 25.12 25.23 25.32 25.08...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Mean and Standard Deviation Result Formula Used %Fe 116 97.9 114.2 106.8 108.3   Mean 108.64 =AVERAGE(A2:A7) Std. Deviation 7.14 =STDEV(A2:A7) Confidence Interval Calculation Glycoprotein 116 97.9 114.2 106.8 108.3 Mean 108.64 =AVERAGE(A16:A20) Std. Deviation 7.14 =STDEV(A16:A20) Confidence Interval =t*s/(n)^1/2 Number, n 5.00 =COUNT(A17:A21) Degrees of Freedom (D.F.) n-1 4.00 =B27-1 Probability= 1-C.L./100) Probability for C.L. of 90% 0.10 1- 90/100 Probability for C.L. of 50% 0.50 1- 50/100 t from student table =TINV(probability,D.F.)  2.13 Confidence Interval (90%) 6.81 =TINV(0.10,4)*B25/SQRT(B27) Confidence Interval (50%) 2.25 =TINV(0.50,4)*B25/SQRT(B27)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Mean and Standard Deviation Result Formula Used
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: %Fe 25.26 24.98 25.12 25.23 25.32 25.08 Mean 25.17 =AVERAGE(A2:A7) Std. Deviation 0.13 =STDEV(A2:A7) Confidence Interval Calculation Glycoprotein 12.6 11.9 13 12.7 12.5 Mean 12.54 =AVERAGE(A16:A20) Std. Deviation 0.40 =STDEV(A16:A20) Confidence Interval =t*s/(n)^1/2 Number, n 5.00 =COUNT(A17:A21) Degrees of Freedom (D.F.) n-1 4.00 =B27-1 Probability= 1-C.L./100) Probability for C.L. of 90% 0.10 1- 90/100 Probability for C.L. of 50% 0.50 1- 50/100 t from student table =TINV(probability,D.F.) Confidence Interval (90%) 0.38 =TINV(0.10,4)*B25/SQRT(B27) Confidence Interval (50%) 0.13 =TINV(0.50,4)*B25/SQRT(B27)...
View Full Document

This note was uploaded on 10/19/2011 for the course CHEM 197 taught by Professor Bonk during the Summer '11 term at Duke.

Page1 / 2

DesStatsExcel - %Fe 25.26 24.98 25.12 25.23 25.32 25.08...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online