This wikiHow teaches you how to calculate the Standard error of a mean in Excel. The way you calculate the standard error is to divide the Standard Deviation (σ) by the square root (√) of the sample size (N).
Steps
-
Open Excel. It's the app that has a green icon that resembles a spreadsheet with an "X" on it.
-
Open or create a new Excel document. If you already have an Excel spreadsheet with your data, you can open that document by clicking "Open" in the green sidebar to the left. Otherwise, you can create a new document by clicking "New" and enter your dataset.Advertisement
-
Find the Standard Deviation. Although calculating the Standard Deviation is normally a few mathematical steps, you can calculate the Standard Deviation in Excel by typing the following formula =stdev(''cell range'') .
- For example, if your data points are recorded in cells A1 through A20, you would type =stdev(A1:A20) in an empty cell to get the Standard Deviation.
-
Type the formula for the Standard Error of the Mean in a blank cell. The formula for calculating the Standard Error of the mean in Excel is =stdev(''cell range'')/SQRT(count("cell range")) .
- For example, if your data is recorded in cells A1 through A20, you could type the following formula in a blank cell to calculate the Standard Error of the Mean by entering the formula =(stdev(A1:A20))/SQRT(count(A1:A20)) .
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Article Summary
X
1: Calculate the Standard Deviation (σ): =stdev( cell range
)
2. Divide σ by the square root (√) of sample size: =(stdev( cell range
))/sqrt(count( cell range
))
Did this summary help you?
Thanks to all authors for creating a page that has been read 6,189 times.
Advertisement
