GROUPSTDEVP
Syntax
GROUPSTDEVP(<number>)
Description
Estimates standard deviation on the entire population. If they represent only a sample of the entire population, use GROUPSTDEVS instead.
This is an aggregate function.
Example
Given the following data:
Groups | Participants |
---|---|
group1 | 6 |
group1 | 12 |
group1 | 5 |
group1 | 5 |
group1 | 5 |
group1 | 7 |
group1 | 5 |
group1 | 9 |
group1 | 8 |
group2 | 24 |
group2 | 24 |
group2 | 24 |
group2 | 33 |
group2 | 33 |
group2 | 29 |
group2 | 30 |
group2 | 32 |
group2 | 35 |
First create a group using GROUPBY(#RawData!Groups)
Groups |
---|
group1 |
group2 |
Then use the GROUPSTDEVP(#RawData!Participants), and the result is a float that is the estimated standard deviation on the entire population in relation to the GROUPBY() column.
Group | Participants_STDEVP |
---|---|
group1 | 2.282515398241571 |
group2 | 4.109609335312651 |