Re: Calculating Standard Deviation
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62753
interpreted = N
texte = P.S., make sure that you have a tab on this line as indicated:sdev[index]
[math][Interpret][dev[index]][/Interpret]*[Interpret][dev[index]][/Interpret][/math]GJKAt 03:57 AM 8/6/2005, you wrote:>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:
P.S., make sure that you have a tab on this line as indicated:sdev[index][math][interpret][dev[index]][/Interpret]*[interpret][dev[index]][/Interpret][/math]GJKAt 03:57 AM 8/6/2005, you wrote:>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:
DrWatson Error! (1999)
This list needs a digest: rant, rave... (1997)
emailer w/F2 (1997)
RE: Formulas.db + Users.db (1997)
Showif, Hideif reverse logic ? (1997)
(2001)
Opinion: [input] should be called [output] ... (1997)
[ShowIf] if the varieable exists (1998)
Netscape v. IE (1997)
Changing SubTotal (2003)
[OT] Trying to steal databases on our server (2003)
Hidden or Forbidden? (1998)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Upcoming 2.1 Release and PCS Committment (1997)
[WebDNA] Exclude found items in a 2nd search (2016)
WC2b15 File Corruption (1997)
Template cache problem with WC4 on Mac OS X (2000)
[LOOKUP] (1997)
WebCat2 beta 11 - new prefs ... (1997)
WebCat2 - [format thousands] (1997)