# Sterr - script function

Sterr() returns the aggregated standard error (stdev/sqrt(n)) for a series of values represented by the expression iterated over a number of records as defined by a group by clause.

Syntax:

Sterr ([distinct] expr)

Return data type: numeric

Arguments:

Arguments

| Argument | Description |
| --- | --- |
| expr | The expression or field containing the data to be measured. |
| distinct | If the word distinct<br>occurs before the expression, all duplicates will be disregarded. |

Limitations:

Text values, NULL values and missing values are disregarded.

Examples and results:

Add the example script to your app and run it. To see the result, add the fields listed in the results column to a sheet in your app.

Resulting data

| Example | Result |
| --- | --- |
| ```<br>Table1:<br>Crosstable (Type, Value)<br>Load recno() as ID, * inline [<br>Observation\|Comparison<br>35\|2<br>40\|27<br>12\|38<br>15\|31<br>21\|1<br>14\|19<br>46\|1<br>10\|34<br>28\|3<br>48\|1<br>16\|2<br>30\|3<br>32\|2<br>48\|1<br>31\|2<br>22\|1<br>12\|3<br>39\|29<br>19\|37<br>25\|2 ] (delimiter is '\|');<br>```<br><br>`Sterr1:``LOAD Type,``  Sterr(Value) as MySterr ``Resident Table1 Group By Type;` | In a table with the dimensions `Type` and `MySterr`, the results of the Sterr() calculation in the data load script are:<br><br>`Type MySterr`<br>`Comparison 3.2674431`<br>`Observation 2.7968733` |