/
GROUPSTDEVP
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 |
, multiple selections available,
Related content
GROUPSTDEVP
GROUPSTDEVP
More like this
GROUPSTDEVP
GROUPSTDEVP
More like this
GROUPSTDEVS
GROUPSTDEVS
More like this
GROUPSTDEVS
GROUPSTDEVS
More like this
GROUPSTDEVS
GROUPSTDEVS
More like this
STDEVP
STDEVP
More like this