{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

DesStatsExcel

DesStatsExcel - 25.26 24.98 25.12 25.23 25.32 25.08 Mean...

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 Document Right 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

{[ snackBarMessage ]}

Page1 / 2

DesStatsExcel - 25.26 24.98 25.12 25.23 25.32 25.08 Mean...

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

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