Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mchsr
 
Posts: n/a
Default How many std deviations is Excel function "STDEVP"

How many std deviations is Excel function "STDEVP"
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One population std dev.

In article ,
"mchsr" wrote:

How many std deviations is Excel function "STDEVP"

  #3   Report Post  
David Billigmeier
 
Posts: n/a
Default

What do you mean how many std dev's?? That function calculates *The*
standard deviation of the population.
--
Regards,
Dave
<!--


"mchsr" wrote:

How many std deviations is Excel function "STDEVP"

  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

I don't understand your question. The function returns the standard deviation
of the population, in the same units as the data. There is only 1 value
returned.

On Mon, 12 Sep 2005 11:00:02 -0700, "mchsr"
wrote:

How many std deviations is Excel function "STDEVP"

  #5   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

As others have noted, your question is predicated on a misunderstanding.
Look at Help for STDEV and STDEVP to see the formulas that each uses.

STDEV is the square root of the unbiased estimate of the population
variance if your data is a sample of independant observations. STDEVP
is the population standard deviation if your data is a complete
enumeration of the population.

Jerry

mchsr wrote:

How many std deviations is Excel function "STDEVP"


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
calling a new function Excel gives me #NAME? Mark Dvorkin Excel Worksheet Functions 4 July 10th 05 01:29 AM
Excel 2003 Slow Function Argument Window [email protected] Excel Discussion (Misc queries) 2 June 28th 05 06:53 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Simplify Vlookup function in Excel Budman Excel Worksheet Functions 7 March 27th 05 04:17 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 07:16 AM.

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

About Us

"It's about Microsoft Excel"