This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Excel Function Formula Example From t to area =tdist(x,deg_freedom,tails) 0.03 From area to t =tinv(probability, deg_freedom) 2.86 From z to area =normsdist(z) 0.2412 From area to z =normsinv(probability) 1.04 Area between two given values =normdist(x,mean,standard_dev,false) 0.27 confidence interval (z) Descriptive statistics or Go to sheet 3 confidence interval (t) Descriptive statistics or Go to sheet 3 confidence interval (proportion) Go to sheet 3 Test statistic T or z) =(xbar-mean)/std/sqrt(n) Go to sheet 4 Test Statistic - proportion =p(hat)-p/sqrt(p(1-p)/n) Random number generation Data analysis - sampling Mean, median, mode Descriptive statistics Std dev of sample Descriptive statistics Std dev of pop =stdevp( second set of v Std dev of proportion =sqrt(p*1-p) Sample size determination Go to sheet 3 Simulation Data analysis - sampling Histogram Data analysis - Histogram Frequency Distribution Data analysis - Histogram 1. Calc class wi Dot plot Descriptive statistics Select "Dot Sca Pareto Chart Chart function Column chart Quartiles Select Quartile Found in Fx; Ar Box and Whisker Plot Descriptive statistics Select "Single g Birthday Problem Data analysis - sampling (example sht 2)...
View Full Document
- Spring '09