Skip to main content

BSCI 1510L Literature and Stats Guide: 3.3 Calculating Descriptive Statistics using Excel

Introduction to Biological Sciences lab, first semester

3.3 Calculating Descriptive Statistics using Excel

Note: to calculate the descriptive statistical values in this section, you must have enabled the Data Analysis Tools in Excel for Windows.  This has already been done on the lab computers but if you are using a computer elsewhere, you may need to enable it.  Go to the Excel Reference home page for instructions for PC and Mac.

To calculate descriptive statistics for a column of data, click on the Data ribbon.  Click on Data Analysis in the Analysis section.  Select Descriptive Statistics, then click OK.  Click on the Input Range selection button, then select the range of cells for the column.  (If you include a column label in your selection, check the "Labels in first row" checkbox.)  Check the Summary Statistics checkbox.  To put the results on the same sheet as the column of numbers, click on the Output Range radio button then click on the selection button.  Click on the upper left cell of the area of the sheet where you would like for the results to go.  Then press OK.