How do I calculate standard error in excel?



Kyle said:
How do I calculate standard error in excel?

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

Note that in Excel, STDEV is the sample std dev (variance computed using
n-1), not the population std dev (STDEVP; variance computed using n)

Luke M

If your referring to statistics, I think you mean standard deviation (how far
data is off from the average). In which case, you want to use STDEV.

Jim Cone

Look up "standard error" in the Excel help file and see what is says about "STEYX"
Jim Cone
Portland, Oregon USA

"Kyle" <[email protected]>
wrote in message
How do I calculate standard error in excel?


assuming that your data are as :
Known y's are in range A2: A20
Known x's are in tange B2 : B20

try this
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another


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

As others noted, arguably it depends on what standard error you want. The
formula above is the standard error of the mean.

----- original message -----
Nov 9, 2017
Reaction score
Standard Error (SE)
Click on STDEV and drag across those cells you want to calculate the STDEV of
put "/SQRT(n)" after the STDEV to divide it by square root of number of samples
You should have "=STDEV(XX:XX)/SQRT(n)" as the formula in the cell - this will give the SE.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question