Plot the Dots

The first thing you should do whenever you find yourself with data, is to visualise the data - typically to plot it on a graph.
Which graph you use will depend on what data you have.
For example, suppose you have
(NOTE EACH OF THESE SECTIONS IS EXPLAINED IN MORE DETAIL ON THE LINKS)

Scores, or Numbers against departments
For example, this could include:

numbers of service user contacts per person (NOTE if you have numbers of contacts per week for a number of weeks, see below)
patient satisfaction scores for each department or organisation
smoking quitters per 1,000 population by GP practice
average length of stay (LOS) by speciality and by ward
income (in HRG) per consultant

Plot
a histograph or histogram
If it's a normal curve, you can boxplot the averages and if there's something
to go on then compare averages with
Student's t test for two averages
ANOVA analysis of variables for more than two averages

For a two-way analysis (where you have two comparators eg sex, hospital or speciality, ward)

use ANOVA analysis of variables for two or more ways
use Chi-squared () to test whether the observations are significantly different from what you would 'expect'

 

Change over time
For example:

waiting time before a major change in procedure such as service redesign, and after, with scores collected weekly over a 10 month period
max heart rate during exercise (per session) for a patient going through pulmonary rehab over a 14 week period
travel time to work before, during and after a road widening scheme

Draw a Run Chart
If it shows a change, then you can consider comparing averages using typically Student's t test for the average before and the average after

 

Compare pairs of values
For example:

BMIs (Body Mass Indexs) vs Blood Pressures of a whole lot of people
Cost vs Tariff price
Patient Survey satisfaction score vs Practice List size for GP practices

Plot a scatter graph
if you can see a pattern emerging in the scatter graph, then

calculate the Correlation Coefficient and regression line
possibly plan to do root cause analysis or design an experiment to determine if there's a causative relationship between the values

Plot a bubble graph or Boston Matrix
Only use these fancy illustrations if you have particular kinds of data,
for example Opportunity/ Cost for a series of projects. Bubble graphs can be used to show a third dimension of data (eg adding the waist circumference to the BMI vs Blood Pressure graph) but generally makes it all look very complicated with more than about 10 data points.

 

Comments

Recent Additions and Updates

The 10 Commandments in Professional Services (1-5)

Keywords:

Two greatest commandsThe Ten Commandments apply just as firmly in each aspect of our daily life as they apply to the whole of our lives.  I'm a management consultant, and on this page I explain how the first five of the Ten Commandments apply to management consulting and professional services.

Getting GPs involved in Clinical Commissioning Groups (CCG)

Life in the YearsMost healthcare providers, in UK the same as everywhere else, get paid for each activity they do.  If someone needs care, they get paid.  If someone is well, they don’t.  So there isn’t much incentive (for the healthcare provider) to keep people well, even though it is much better for the person, much better for the nation, and much lower cost.  Minney.org Ltd is working with one CCG to generate enthusiasm and involvement, and the results are fairly successful….

Clinical Commissioning Groups and the NHS

Commissioning Innovation

As we race forwards into clinical commissioning, there are lessons to be learnt from other people.  The latest book “The Innovator’s Prescription: A Disruptive Solution for Health Care” by Christensen, Grossman and Hwang points to some things we need to take account of. It makes good reading . . .

Getting GPs involved in GP Commissioning

Clinical Commissioning Groups (CCG)GPs know the most about the patients registered with them, and have the biggest incentives to innovate and to commission better services. So why aren't they embracing Clinical Commissioning and using it to improve healthcare right across the country?

It could be any of a number of reasons, and we believe it's about understanding.  What's more, with our experience of doing exactly this (supporting GPs to get engaged), we can demonstrate how we've made a difference, and how it could work for other CCGs.

The Politics of CCGs

Clinical Commissioning

Clinical Commissioning Groups (CCG), the organisations that will commission  healthcare for nearly 60million people across England at a value of around £70billion, are beginning to take shape.

They come in essentially three types, and if you want to supply healthcare to these CCGs, even if you are an established provider of healthcare, you need to understand what you are dealing with