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

Browser not supported