Quick Statistical Measures in Excel - dummies

By Stephen L. Nelson, E. C. Nelson

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.