UsefulExcelFormula3-15-11

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

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

## This note was uploaded on 04/07/2011 for the course RES341 RES/341 taught by Professor Myhero during the Spring '09 term at University of Phoenix.

### 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
Ask a homework question - tutors are online