View Single Post
Old 18th November 2014, 01:18 PM
Shaun's Avatar
Shaun Shaun is offline
Senior Member
Join Date: Dec 2008
Member of: Harriers
Location: Birmingham
Posts: 1,789

Hi Martin

I agree.

My solution = keep rolling 20 but only count your best 16 scores. This factors out low outliers

In excel something like this

=sum(a2:t2)-(large(a2:t2,17)+large(a2:t2,18)+large(a2:t2,19)+l arge(a2:t2,20))

assuming you have 20 scores; easily adapted if not.

What would this do?

It wouldn't change grades but would move everyone's score slightly higher which is what I think we need.

Reply With Quote