Ask Chuck Kennedy

[AviarX]

SD is already calcd before doubling. SD is a derivative of the round ratings, not the doubled ratings.

so if i have 21 rated rounds, 5 are double weighted, and rather than calculate the std deviation for 26 rounds, the calculator first calculates the std deviation from the 21 rated rounds and then goes back, doubles the ratings of the most recent 5 rounds & then tallies the ratings of those 26 rounds, divides by the # of rounds (26) and then subtracts any rounds that were rated 2.5* the std deviation for the 21 rounds and recalculates the ratings minus any of those rounds that there are?

how do i make the formulas that are in place show up on your excel spreadsheet?