-
-
Notifications
You must be signed in to change notification settings - Fork 653
Qt_script_stddev
Paweł Salawa edited this page Jun 29, 2019
·
4 revisions
| Language: | Qt Script |
|---|---|
| Plugin for language: | ScriptingQt |
| How to use: | Create custom SQL function, set it to "aggregate" type. Suggested name: stddev |
| Function arguments | Keep undefined |
| Function usage: | SELECT stddev(colName) from tableName |
| Description: | SQLite offers an "Average" function, but no "Standard Deviation" function. This is easy to build using the Function Editor as an "Aggregate Function" by the name of StdDev. |
| Author: | JrgMyr |
Initialization code:
n=0; summe=0.0; quadrate=0.0;
Per step code:
n++; summe = summe + arguments[0]; quadrate = quadrate + (arguments[0] * arguments[0]);
Final step code:
return Math.sqrt(quadrate / n - (summe / n * summe / n));