How to define the accepted levels for monitoring the score?

[Eric]

There is a list of score under column A, starting from top to bottom.
I get no idea on how to define a level to be poor based on previous score.
Such as dropping from 100% to 72%, will it claim to be poor based on all
historical records.
Does anyone have any suggestions on how to detect any significant drop on
performance on following score?
Thanks in advance for any suggestions
Eric

61%
99%
100%
72%
50%
71%
47%
57%
78%
73%
79%
95%
68%
69%
48%
45%

 

[Gary''s Student]

Usually you don't need to consider the previous score. You can always say
that 60% and below is always poor. Pick your own limits.

If your are really interested in dropping scores, then calculate a running
average. If a new point is more than one standard deviations below that
average, call it poor.


These are only opinions. Virtue is in the mind of the Judge.

 

[Mike H]

Another slant is to put this in B2 and drag down. A fall of more than 10%
triggers and alert

=IF(A2*110%<A1,"Drop greater than 10%","")

Mike