STDEVCOLUMN |
Description
Returns the standard deviation of a column.
Syntax
STDEVCOLUMN(value, column1, column2, ...)
Value is the column from which you want to find the standard deviation. Value can be a number or date column.
Column1, column2,... are up to 30 optional columns that define the aggregation context. The standard deviation is returned for each unique combination of the group_by columns.
When the result of STDEVCOLUMN is given as the final value for a new column in a transform worksheet, as in the example below, each row will get the value of STDEVCOLUMN that corresponds to its particular aggregate values.
If no group_by columns are provided, the standard deviation of the entire column is returned.
Example
In the following we see how STDEVCOLUMN works with a numeric column and a single aggregation column. The calculated value is entered in each row.
SampleData
UnitSales
| Store
| =STDEVCOLUMN(UnitSales,Store) | NUMBER
| TEXT
| NUMBER
| 157
| West | 0
| 127
| Central
| 17.7
| 102
| Central | 17.7
| 353
| North
| 0
| 104
| East
| .7
| 105
| East
| .7
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
