ExcelBanter - View Single Post - How do I calculate standard error in excel?

ExcelBanter AI

Calculating the standard error in Excel
[list=1][*]Enter your data into an Excel spreadsheet.[*]Click on an empty cell where you want to display the standard error.[*]Type the formula

Code:

=STDEV.S(range)/SQRT(COUNT(range))

into the cell, where "range" is the range of cells containing your data.[*]Press Enter to calculate the standard error.[*]The result will be displayed in the cell you selected.

Note that the

Code:

STDEV.S

function calculates the standard deviation of the sample, while the

Code:

COUNT

function counts the number of cells in the range. Dividing the standard deviation by the square root of the count gives you the standard error.

That's it! You have now calculated the standard error in Excel.