# Minitab for hourly patient census - Control Charts

E

#### ESR128

Looking for additional ways to analyze and graph a years worth of hourly census hospital data. I'm only looking at 1 floor with 30 beds and the patient level of care. I want to know how many times/% of times ICU patients on that floor are >15. I've only done regression in Minitab so far(doesn't apply here) and I know control charts are a powerful tool but what type of control chart ? What else should I look into ?
Thanks in advance for your suggestions !

E

#### ernestphoon

Hi,

You may want to set it up in excel to determine if the count is greater than 15 for a 1, 0 logic and count the number of 1s.

More useful would be, Minitab, Control Charts>attribute charts>c for consideration. Yields the average number of beds occupied bearing in mind that the physical limitation of 30 may distort the figures if you are at full occupancy.

Further exploration could involve a boxplot, Minitab, Graphs>boxplot>with groups,

Enjoy,
Ernest

#### Jim Wynne

Staff member
Looking for additional ways to analyze and graph a years worth of hourly census hospital data. I'm only looking at 1 floor with 30 beds and the patient level of care. I want to know how many times/% of times ICU patients on that floor are >15. I've only done regression in Minitab so far(doesn't apply here) and I know control charts are a powerful tool but what type of control chart ? What else should I look into ?
Thanks in advance for your suggestions !
You don't say what you're trying to find out in the long run. There's no point in doing control charts unless you're trying to control a process in one way or another. If all you want to know is how often patients on the floor number greater than 15, it should be a fairly simple thing to do in Excel. Tell us more about what you're trying to accomplish.

E

#### ESR128

thanks !! I'm going to give it a try.
Here's 2 samples of the type of data I will be using

if >15 then 1 else 0
Hour05/0705/0805/090:001111:001112:001113:001114:001115:001116:
00
1117:001118:001119:0011110:0011111:0011112:0011113:0011114:
00
11115:0011116:0011117:0011018:0011019:0011020:0011121:0011122:0011123:00111

or
Raw Data

Hour05/0705/0805/090:002118171:002121182:002121183:002121184:002121185:002121186:
00
2121187:002121188:002120189:0021201810:0021201811:0021211712:0020181713:0019181614:
00
19171615:0020181716:0020181717:0020201518:0020191519:0019191520:
00
19181721:0019181722:0019181723:00211817

Last edited by a moderator:
E

#### ESR128

sorry my last post of the data did not come out correctly. I will post data later today. My end goal ....
there is a floor with 30 beds divided by a set of hallway doors. right now the beds are ICU or step down beds(they can be both and staffed for both). what if we make 15 ICU and 15 step down only ? How many times will we have to "open the hallway door" and convert a step down bed to a ICU bed ? I'm using excel to summarize counts and %s but thought Minitab could add statistical value to this project or at least back up my excel findings.

Thanks for your time. Learning a lot.

E

#### ESR128

File of sample data attached..I hope

#### Attachments

• 11.1 KB Views: 109
E

#### ernestphoon

Hi,

The excel with the 1,0 logic does not seem to support having 15 beds or less in the ICU. Cross Contamination, disruptive physical movement etc for switching to meet demand considerations ...

However, I have relaid the data for minitab.

Data distribution does not seem to want to fit the regular distributions and transformations...

Miner, in a 'today's" post gives input on Tukey Freeman.

Interestingly from the boxplot, it would seem that mid-week is where the action is... More data may bear this out or refute it...

Enjoy,
Ernest

#### Attachments

• 365.6 KB Views: 153
• 74.6 KB Views: 181
• 40.2 KB Views: 159
Thread starter Similar threads Forum Replies Date
Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
One-factor and multiple-response Minitab optimization Using Minitab Software 0
Problem in Minitab - ERROR * Factor Voltage is highly correlated with other terms Using Minitab Software 10
Minitab 19 Anova or X bar # of distinct catagories Using Minitab Software 2
Pooled Standard Error - Minitab Statistical Analysis Tools, Techniques and SPC 0
Asterisk in DOE minitab software Using Minitab Software 23
Does anybody know how to get older versions of Minitab to work in Windows 10? Quality Tools, Improvement and Analysis 9
Minitab Capability of the Population (no sampling) Using Minitab Software 11
Minitab - Updating Graph with specific data points Using Minitab Software 2
Need help with analysing a survey on minitab Using Minitab Software 1
Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
Batch printing reports in Minitab Using Minitab Software 3
Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 9
Number of decimals in equation calculated by MiniTab Using Minitab Software 0
Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
Including Repeats in DoE using Minitab Using Minitab Software 5
A Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
N What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
S Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4
Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
DoE - Number of runs in Plackett-Burman (Minitab) Using Minitab Software 2
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
A Generating samples from a population in Minitab Using Minitab Software 0
Random data generation in Minitab Statistical Analysis Tools, Techniques and SPC 2
I DOE: High variance and small effects in Minitab Using Minitab Software 1
Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
R Rank Deficiency Error Minitab Using Minitab Software 7
H Minitab 15 - Factorial Design - 3 factors: 4x3x2 - How to? Using Minitab Software 4
A Capability Analysis for Packaging Seal Strength with spec. >0.1 Kgf using Minitab Using Minitab Software 6
MiniTab 17 Question-Standard Deviation Default Capability, Accuracy and Stability - Processes, Machines, etc. 5
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
L MINITAB 17 - Changing Data Using Minitab Software 3
R Conjoint Analysis - Minitab 18 Statistical Analysis Tools, Techniques and SPC 2
F How to make an ANOVA of a design with repeats (not replicates) in Minitab? Using Minitab Software 18
W Definitive screening design in Minitab 17 Manufacturing and Related Processes 1
S Minitab runs at different speeds on identical PCs Using Minitab Software 5
S Response Surface Method to create design matrix in Minitab Using Minitab Software 5
S Minitab limit definition from R & R Using Minitab Software 4
G ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
S Standard Deviation Selection on Control Charts - Minitab "pooled deviation" Statistical Analysis Tools, Techniques and SPC 3
P Minitab Data Analysis - Understanding if a Process is in Control or Not Using Minitab Software 2
P Basic Minitab Help - It's about Linear Regression Using Minitab Software 1
A Taguchi Minitab - Continuous Data - What should I choose as response variable? Using Minitab Software 3
K Taguchi Experiments for Factorial Design Analysis - Reliability of Minitab Results Using Minitab Software 1