K

#### Kyle

How do I calculate standard error in excel?

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

K

How do I calculate standard error in excel?

J

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

data is off from the average). In which case, you want to use STDEV.

E

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

HTH,

Eric

J

--

Jim Cone

Portland, Oregon USA

"Kyle" <[email protected]>

wrote in message

How do I calculate standard error in excel?

F

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

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

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.