SEM is the standard deviation of the sample-mean estimate of a population mean.

SEM is calculated by taking the standard deviation and dividing it by the square root of the sample size. In Excel, this is calculated using the following formula:

**=stdev(range)/sqrt(count(range))**