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.
Jean and Alexander Heard Libraries · 419 21st Avenue South · Nashville, TN 37203 · Phone
© Vanderbilt University · All rights reserved. Site Development: Digital Strategy and Development (Division of Communications)
Vanderbilt University is committed to principles of equal opportunity and affirmative action. Accessibility information.
Vanderbilt®, Vanderbilt University®, V Oak Leaf Design®, Star V Design® and Anchor Down® are trademarks of The Vanderbilt University