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 Mike Lewis 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
0
0
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
10
killerkoolkris
killerkoolkris
DaniDak
  • Locked
  • Question
*** Calculating the optimal Packet Size needed for a Stored Proc *****
Replies
0
Views
13
DaniDak
DaniDak
appi
  • Locked
  • Question
Standard Password missing 1
Replies
2
Views
24
appi
appi
cid
  • Locked
  • Question
SQL Standards
Replies
2
Views
16
Guest_imported
Guest_imported

Part and Inventory Search

Sponsor

Back
Top