If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 How do I calculate standard error in excel?
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How do I calculate standard error in excel?

 Thread Tools Display Modes
#1
July 13th 09, 05:08 PM posted to microsoft.public.excel.misc
 Kyle external usenet poster Posts: 66
How do I calculate standard error in excel?

How do I calculate standard error in excel?
 Ads
#2
July 13th 09, 05:23 PM posted to microsoft.public.excel.misc
 joeu2004 external usenet poster Posts: 2,059
How do I calculate standard error in excel?

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

#3
July 13th 09, 05:25 PM posted to microsoft.public.excel.misc
 Luke M external usenet poster Posts: 2,722
How do I calculate standard error in excel?

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?

#4
July 13th 09, 05:26 PM posted to microsoft.public.excel.misc
 EricG external usenet poster Posts: 220
How do I calculate standard error in excel?

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?

#5
July 13th 09, 05:27 PM posted to microsoft.public.excel.misc
 Jim Cone[_2_] external usenet poster Posts: 1,549
How do I calculate standard error in excel?

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?
#6
July 13th 09, 05:31 PM posted to microsoft.public.excel.misc
 francis external usenet poster Posts: 120
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

"Kyle" wrote:

> How do I calculate standard error in excel?

#7
July 14th 09, 02:08 AM posted to microsoft.public.excel.misc
 joeu2004 external usenet poster Posts: 2,059
How do I calculate standard error in excel?

Errata....

I wrote:
> "Kyle" > 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" > wrote in message
...
> "Kyle" > 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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Can we calculate RSD ( relative standard deviation) in Excel zizi Excel Discussion (Misc queries) 2 September 14th 08 09:08 PM Does anyone know if excel has a function to calculate standard er. mb Excel Worksheet Functions 2 March 25th 08 11:24 AM Calculate and display standard error harrynatick Charts and Charting in Excel 1 April 20th 06 09:18 AM Calculate 2 Standard Deviations Michael Excel Worksheet Functions 2 April 17th 06 06:13 PM PivotTables in Excel 2004 calculate incorrect standard deviations lvphj Excel Worksheet Functions 0 May 12th 05 05:30 PM

All times are GMT +1. The time now is 11:22 PM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.