Calculating Standard Deviation

I needed to do this for one of my hobby sites, so I thought I would share. Good if you have a scoring or ratings system on your site.

make sure that you have a tab on this line as indicated:
sdev[index]<tab>[math][interpret][dev[index]][/interpret]*[interpret][dev[index]][/interpret][/math]



[!]<!-- The following code will find the standard deviation-->[/!]
[!]<!-- in a range of numbers stored in a database (or table), -->[/!]
[!]<!-- where math.db is your database of scores -->[/!]
[!]<!--
SAMPLE DATABASE:
rating
8
5
6
5
4
9
7
1
5
6
-->[/!]
[!]<!--Should yield a STANDARD DEVIATION of 2.22-->[/!]

[search db=math.db&neRATINGdatarq=[blank]]
[text show=F]numscores=[numfound][/text]
[founditems]
Rating [index]=[text show=T]num[index]=[rating][/text]<br>
[/founditems]
Total: [text show=T]total=[sum field=rating][/text]<br>
[/search]
Avg: [text show=T]avg=[math][total]/[numscores][/math][/text]<br>
<hr>
[loop start=1&end=[numscores]]
[text show=f]dev[index]=[math]([interpret][num[index]][/Interpret]-[avg])*-1[/math][/text]
[/loop]
[table name=sdev&fields=sku,sdevnum]
[loop start=1&end=[numscores]]
sdev[index]<tab>[math][interpret][dev[index]][/interpret]*[interpret][dev[index]][/interpret][/math]
[/loop]
[/table]
[search table=sdev&neskudatarq=[blank]]
[text show=f]devsum=[sum field=sdevnum][/text]<br>
[/search]

[text show=f]ass=[math][devsum]/([numscores]-1)[/math][/text]
Standard Deviation =[format .2f][math]sqrt([ass])[/math][/format]
Gary Krockover

DOWNLOAD WEBDNA NOW!

Top Articles:

WebDNA Libraries

A list of available libraries for WebDNA...

WebDNA reference

A list of all WebDNA instructions...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Tips and Tricks

A list of user-submitted tips ...

WebDNA Modules

A list of the currently available modules...

F.A.Q

A compilation of some user's questions...

Related Readings:

Paypal IPN

...

Removing whitespace

How can I remove all whitespace entered by a user from an input box (ie card number)...

Handling credit card numbers

Encrypting the credit card numbers does the job quite nicely...

Spaghetti code

How to get rid of very long search strings...

How to setup CODA to work with WebDNA?

This page will show graphically how to setup CODA as a WebDNA partner :-)...

Export data to Excel

Here's a handy way to export your data to a text or Excel file...