Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu Show menu

SEM function

Description

Standard error of the mean function. SEM(range) calculates the standard error of the mean (SEM) of the data in range.

The argument range can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

Range can also be a matrix. In that case the function returns a matrix with one row and the same number of columns, with each element the SEM of the corresponding column. If range is a row matrix, it is converted to a column matrix first.

The Standard Error of the Mean (SEM) is calculated as follows:

Standard error of the mean (SEM) formula$$SEM = \frac{s}{\sqrt{n}} $$

where s is the standard deviation:

$$s = \sqrt{\frac{\sum_{}^{}{(x-\bar{x})^2}}{n-1}} $$

Example

SEM(A1:A8) calculates the standard error of the mean of the contents of cells A1 to A8.

SEM function

Calculator

SEM(  

Related functions