Weighted Standard Deviation

Question

Hi I want to calculate weighted standard deviation in SQL Server 2012.

Is there any inbuilt function as of standard deviation in SQL Server or how to built a user define function in SQL Server.

possible duplicate of [weighted standard deviation in sql server without aggregation error](http://stackoverflow.com/questions/10947180/weighted-standard-deviation-in-sql-server-without-aggregation-error) — nothrow, Jan 29 '14 at 15:14

score 0 · Answer 1 · edited May 23 '17 at 12:18

0

There is no built-in function (a similar question was asked before by the way, although there is no accepted answer). Your most obvious options are:

edited May 23 '17 at 12:18

Community

answered Apr 16 '13 at 13:25

Pondlife

score -1 · Answer 2 · answered Apr 16 '13 at 18:04

-1

There is - check out the documentation on MSDN

Example from MSDN:

USE AdventureWorks2012;
GO
SELECT STDEV(Bonus)
FROM Sales.SalesPerson;
GO

answered Apr 16 '13 at 18:04

ScottS

1

That's standard deviation, not *weighted* standard deviation – Pondlife Apr 16 '13 at 20:10

2 Answers2