Calculating Mean, Median and Mode with SQL Server

 

 

I LOVE statistics and was recently asked about calculating the mean, median, and mode using SQL Server.  I found this great article by George Mastros that shows you how:

https://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/calculating-mean-median-and-mode-with-sq