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

Sterr 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 document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.

Examples and results

| Example | Result |
| --- | --- |
| `Table1:`<br>`crosstable 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 '\|');` `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 load script are:<br><br>`Type MySterr`<br>`Comparison 3.2674431`<br>`Observation 2.7968733` |