Page 5 of 22PREVNEXT

Excel statistical functions

Spreadsheet showing a selected range and formula

A formula used to find out the variance based on a range, in this case B8 to B75.

If you can use any function in Excel, you can use a statistics function. They are written in the same way:

  1. Always start with an equal sign (=).
  2. Then the function name.
  3. Then the arguments in parentheses.

With statistical formulas the arguments are frequently a range, as you can see in the picture on the left.

Page 5 of 22PREVNEXT