UsefulExcelFormula3-15-11

UsefulExcelFormula3-15-11 - Excel Function Formula Example...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 21

UsefulExcelFormula3-15-11 - Excel Function Formula Example...

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