/
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:

GroupsParticipants
group16
group112
group15
group15
group15
group17
group15
group19
group18
group224
group224
group224
group233
group233
group229
group230
group232
group235

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.

GroupParticipants_STDEVP
group12.282515398241571
group24.109609335312651

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
More like this