Dueling Excel 108


SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods

DESCRIPTION

See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods:
1) Data Analysis Toolpak Add-in, Descriptive Statistics
2) PivotTable
3) Functions and Defined Names
Functions: SUM, AVERAGE, STDEV.S, MIN, MAX
See keyboard shortcuts for Creating Defined Names From Selection and for entering Defined Names in Formulas and entering Functions from a drop down list.

WORKBOOKS




Be the first to comment

Leave a Reply