# excfunc - EXCEL Functions Univariate Statistics...

This preview shows pages 1–3. Sign up to view the full content.

EXCEL Functions Univariate Statistics = Average(cell1:celln) Arithmetic mean: N x N x x n x n x x x N i i N n i i n = = = + + = = + + = 1 1 1 1 ... : Mean Population ... : Mean Sample μ =Devsq(cell1:celln): Sum of squared deviations: ( 29 = - n i i x x 1 2 = Var(cell1:celln) Sample variance: ( 29 ( 29 ( 29 1 1 ... 1 2 2 2 1 2 - - = - - + + - = = n x x n x x x x s n i i n = Stdev(Cell1:celln) Sample standard deviation: ( 29 ( 29 1 ... 2 2 1 - - + + - = n x x x x s n = Varp(cell1:celln) Population Variance: ( 29 ( 29 ( 29 N x N x x N i i N = - = - + + - = 1 2 2 2 1 2 ... σ = Stdevp(cell1:celln) Population standard deviation : ( 29 ( 29 ( 29 N x N x x N i i N = - = - + + - = 1 2 2 2 1 ... = Percentile(cell1:celln,p) (100)p th percentile of a sample To obtain the Interquartile Range enter: =percentile(cell1:celln,0.75)-percentile(cell1:celln,0.25)

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

View Full Document
=Skew(cell1:celln) Sample Skewness 3 1 ) 2 )( 1 ( = - - - n i j s x x n n n =Kurt(cell1:celln) Sample Kurtosis ) 3 )( 2 ( ) 1 ( 3 ) 3
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 06/04/2011 for the course STA 6166 taught by Professor Staff during the Fall '08 term at University of Florida.

### Page1 / 5

excfunc - EXCEL Functions Univariate Statistics...

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

View Full Document
Ask a homework question - tutors are online