Forum Discussion
Control chart for binary (yes/no) variable
Thank you for replying and I apologize for not providing enough detail. Anonymous Greg_Deckler amitchandak DataZoe
Control charts have 4 componenets, the count of the measure (average), the central line (the average of the data for a prior time period- serves as a baseline) , and upper and lower control limits (+/- 3 sigma line).
My data does look like this:
SampleID | Date | Outcome
1 | 2020-01-01 | 1
2 | 2020-01-01 | 0
3 | 2020-01-01 | 1
What I am strugling with is creating the upper and lower control limits (the red lines in the graph below). It would be a breeze if the data was continuous but I don't know if there is an alternative given my binary variable.
- Greg_Deckler6 years ago
Community Champion
rubio3003 - Shouldn't those be:
Upper Limit = AVERAGE([Outcome]) + 3 * STDDEV('Table'[Output]) Lower Limit = AVERAGE([Outcome]) - 3 * STDDEV('Table'[Output])Or am I missing something?
- rubio30036 years agoFrequent Visitor
Greg_Deckler You can only calculate STDEV of continuous variables, mine is a binary variable 😞