MeanStdDev

MeanStdDev - Using Excel for Descriptive Statisics 1 2 3 4...

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Using Excel for Descriptive Statisics 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Mean and Standard Deviation(B) Result (C) %Fe 25.26 24.98 25.12 25.23 25.32 25.08 Mean Std. Deviation Formula Used(D) 25.17 =AVERAGE(B3:B8) 0.13 =STDEV(B3:B8) Confidence Interval Calculation Glycoprotein 12.6 11.9 13.0 12.7 12.5 Mean Std. Deviation 12.54 =AVERAGE(B17:B21) 0.40 =STDEV(B17:B21) Number, n Degrees of Freedom (D.F.), n-1 Probability= 1-C.L./100) Probability for C.L. of 90% Probability for C.L. of 50% t from student table Confidence Value Confidence Value (90%) Confidence Upper Limit (90%) Confidence Lower Limit (90%) 5 =COUNT(B17:B21) 4 =C27-1 0.10 1- 90/100 0.50 1- 50/100 =TINV(probability,D.F.) =t*s/(n)^1/2 0.38 =TINV(0.10,C28)*C25/SQRT(C27) 12.92 =C24+C34 12.16 =C24-C34 Confidence Value (50%) Confidence Upper Limit (50%) Confidence Lower Limit (50%) 0.13 =TINV(0.50,C28)*C25/SQRT(C7) 12.67 =C24+C39 12.41 =C24-C39 ...
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.

Ask a homework question - tutors are online