Quick Statistical Measures in Excel
To perform a statistical calculation of a selected range list, right-click the Excel status bar. When you do, Excel displays a pop-up menu that includes numerous statistical measures that you can make on the selected range. Several of the most useful are detailed in the following table.
|Statistical Measures Option||What It Does|
|Average||Finds the mean of values in selected range.|
|Count||Tallies the cells that hold labels, values, or formulas. Use
this when you want to count the number of cells that aren’t
|Numerical Count||Tallies the number of cells in a selected range that hold
values or formulas.
|Maximum||Finds the largest value in the selected range.|
|Minimum||Finds the smallest value in the selected range.|
|Sum||Adds the values in the selected range.|