I have been asked to determine the upper and lower control limits for monthly data in a simple spreadsheet. The data consists of just one percentage amount per month for two years. Is there an easy way to do this?
Our main responsibility is to monitor scoring of contractual performance guarantees. Say, for instance, we are supposed to answer 95% of all calls made to our call center within 30 seconds. Based on our monthly scores for the last two years, we would like to set control limits that would "red flag" when we either fall below or exceed our average performance over the last two years.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.