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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
standard deviation
- Thread starter ganjass
- Start date
- Thread starter
- #2
- Thread starter
- #4
I couldn't get the total to work with the standard deviation, plus i wasn't convinced that crytals equation was the way forward as explained on their website so i done a bit of research and came up with a manual equation which gave the desired result
sqr(((Sum ({@Archive}) - {@average})*(Sum ({@Archive}) - {@average})
+(Sum ({@Closed}) - {@average})* (Sum ({@Closed}) - {@average})
+ (Sum ({@Inprogress}) - {@average})*(Sum ({@Inprogress}) - {@average})
+ (Sum ({@Request})- {@average})*(Sum ({@Request})- {@average}))
\4)
the reason i multiply the sum - average by itself is to remove negatives when you subtract the mean value from the total. I then added them and divided by the number of totals 4, and then sqr rooted the lot, and that was that.
sqr(((Sum ({@Archive}) - {@average})*(Sum ({@Archive}) - {@average})
+(Sum ({@Closed}) - {@average})* (Sum ({@Closed}) - {@average})
+ (Sum ({@Inprogress}) - {@average})*(Sum ({@Inprogress}) - {@average})
+ (Sum ({@Request})- {@average})*(Sum ({@Request})- {@average}))
\4)
the reason i multiply the sum - average by itself is to remove negatives when you subtract the mean value from the total. I then added them and divided by the number of totals 4, and then sqr rooted the lot, and that was that.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question