Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 13th 09, 05:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 66
Default How do I calculate standard error in excel?

How do I calculate standard error in excel?

  #2   Report Post  
Old July 13th 09, 05:23 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default 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   Report Post  
Old July 13th 09, 05:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default 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   Report Post  
Old July 13th 09, 05:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 220
Default 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   Report Post  
Old July 13th 09, 05:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 1,549
Default 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   Report Post  
Old July 13th 09, 05:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 120
Default 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   Report Post  
Old July 14th 09, 02:08 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default 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)




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 01:04 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017