Numbers not distributed evenly

74 Views Asked by At

We have a large (2000+) set of numbers that we are assigning grades to.

This is the logic

enter image description here

But no matter how many different data sets I use, grades fall into A, C, or F, i.e.

enter image description here

I understand that A has a large range, i.e. anything less than <85 and so does F, i.e anything greater than 115%

Whereas B, C, D have range of 10 points. But if that's the case, are some locations being graded as C?

To me, something seems amiss.

Is there some sort of mathematical phenomena (such as Birthday Paradox, where if you get 23 people in a room, two of them have same birthday)?

This has been puzzling me for over a week.

Update

I believe I implemented the formula correctly, so this question is a mathematical one

Here is screenshot

enter image description here