How should I approach balancing the results of this data?

halesowenmum

Active Member
Joined
Oct 20, 2010
Messages
383
Office Version
  1. 365
Platform
  1. Windows
Hi

I've got a table showing %s of totals within the following categories:
  • Patients who after leaving hospital had an attempted telephone contact with a nurse but who were not contactable
  • Patients who after leaving hospital had contact with a nurse over the phone
  • Patients who after leaving hospital had contact with a nurse over the phone and via a home visit.

I'm viewing the uncontactable lot as my Control Group against which I compare how successful the telephone and the telephone and home visit interventions were. The assumption is that if you not only call someone but you also visit them at home they should be much less likely to come back in. However, firstly the patients picked to receive a phone call were picked because it was felt they had a low to moderate risk of readmitting, and for those who had home visits the entire reason for visiting them was because the clinician knew that they were much more likely to readmit (that's why they went to their house to visit them).

So comparing the phoned only against the couldn't contact and comparing phoned and seen at home against the couldn't contact, straight, isn't a fair comparison as the home visited group is more likely to readmit right from the outset.

I took the % of figures and calculated the number greater or less than the control group for both telephoned only and phoned and home visited. This is shown on the table below:

[TABLE="width: 775"]
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]BK[/TD]
[TD]BM[/TD]
[TD]BO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Did not readmit[/TD]
[TD]Readmitted once[/TD]
[TD]Readmitted more than once[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POSITIVE:
Obviously not readmitting is the ideal[/TD]
[TD]NEGATIVE:
If you're going to readmit readmitting once only isn't too bad[/TD]
[TD]NEGATIVE:
If you're going to readmit, readmitting more than once is the worst[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]141[/TD]
[TD]59.1%[/TD]
[TD]31.8%[/TD]
[TD]9.1%[/TD]
[TD]This row contains the Control Group %s of results[/TD]
[/TR]
[TR]
[TD]143[/TD]
[TD]78.8%[/TD]
[TD]19.7%[/TD]
[TD]1.5%[/TD]
[TD]This row contains the %s of results for those telephoned only[/TD]
[/TR]
[TR]
[TD]144[/TD]
[TD]1.33[/TD]
[TD]0.62[/TD]
[TD]0.17[/TD]
[TD]Greater/lesser than control group (row 141)[/TD]
[/TR]
[TR]
[TD]146[/TD]
[TD]58.8%[/TD]
[TD]35.3%[/TD]
[TD]5.9%[/TD]
[TD]This row contains the %s of results for those phoned and visited at home[/TD]
[/TR]
[TR]
[TD]147[/TD]
[TD]1.00[/TD]
[TD]1.11[/TD]
[TD]0.65[/TD]
[TD]Greater/lesser than control group (row 141)[/TD]
[/TR]
</tbody>[/TABLE]
Some givens:
  • At the point of initially selecting patients to call they all have roughly the same risk of readmission so before the telephone is picked up the playing field is level
  • Presumably the discussion over the phone for the ones the clinician was able to speak to will slightly reduce their risk of readmitting so you might expect to see a reduction in readmissions for these
  • The assumption is that those who have a phone call and a home visit must be way less likely to readmit - however as described below there are reasons why this is not the case.

Looking at the readmission rates:
  • Did Not Readmit rate and Readmitted Once rate for home visited patients are virtually the same as the Control Group
  • Those home visited were home visited because during the phone call it was noted that their responses and past medical history showed they were more than moderately likely to readmit (and that is why a home visit was conducted).

So my understanding therefore is that you can't compare these data 'cold' because they aren't like for like in terms of readmission risk.

I beg of whichever kindly soul takes on this question, please make your answer at the 'for Dummies' level as highly statistical analysis/data modelling equations and the like I just won't understand :)!

What I'd like advice on is which of the above numbers to adjust, by how much and what formula (just reduce by a particular % or by the difference or the difference x 2....).

Many thanks indeed.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top