| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to define the accepted levels for monitoring the score?
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% |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to define the accepted levels for monitoring the score?
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. -- Gary''s Student - gsnu200753 "Eric" wrote: 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% |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to define the accepted levels for monitoring the score?
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 "Eric" wrote: 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% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
| monitoring use | Excel Discussion (Misc queries) | |||
| No. of digits accepted in one cell | Excel Worksheet Functions | |||
| using a selection box and moving the accepted data | Excel Worksheet Functions | |||
| Monitoring Data | Excel Discussion (Misc queries) | |||
Linear Mode
