standardDeviation
Returns the standard deviation for a set of numbers.
Standard deviation measures the amount of variability among numbers in a dataset. Specifically, it calculates the average distance of a data point from the mean of the data. If the value is large, it means the data is spread out away from the mean. If the value is small, it means the data is concentrated near the mean.
There are two types of standard deviation:
Type | Assumption |
|---|---|
Sample standard deviation | The data is a sample representing a larger population |
Population standard deviation | The data is a population of its own |
The second parameter specifies which type to calculate. Sample standard deviation is the default.
The third parameter controls how the function handles null/empty values.
Parameters
INPUT LIST (list or table region)
A list or table region of numbers.
IS SAMPLE (Boolean)
Optional. Whether to calculate sample standard deviation (true) or population standard deviation (false).
Default: true
IGNORE NULLS (Boolean)
Optional. Whether to ignore empty/null values (true) or count them as zero (false).
Default: true
Examples
ATL in Script | Result | Notes |
|---|---|---|
| 1.58 | Calculates sample standard deviation. |
| 1.41 | Calculates population standard deviation. |
HANDLING NULL OR EMPTY VALUES
Assume a "Describe the Table" project with this data:
Candidate_ID | Score | |
|---|---|---|
Row 1 | 19001 | 77 |
Row 2 | 19002 | 65 |
Row 3 | 19003 | 53 |
Row 4 | 19004 | |
Row 5 | 19005 | 67 |
The first parameter can take a column variable, but here the Score column has one empty value. The optional third parameter tells the function to ignore the null/empty values or count them as zeros. For example.
ATL in Script | Result | Notes |
|---|---|---|
| 9.85 | The IGNORE NULLS parameter is unspecified, so true applies by default. The empty value is ignored. |
| 30.51 | The IGNORE NULLS parameter is set to false. The empty value in the Score column is counted as zero. |
Important
In a "Describe Row in Context" project, you would use ScoreColumn for the input variable.
