CUSUM vs EWMA for subgroup aggregate analysisHello, I would love help with this question. We created a process across 9 different divisions. All the Divisions entered the project at different times over 2 years. We have individual division control charts, but could a CUSUM or EWMA chart be used to display aggregate, discrete data across the whole system for subgroups that enter at different times? Thanks in advance for any help!Basic Data Analysis and ModelingData Blending and CleanupData Exploration and VisualizationRe: CUSUM vs EWMA for subgroup aggregate analysisWhat is it that you're trying to discover with CUSUM or EWMA?
Is you data aggregate or discrete? (X-bar or IR charts)
Re: CUSUM vs EWMA for subgroup aggregate analysisIt is the aggregate of total numbers of numerators and denominators across all subgroups as they sequentially start the project.
This is simply for presentation purposes and not specifically for analysis which would reside at the individual division control chart level.
Thanks!Re: CUSUM vs EWMA for subgroup aggregate analysisWhat is it that you're trying to discover/visualize with CUSUM or EWMA?
Re: CUSUM vs EWMA for subgroup aggregate analysisThe cumulative performance of all divisions as the process ‘spreads across the system’ acknowledging that as each division is added, they have the same change package as previous divisions but are distinct on their adaption and time to reach goal. We would be utilizing this just for higher level presentations to show staff how their cumulative work is so impressive, not analysis of the process itself which would reside with the individual divisions.Re: CUSUM vs EWMA for subgroup aggregate analysis
It sounds like you want to plot the cumulative sum of X over time? Kind of like a forecast.
right click on your metric column, choose New Formula Column>Row>Cumulative Sum. This puts the cumulative sum formula in a new column
