Microsoft Excel has an extensive set of statistical functions. These functions work well if you select and Name a Range of data. Start Here:
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
I just taught this lesson yesterday at college. Cheers! Elizabeth, The Computer Mama