• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

SQL Server 2008 DistNorm Excel equivalent

Hi there,

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?

1 Solution
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
TSQL in the MS SQL database engine doesn't include an equivalent function, and it isn't really intended as a statistical analysis package.  If the requirements are relatively modest and/or ad hoc, I think the best option would be to use SQL as the data store, with queries from Excel to retrieve data, and perform the analysis in Excel.  If you are willing to invest a fair amount of time, you can start doing data mining within SQL Server Analysis Server.
fskilnikAuthor Commented:
Hi, Razmus.

Thanks for the info and for the suggestion/link!

Through Google (what else?) I found exactly what I wanted... for the interested readers (and for myself in the future) here it is:


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now