In: Statistics and Probability
a nursing student conducted a project at a physician's office. she took a medical history while the patient waited in the waiting room. she then reviewed the patient's medical record and retrieved the patient's medical record from the hospital used by the patient. she classified the patients into one of four groups.
1. the patients information matched the medical record
2. information that the patient had but the medical record did not contain
3. information in the medical record that the patient did not recall
4. information that was neither in the patient's recollection nor in the medical record
draw a cross table for this inserting the numbers 1-4 in the cells
Choices | Information with the patient | Information on the medical record | Sum of Choices | Information on the medical record | ||||
1 | yes | yes | Information with the patient | no | yes | Grand Total | ||
2 | yes | no | no | 4 | 3 | 7 | ||
3 | no | yes | yes | 2 | 1 | 3 | ||
4 | no | no | Grand Total | 6 | 4 | 10 |
Okay so for making this cross table what we did is that we broke down the conditions is two different situations which are information with the patient and information on the medical record.
for number 1 category we have the patients information matched the medical record and this is why I have written yes for both the situations that the information with the patient and the information on the medical record stating yes implies category 1.
for category 2 the information that the patient had but the medical record did not contain that is yes for the first situation and no for the second situation implies category 2.
For category 3 the information in the medical record that the patient did not recall that is no for first situation and yes for the second situation implies category 3.
For category 4 the information was neither in the patient's recollection nor in the medical record that is no for both the situations implying category 4.
This is how the cross table is drawn on paper.
Now to draw this cross table on your ms excel 2007 go to insert and on the top corner Left hand side you will see the option pivot table, choose the pivot table and a pop up box will appear asking you to select the information (it might be selected already) and then press ok. Then on the right side, drag the information with the patient below in the row label and information on the medical record in the column label and then choices in the value label and your data table will appear just like mine on the right hand side of the spreadsheet(pasted above)