Calculating Standard Deviation

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62752
interpreted = N
texte = 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. [!][/!] [!][/!] [!][/!] [!][/!] [!][/!] [search db=math.db&neRATINGdatarq=[blank]] [text show=F]numscores=[numfound][/text] [founditems] Rating [index]=[text show=T]num[index]=[rating][/text]
[/founditems] Total: [text show=T]total=[sum field=rating][/text]
[/search] Avg: [text show=T]avg=[math][total]/[numscores][/math][/text]
[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][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]
[/search] [text show=f]ass=[math][devsum]/([numscores]-1)[/math][/text] Standard Deviation =[format .2f][math]sqrt([ass])[/math][/format] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Calculating Standard Deviation ( Gary Krockover 2005)
  2. Calculating Standard Deviation ( Gary Krockover 2005)
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. [!][/!] [!][/!] [!][/!] [!][/!] [!][/!] [search db=math.db&neRATINGdatarq=[blank]] [text show=F]numscores=[numfound][/text] [founditems] Rating [index]=[text show=T]num[index]=[rating][/text]
[/founditems] Total: [text show=T]total=[sum field=rating][/text]
[/search] Avg: [text show=T]avg=[math][total]/[numscores][/math][/text]
[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][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]
[/search] [text show=f]ass=[math][devsum]/([numscores]-1)[/math][/text] Standard Deviation =[format .2f][math]sqrt([ass])[/math][/format] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

cant add to cart (2007) [math] variable question (1997) Ready,Set; Print! (1999) Resume Catalog ? (1997) Problem with encrypted cookies (2000) [WebDNA] divisible by 1 (2011) WC Database Format (1997) problems with 2 tags shakur (1997) UPDATEDONE question ... (1998) Re[2]: Balancing randomness (2000) Sorting by date (1997) international time (1997) Field name-subcategory (1997) Size limit for tmpl editor ? (1997) multi-paragraph fields (1997) emailer (1997) Webcatalog and foreign languages (1998) Time code! (2002) [lookup] again... (2003) File commands and Wild Cards ?? (1998)