I need a function equivalent to the excel CHIDIST function. This function
calculates the one-tailed probability of the chi-squared distribution.

I don't think there is a built in function for it in SQL server, so would I
calculate it?

Is there a third-party tool that can do this?

Does anyone know the formulae for it? Maybe I can hand-code it.

Thanks for any help.

-Emad

Looks like you're in luck, if you're willing to settle for the Excel
CHIDIST function itself! It's one of the Excel functions that's
supported in Analyis Services (of course, Excel should be installed on
the same machine):

http://msdn.microsoft.com/library/en...sfunct_3bzn.as
p
the Microsoft Excel worksheet library, which is automatically registered
if installed on the computer with Analysis Services. Functions not
supported in this release are marked by an asterisk in this table.
...

George Spofford's paper on "Statistics in MDX" may help:

http://www.dsslab.com/MDXSolutions.h...tatistics.html



- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!