The basic table that we are going to use is in the Data worksheet.
But how do you draw charts like this? Use the following Excel workbook as an example to work through the steps.Ĭonfidence Interval Data. In this example, all of the consultants' confidence intervals overlap the centre line so we can't really say that any of them had a day case rate that was significantly above or below the average rate.
In other words, if we think of the data as being a sample, and if we were to take random samples, then in 95 of those samples the value would lie within the range of the upper and lower limits. General Surgery Age-standardized day case rates for 12 consultants, The blue dots represent each consultant's actual age-standardized rate. It shows 12 consultants' age-standardized day case rates expressed as a percentage compared with the overall hospital average day case rate. Here's an example of General Surgery in an acute hospital. Is it really that specific value or should you really draw a margin of error? Confidence intervals are indispensable when you want to show that you've taken account of random-ness. How to draw confidence interval charts in Microsoft Excel.
