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 Chriss Miller 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
Joined
Jul 21, 2000
Messages
234
Location
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 Question
Calculating Median
Replies
0
Views
117
killerkoolkris
killerkoolkris
DaniDak
  • Locked
  • Question Question
*** Calculating the optimal Packet Size needed for a Stored Proc *****
Replies
0
Views
104
DaniDak
DaniDak
appi
  • Locked
  • Question Question
Standard Password missing
Replies
2
Views
144
appi
appi
cid
  • Locked
  • Question Question
SQL Standards
Replies
2
Views
170
Guest_imported
Guest_imported

Part and Inventory Search

Sponsor

Back
Top