My data consists of the number of defects per quarter for different processes. I have included a sample of my data below. I have about 800 different processes. I want to be able to screen all of them, and flag the ones that had the most variablity over the past 12 quarters.
- I have used the U control chart builder but that becomes a more manuel process checking through 800 processes
I want to be able to monitor the processes over the quarters. For example, if a process has 0 defects for the first 11 quarters, and has 12 defects on the 12th quarter- I want to be able to see that. Not necessarily which ones are associated with higher defects.
Assuming you have a column of data containg the date of each batch you might try using the quarter and year functions to derive new variables and then summarise total number of defects by year and quarter using tabulate or graph builder