As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Calculating Standard Deviation in Excel Made Easy

There are two methods for calculating standard deviation in Excel. The first method involves utilizing the STDEV function, while the second method utilizes the Data Analysis Toolpak.

STDEV Function

The STDEV function computes the standard deviation of a given set of numbers. To use this function, arrange the numbers in a column, and choose the cell where you want the result displayed. If the numbers are in cells A1 through A20, for instance, select cell A21. Then, input the following formula:


This formula will yield the standard deviation for the numbers within cells A1 through A20.

Data Analysis Toolpak

The Data Analysis Toolpak is an Excel add-in designed for statistical analyses. To utilize this toolpak, start by installing it. Access the 'File' tab, click on 'Options,' then navigate to the 'Add-Ins' section within the Options dialog box. In the 'Manage' box, select 'Excel Add-ins,' and click 'Go.' In the Add-Ins dialog box, check the box for 'Analysis ToolPak,' then click 'OK.'

Once installed, proceed to compute standard deviation. Navigate to the 'Data' tab, click on 'Data Analysis.' In the Data Analysis dialog box, choose the 'Standard Deviation' worksheet, and click 'OK.' Within the Standard Deviation dialog box, specify the range of cells containing the data, and click 'OK.' The tool will calculate the standard deviation, displaying the result in a new worksheet.