Presenting TOP 10 diseases (Number of in-patients by diseases) in our hospital

D

D.Salman

#1
Dear Experts,
Kindly, I am looking for a way to present (by using one of the available graphs) the TOP 10 diseases (Number of in-patients by diseases) in our hospital on a quarterly basis, the problem is, if I want to compare between first and second quarters, sometimes a certain diseases is one of the TOP 10 in Q1 and not one of the TOP 10 during Q2, so how can I depict this issue?
Many thanks in advance.
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#2
Re: Presenting TOP 10 diseases

I wouldn't make this harder than it needs to be.

If you are comparing the same diseases from time period to time period, I would use a histogram with paired bars or stacked bars.

If one or more of the top 10 diseases is replaced by a different one, you could use two histograms; one for each quarter.

I would be tempted to add another bar to the stacked or paired bar histogram; one of the original 10 would show the first quarter's figure only, while the 11th would show the second quarter's disease only. It seems to me this would most clearly communicate the trending from one period to the next.
 
C

chergh - 2008

#3
Re: Presenting TOP 10 diseases

Another option may be to use pie charts.

With a pie chart you could show the top 10 as individual segments and have an 11th segment as others. You can then use a split to give a breakdown of the others. i have attached an example of what I mean as I don't find it easy to explain.
 

Attachments

Jim Wynne

Staff member
Admin
#4
Re: Presenting TOP 10 diseases

Dear Experts,
Kindly, I am looking for a way to present (by using one of the available graphs) the TOP 10 diseases (Number of in-patients by diseases) in our hospital on a quarterly basis, the problem is, if I want to compare between first and second quarters, sometimes a certain diseases is one of the TOP 10 in Q1 and not one of the TOP 10 during Q2, so how can I depict this issue?
Many thanks in advance.
A different chart for each quarter?
 

Darius

Quite Involved in Discussions
#5
Re: Presenting TOP 10 diseases

Agree with Jennifer :agree1:
If you are comparing the same diseases from time period to time period, I would use a histogram with paired bars or stacked bars.
....
I would be tempted to add another bar to the stacked or paired bar histogram; one of the original 10 would show the first quarter's figure only, while the 11th would show the second quarter's disease only. It seems to me this would most clearly communicate the trending from one period to the next.
But take in account, staked bars gives you the view to the trend, paired bars gives you the view to the comparison.

Maybe I would use both or add a line trend to the paired bars chart in wich I could add the "stacked" value.
 
D

D.Salman

#6
Dear Experts,
I have attached the available data, you can see that diseases F available in quarter one but not available in quartet two, we have a new diseases which is Z.
Kindly, can you educate me, because till know I didn’t get the idea?
Many thanks in advance.
 

Attachments

Coury Ferguson

Moderator here to help
Staff member
Super Moderator
#7
Maybe try using a Pivot Table, using the existing data in the sheet. The Pivot Table can be "drilled down" to specifically identify certain things. It will also change when the data has been modified.

I was playing with the sheet attached, but it wouldn't create a Pivot Table. I will play with it some more, to see if I can create the Pivot Table and attached the file here.
 
Thread starter Similar threads Forum Replies Date
Steve Prevette Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
T Visually Presenting Effectiveness of Multiple Corrective Actions Nonconformance and Corrective Action 4
Q Presenting the Root Cause result in a one slide .ppt Powerpoint file Problem Solving, Root Cause Fault and Failure Analysis 8
E Internal Audits - Presenting Audit Findings to Upper Management General Auditing Discussions 19
Y Draft FDA Guidance on "Presenting Risk Information in Prescription Drug and Device" US Food and Drug Administration (FDA) 1
K Format for presenting capability study results? Statistical Analysis Tools, Techniques and SPC 7
L What shoud i do if our company top management has been changed. Oil and Gas Industry Standards and Regulations 8
Q Example Process orientation to the process leadership, management, goals (tasks of the top management) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
B OSHA Top Ten webinar, March 31 (free online) [Deleted] Misc. Quality Assurance and Business Systems Related Topics 1
Richard Regalado Top 10 operational risks of 2019 for business continuity planning Business Continuity & Resiliency Planning (BCRP) 6
E Resources for Planning for top quality Business Continuity & Resiliency Planning (BCRP) 6
Sidney Vianna Informational ISO 13485 Certificates Top 10 Countries - 2004 to 2017 ISO 13485:2016 - Medical Device Quality Management Systems 0
Sidney Vianna Informational ISO 14001 Certificates Top 15 Countries - 1999 to 2017 ISO 14001:2015 Specific Discussions 3
E Functional Gage for TOP applied at RFS Design and Development of Products and Processes 5
D Doing both a top-down and a bottom-up risk assessment - How to combine ISO 14971 - Medical Device Risk Management 6
C Is CE Mark needed for a small DAC audio board on top of a Rasberry PI? CE Marking (Conformité Européene) / CB Scheme 1
K About ionizers - How far can we place a table top ionizer from the IC devices Manufacturing and Related Processes 1
M Medical Device News ECRI – 2019 Top 10 Health Technology Hazards Medical Device and FDA Regulations and Standards News 0
Q Top Management Change Prior to Certification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
Sidney Vianna Top 10 Major and minor NC's during IATF 16949:2016 Audits IATF 16949 - Automotive Quality Systems Standard 8
Q Risks Examples in Top Management ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Q Additional KPI to Top Management beside Quality Objectives ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
K Top Executive Management ISO 9001:2015 and IATF 16949 Overview IATF 16949 - Automotive Quality Systems Standard 4
S What defines Top Management after a Merger? Quality Management Review (9.3.1) Management Review Meetings and related Processes 1
N Root Cause Challenge: The guy at the top ... Problem Solving, Root Cause Fault and Failure Analysis 4
M ECRI Top 10 Health Technology Hazards for 2017 Other Medical Device and Orthopedic Related Topics 3
L Auditing Top Management - Meeting Competency Requirements and Questions to Ask General Auditing Discussions 11
Q Who can Change goals and kpi of top management? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
L Engaging Top Management ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Marc 15 minute Top Management presentation on ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 23
A FTA-Top/Down approach to Risk Analysis ISO 14971 - Medical Device Risk Management 2
SATHYABALARAMAN OHSAS 18001:2007 4.4.1 Top management appointee Occupational Health & Safety Management Standards 8
A Creative ways to access Expert Information when you can't afford a top $ Consultant Misc. Quality Assurance and Business Systems Related Topics 7
D Best Engineering Practices related to Top Assembly Drawings Document Control Systems, Procedures, Forms and Templates 6
R Performance Qualification on a Table Top Centrifuge ISO 13485:2016 - Medical Device Quality Management Systems 3
Chennaiite Can an Auditor question Top Management decision to approve deviation? IATF 16949 - Automotive Quality Systems Standard 30
Y Differences between Top Management, Management & Organization ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Marc ISO 9001:2015 Structure - Top Level Clauses ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
T Uncertainty (Top Down Method)! Auditor argues that this is not enough Measurement Uncertainty (MU) 14
D Redundant BOMs - Maintaining a Reference Only BOM on our Top Level Assembly Drawings Document Control Systems, Procedures, Forms and Templates 7
C Recommended Sealing for Granite Top in a Clean Room US Food and Drug Administration (FDA) 1
Stijloor "Top Gear" (UK) Jeremy Drives a Reliant Robin Funny Stuff - Jokes and Humour 8
M The requirement for Communication via Top Management Quality Manager and Management Related Issues 4
Wes Bucey FWIW: Top Reported OSH Violations Occupational Health & Safety Management Standards 5
SATHYABALARAMAN ISO Systems Annual Report to Top Management example wanted IATF 16949 - Automotive Quality Systems Standard 10
M Helping Top Management Prepare for an ISO 14001 Audit ISO 14001:2015 Specific Discussions 4
sridharafep Quality Policy without Top Management Signature Quality Manager and Management Related Issues 37
K Questioning Top Management on The Quality Policy during Internal Audits Internal Auditing 7
B Categorization of Customer Complaint: Making Customers feel they are Top Priority Customer Complaints 4
L QMS for Service Company - Top Management wants to take the role of QMR Quality Manager and Management Related Issues 5

Similar threads

Top Bottom