Calculating Standard Distribution

[SaMaLaKo]

A customer wants to calculate Standard Distribution on a series of 3000000 lines of data – can’t use excel for it – he’s using Business Objects, which generates
sql code.

Can anyone come up with a way to calculate the standard distribution in T-SQL or with a mathematical function (in excel, the function is NormsDist())

Thanks in advance...

Please tell me if I'm wrong I like to learn from my mistakes...
_____________________________________
Feed a man a fish and feed him for a day.
Teach a man to fish and feed him for a lifetime...

 

[gmmastros]

http://msdn.microsoft.com/en-us/library/aa259338(SQL.80).aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SaMaLaKo]

Hi gmmastros,

Sorry, but standard deviation is not the same as standard distribution. However, you will need stdev to calculate the standard distribution.

During my search I found this:

http://www.stat.uni-muenchen.de/~knuesel/elv/elv_docu.pdf

I think on page 13 the formula is explained

Found it via

http://support.microsoft.com/kb/827369

The only thing now is translating the formula to T-SQL
So if anyone has a suggestion ;-)

Please tell me if I'm wrong I like to learn from my mistakes...
_____________________________________
Feed a man a fish and feed him for a day.
Teach a man to fish and feed him for a lifetime...

 

[gmmastros]

Take a look here:

http://www.sqlservercentral.com/Forums/Topic158858-21-1.aspx#bm311464

Specifically the last post. Apparently it's written for sybase, but in my experience, sybase sql and T-SQL are similar enough that MOST of the time, you don't need to modify anything to get it to work. Give it a shot. If you run in to difficulties, post back and I'll help you some more.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom