Statistical Functions in Microsoft Excel

Statistical Functions and Named Ranges

Microsoft Excel has an extensive set of statistical functions. These functions work well if you select and Name a Range of data.

Using Named Ranges

  • Select a Range: By definition, a RANGE is a one or more cells on a spreadsheet. The cells may be adjacent or not.
  • Define a Range: The Name Box is a special tool in the top left corner by the Formula bar. You can use the Name Box to Define a Range

Excel Lesson Pages

Facebook
Youtube
Pinterest
LinkedIn