Standard error (SE) is very similar to standard deviation as both are measures of spread. There one and only difference is that while the standard error uses sample data, standard deviations use population data.
Formula to calculate standard error in excel.
Like many other functions, the functions to calculate standard error can be found in excel.
=STDEV( X1:Xn)/SQRT(COUNT(X1:Xn))
Example:
Calculate the standard error of the following scores of a student in 5 subjects.
| Name of the Subject | Score |
| Mathematics | 92 |
| Anatomy | 90 |
| Psychology | 88 |
| Chemistry | 78 |
| Physics | 94 |
We begin by transferring the data to an excel spreadsheet.
Then insert the standard error’s function on the row below the scores column to get the standard deviation of the scores.
Therefore, click enter and get your answer.
Thus, your standard error is 2.785678.
