| | | The standard deviation is a measure of how widely values are dispersed from the average value (the mean). |
| | | You can also use a single array or a reference to an array instead of arguments separated by commas. |
| | | Text and logical values such as True and False are ignored. |
| | | STDEVP assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV. |
| | | For large sample sizes, STDEV and STDEVP return approximately equal values. |
| | | The standard deviation is calculated using the "biased" or "n" method. |
| | | Using the same data from the STDEV example and assuming that only 10 tools are produced during the production run, STDEVP measures the standard deviation of breaking strengths for all the tools. |
| | | You can have a maximum of 30 arguments. |
| | | The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (826406). |
