Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating Standard Deviation

Status
Not open for further replies.
Toga

Toga

Technical User
Jul 21, 2000
234
US
It appears Sybase does not have a built in function for calulating Standard Deviation. Does anyone have a stored procedure that does this or know the proper SQL to obtain the standard deviation of some data?

We're using Sybase 11, if that matters.
 
Sort by date Sort by votes
Here's what I ended up with.....if anyone else ever needs to do this.

select

(SQRT((sum((MyFieldName - (select convert(dec(10,2),avg(MyFieldName))From MyTableNameWhere MyWhereCriteria and abs(MyFieldName)>0))*(MyFieldName - (select convert(dec(10,2),avg(MyFieldName))From MyTableNameWhere MyWhereCriteria and abs(MyFieldName)>0)))) /(select count(MyFieldName)-1 from MyTableNamewhere MyWhereCriteria))) 'StDev'

from MyTableNameWHERE MyWhereCriteria

It matches exactly with what you get from excel or something like that.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

killerkoolkris
  • Locked
  • Question
Calculating Median
Replies
0
Views
28
killerkoolkris
killerkoolkris
DaniDak
  • Locked
  • Question
*** Calculating the optimal Packet Size needed for a Stored Proc *****
Replies
0
Views
32
DaniDak
DaniDak
appi
  • Locked
  • Question
Standard Password missing 1
Replies
2
Views
46
appi
appi
cid
  • Locked
  • Question
SQL Standards
Replies
2
Views
45
Guest_imported
Guest_imported

Part and Inventory Search

Sponsor

Back
Top