# How do I calculate standard error in excel?

Kyle
Guest
Posts: n/a

 13th Jul 2009
How do I calculate standard error in excel?

JoeU2004
Guest
Posts: n/a

 13th Jul 2009
"Kyle" <(E-Mail Removed)> wrote:
> 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
Guest
Posts: n/a

 13th Jul 2009
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Kyle" wrote:

> How do I calculate standard error in excel?

EricG
Guest
Posts: n/a

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

http://mtsu32.mtsu.edu:11009/Graphin..._Std_Error.htm

HTH,

Eric

"Kyle" wrote:

> How do I calculate standard error in excel?

Jim Cone
Guest
Posts: n/a

 13th Jul 2009

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

"Kyle" <(E-Mail Removed)>
wrote in message
How do I calculate standard error in excel?

Francis
Guest
Posts: n/a

 13th Jul 2009
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)
--

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

"Kyle" wrote:

> How do I calculate standard error in excel?

JoeU2004
Guest
Posts: n/a

 14th Jul 2009
Errata....

I wrote:
> "Kyle" <(E-Mail Removed)> wrote:
>> How do I calculate standard error in excel?

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

"JoeU2004" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Kyle" <(E-Mail Removed)> wrote:
>> 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)

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post patrick.ohara@cognex.com Microsoft Dot NET Compact Framework 3 15th Jun 2007 09:34 PM =?Utf-8?B?UGF1bA==?= Microsoft Dot NET Framework 3 19th Oct 2006 08:23 AM =?Utf-8?B?ZmlzaGNha2Vz?= Microsoft Access VBA Modules 2 17th Jul 2006 09:08 PM =?Utf-8?B?aGFycnluYXRpY2s=?= Microsoft Excel Charting 1 20th Apr 2006 09:18 AM Bennett Smith Microsoft Dot NET Framework 0 26th Aug 2004 12:52 AM

Features