excel_stat_functions

# excel_stat_functions - Standard deviation sample...

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

ENGR 111C Statistics Fall 2006 Excel Statistics Functions Value Function Average …………………………………… AVERAGE(cr) Median …………………………………. MEDIAN(cr) Mode . ..……………………………………. MODE(cr) Minimum …………………………………. MIN(cr) Maximum ………………………………. ... MAX(cr) Range ……………………………………. .. MAX(cr) – MIN(cr) Variance, population .……………………. . VARP(cr) Variance, sample …………………………. VAR(cr) Standard deviation, population …………… STDEVP(cr)
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Standard deviation, sample ……………. ..... STDEV(cr) Z-transform: change variables from x to z . . STANDARDIZE (x, mean, stddev) Standard normal cumulative distribution from z: area from minus infinity to z ……. . NORMSDIST(z) Standard normal cumulative distribution from x: area from minus infinity to z ……. . NORMDIST(x, mean, stddev, TRUE) Inverse, from probability, find z …………. . NORMSINV(prob) Inverse, from probability, find x …………. . NORMINV(prob, mean, stddev) + cr, cell range...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online