How do I calculate standard error in excel?


Ad

Advertisements

J

JoeU2004

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)
 
L

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.
 
J

Jim Cone

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



"Kyle" <Kyle@discussions.microsoft.com>
wrote in message
How do I calculate standard error in excel?
 
F

Francis

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

try this
=STEYX(A2:A20,B2:B20)
--
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
 
J

JoeU2004

Errata....
=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 -----
 
Ad

Advertisements

Joined
Nov 9, 2017
Messages
1
Reaction score
0
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

Top