SQL Server 2008 DistNorm Excel equivalent
Posted on 2013-12-15
I have normalized data in a certain table, say:
Material ID UserID NormalizScore
1 1 -2.9487
1 2 -1.4771
If in Excel, I could use the function DIST.NORM, say DIST.NORM(-1.4771;0;1;TRUE) , applied to the value -1.4771, to obtain (aprox.) 0.0698 meaning there is 7% of the population (expected to be) below this normalized score.
Question: is there (what is) the SQL equivalent, please?