{{ transformations:StatisticalAggregationAction.png}}
====== STATISTICAL AGGREGATION ======
Category: Transform / Advanced\\

\\ 
=====Description=====
This action generates one or more statistical calculations:  Median, Percentile, Standard deviation, Standard error, and Variance.\\

\\ 
=====Action settings=====
^Setting^Description^
|Column|Select the column to perform the selected calculations on.|
|Functions|Select the calculations to perform.  Options:  //Median//, //Percentile//, //Standard deviation//, //Standard error//, and //Variance//.  Each selected function will create a new column in the dataset.|
|Group by|Select any columns to group the results by.|
\\ 
====Function options====
^Function ^ Options ^
|Percentile|Select the percentile //Threshold// <sup>*</sup> (0 to 100) as well as the //Percentile mode// (Inclusive, Exclusive, or Nearest rank).|
|Standard deviation|\\ Select whether to use a //Sample// or the full //Population//.| 
|Standard error|:::|
|Variance|:::| 
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\
=====Remarks=====
This action generates a single value for the whole source dataset.

\\
=====Examples=====

====Example #1====
>Determine the median of all goals scored by the listed team members.

===Before (source table)===
|Player A  |  5|
|Player B  |  12|
|Player C  |  20|
|Player D  |  25|
|Player E  |  30|
|Player F  |  35|
|Player G  |  40|
|Player H  |  45|

===After (result table)===
^Median  ^
|  **27.5**|

===Action parameters===
>Column: Goals scored
>Functions: Median

\\
=====Example #2======
>Determine the standard deviation of the goals scored by the listed team members.
===Before (source table)===
|Player A  |  5|
|Player B  |  12|
|Player C  |  20|
|Player D  |  25|
|Player E  |  30|
|Player F  |  35|
|Player G  |  40|
|Player H  |  45|

===After (result table)===
^StandardDeviation  ^
|  **13.763305250868**|

===Action parameters===
>Column: Goals scored
>Functions: Standard deviation (Sample)

\\
=====See also=====
  * [[transformations:aggregate|Aggregate]]