B
Beggin
I have what I believe to be a simple question. A few years ago I used to work with creating control charts for processes that contained a large number of "0" values. Essentially I am developing charts that display the amount of time it takes for a call center to answer a phone call. (obviously many of the calls are answered in zero seconds).
In order to take this non-normal data and put it into a control chart I realize I must transform the data. Unfortunately I can not remember how we used to do this. I have attached the data set (sample) so everyone can see what I'm working with. In the spreadsheet, the column "Que Conv" represents the number of seconds it took to have each phone call answered. (in seconds) The data is a representative sample of the total population.
In order to take this non-normal data and put it into a control chart I realize I must transform the data. Unfortunately I can not remember how we used to do this. I have attached the data set (sample) so everyone can see what I'm working with. In the spreadsheet, the column "Que Conv" represents the number of seconds it took to have each phone call answered. (in seconds) The data is a representative sample of the total population.