How do I calculate standard error in excel?

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)

 

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.

 

Depends on your definition of standard error. Is this what you're looking for?

http://mtsu32.mtsu.edu:11009/Graphing_Guides/Excel_Guide_Std_Error.htm

HTH,

Eric

 

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



"Kyle" <>
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
=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

 

Errata....

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


----- original message -----

 

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.