Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPSTDEVS(<number>)

Description

Estimates standard deviation of its arguments. It assumes that the arguments are a sample of the population. If they represent the entire population, use GROUPSTDEVP 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 GROUPSTDEVS(#RawData!Participants). The result is a float that is the estimated standard deviation on an assumed sample population in relation to the GROUPBY() column.

GroupsParticipants_STDEVS
group12.4209731743889917
group24.358898943540674
  • No labels