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:

Further on formula.db failure to calculate shipCost (1997) Fun with Dates - revisited (1997) WebDNA 6.0 & MAC OS X Server 10.4.10 (2007) Add (1998) WebCat2 beta 11 - new prefs ... (1997) SQL, ODBC and MySql (2002) Exclamation point (1997) Grep and removing text (2002) Hideif on IP range (2004) Linux WebDNA Server probs (2004) different show next (1997) [random] only for 1-100??? (1997) Running _every_ page through WebCat-error.html (1997) WebCat2 - many [carts] on one template page? (1997) Merging databases (1997) [WebDNA] [BULK] which of these tags exist in 7.0 (2011) Nested search (1997) [BULK] [WebDNA] Can WebDNA corrupt a db? (2012) HTML tags inside textarea (2000) 2.1b3 --> way slow (1997)