excel_stat_functions

excel_stat_functions - Standard deviation, sample . ........

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

View Full Document Right Arrow Icon
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)
Background image of page 1
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

Ask a homework question - tutors are online