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] GJK At 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:

    
  1. Re: Calculating Standard Deviation ( Gary Krockover 2005)
  2. Calculating Standard Deviation ( Gary Krockover 2005)
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] GJK At 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:

Replace context problem ... (1997) Ok here is a question? (1997) RE: Price recalc based on quantity (1997) Missing custom convert.db (1998) SiteEdit Pro Update Announcement (1997) Newbie Tax Question (1997) b12 cannot limit records returned and more. (1997) Looking for a special Image Upload Script (2004) Extended [ConvertChars] (1997) Trouble Searching (1999) Multiple Pulldowns (1997) (1997) WebCommerce: Folder organization ? (1997) [replaceChars] would be nice ... (1997) SIMS & WebCat .... Alias Folder (2002) Keep away (1997) Linux ODBC and the ODBC Bridge (2000) Grep Question - MAY NEVER BE SOLVED (2003) Serial Numbers (2000) database performance/design question (2000)