Excel Tutorial on Statistics

1. Decide what statistical function or test you need to perform. For example, you might be trying to find an average, or mean, of several numbers, or you may want to find the slope for a graph that you've already plotted in Excel.
2. Click on the cell where you want to insert the statistical function.
3. Find the function name in Excel. Click on the 'Formulas' tab in Excel 2007 or Excel 2010, then click on 'More Functions.' Mouse over 'Statistical,' then click on the function you need. Most functions are named so that you can easily find what you are looking for. For example, AVERAGE finds the average of a range of numbers and MAX finds the maximum value in a range of numbers. If you are unsure about a particular function, mouse over the function name to find out more about the function or press the 'F1' key to bring up the help window for formulas and functions.
4. Fill out the information requested in the pop up window. The information will depend on which of the dozens of functions you have chosen. In general, you can expect to at least have to choose a range of cells to perform the function on. For example, if you want to find the average of a set of numbers in cells A1 to A10, then you'll need to enter 'A1:A10' as the range in the pop up window.
5. Press the 'OK' button. Excel will perform the requested function and return the result in the requested cell.