Week 5_ ANALYSIS OF QUANTITATIVE DATA

ligiarivera

Main

Home >Homework Answsers >Nursing homework help

Please review the complete instructions.

3 years ago
28.09.2023
20

Report issue

files (3)

Codebook_QuantitativePatientSafetyData_Week5.pdf
Instructions_NURS_3150_Week5_Quantitative_SummaryDataAnalysisForm.docx
QuantitativeDataExcelAssignment_Week5.xlsx

Codebook_QuantitativePatientSafetyData_Week5.pdf

Week 5: Quantitative Analysis Assignment

Code Book: Quantitative Patient Safety Data

Column

Variable Name

Description

Response Categories

A ID Unique patient identification number

B AGE Age of patient in years

C GENDER Sex of patient 1 = female; 2 = male

D EDUC Educational level of patient Education in years completed

E UNIT Inpatient hospital unit 1 = medical unit 1 2 = medical unit 2

F DX Primary diagnosis of patient when admitted to medical unit

1 = congestive heart failure 2 = pneumonia 3 = chronic obstructive pulmonary disease 4 = diabetes 5 = R/O myocardial infarction 6 = other

G FALLS Reported fall during hospitalization 0 = no fall 1 = fell

H CAUTI Reported catheter-associated urinary tract infection

0 = no CAUTI 1 = CAUTI

I RXERR Reported medication error during hospitalization

0 = no medication error 1 = medication error

J MRSA Reported methicillin-resistant Staphylococcus aureus (MRSA) infection

0 = no MRSA 1 = MRSA infection

Instructions_NURS_3150_Week5_Quantitative_SummaryDataAnalysisForm.docx

Week 5: Quantitative Analysis Assignment

Summary Data Analysis Form

Analysis 1:

What is the mean age of patients in the patient safety data set?

54.8 years

Analysis 2:

What percentage of patients were reported to have fallen during their hospitalization?

_ 38____ %

Analysis 3:

What percentage of patients reported catheter-associated urinary tract infections (CAUTIs) during their hospitalization?

__24___ %

Analysis 4:

What percentage of patients reported medication errors during their hospitalization?

_ 30__ %

Analysis 5:

What percentage of patients reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit?

__ 14___ %

Instructions:

Data Analysis

Summarize the findings from your analyses about these patient safety events that occurred in one month on the two medical units at this major urban hospital. What additional information would you need to help develop a plan to decrease the occurrence of these events? The summary should consist of a minimum of 400 words and should be two to three paragraphs. Citations should be used to support statements. After the summary, a reference section should be included.

References

List your own references in alphabetical order and in APA format. References should be published within the last five years. In your paper, be sure every reference entry matches a citation, and every citation refers to an item in the reference list.

QuantitativeDataExcelAssignment_Week5.xlsx

            Sheet1

            
                	
                        ID	
                        AGE	
                        GENDER	
                        EDUC	
                        UNIT	
                        DX	
                        FALL	
                        CAUTI	
                        RXERR	
                        MRSA
                    
	
                        1	
                        22	
                        1	
                        14	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        2	
                        57	
                        1	
                        16	
                        1	
                        5	
                        0	
                        0	
                        0	
                        0
                    
	
                        3	
                        48	
                        2	
                        13	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        4	
                        69	
                        1	
                        12	
                        1	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        5	
                        34	
                        2	
                        15	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        6	
                        76	
                        2	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        7	
                        63	
                        1	
                        15	
                        2	
                        1	
                        0	
                        1	
                        0	
                        0
                    
	
                        8	
                        52	
                        2	
                        16	
                        1	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        9	
                        55	
                        2	
                        12	
                        1	
                        1	
                        0	
                        1	
                        1	
                        0
                    
	
                        10	
                        58	
                        2	
                        11	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        11	
                        66	
                        1	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        12	
                        64	
                        1	
                        16	
                        1	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        13	
                        79	
                        2	
                        10	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        14	
                        73	
                        1	
                        8	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        15	
                        55	
                        2	
                        12	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        16	
                        63	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        17	
                        68	
                        2	
                        16	
                        1	
                        4	
                        1	
                        1	
                        0	
                        0
                    
	
                        18	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        19	
                        59	
                        1	
                        12	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        20	
                        25	
                        1	
                        13	
                        2	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        21	
                        35	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        22	
                        78	
                        2	
                        11	
                        1	
                        2	
                        1	
                        1	
                        0	
                        0
                    
	
                        23	
                        67	
                        2	
                        17	
                        2	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        24	
                        64	
                        1	
                        14	
                        1	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        25	
                        58	
                        2	
                        12	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        26	
                        71	
                        1	
                        10	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        27	
                        51	
                        1	
                        17	
                        2	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        28	
                        40	
                        1	
                        12	
                        2	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        29	
                        49	
                        2	
                        17	
                        1	
                        5	
                        0	
                        1	
                        0	
                        0
                    
	
                        30	
                        19	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        31	
                        45	
                        1	
                        13	
                        2	
                        4	
                        1	
                        0	
                        0	
                        0
                    
	
                        32	
                        93	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        33	
                        52	
                        1	
                        13	
                        2	
                        1	
                        0	
                        0	
                        1	
                        0
                    
	
                        34	
                        46	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        35	
                        18	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        36	
                        90	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        37	
                        49	
                        2	
                        16	
                        1	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        38	
                        79	
                        2	
                        12	
                        1	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        39	
                        23	
                        2	
                        14	
                        2	
                        2	
                        0	
                        0	
                        1	
                        0
                    
	
                        40	
                        87	
                        1	
                        11	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        41	
                        50	
                        2	
                        16	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        42	
                        24	
                        2	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        43	
                        75	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        44	
                        53	
                        1	
                        16	
                        2	
                        1	
                        0	
                        0	
                        0	
                        1
                    
	
                        45	
                        29	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        46	
                        66	
                        1	
                        13	
                        1	
                        1	
                        1	
                        1	
                        0	
                        0
                    
	
                        47	
                        31	
                        2	
                        12	
                        2	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        48	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        49	
                        33	
                        1	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        50	
                        19	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        	
                        54.8
                    

            

        

            Sheet2

            
                
            

        

            Sheet3

            
                
            

        

QuantitativeDataExcelAssignment_Week5.xlsx

            Sheet1

            
                	
                        ID	
                        AGE	
                        GENDER	
                        EDUC	
                        UNIT	
                        DX	
                        FALL	
                        CAUTI	
                        RXERR	
                        MRSA
                    
	
                        1	
                        22	
                        1	
                        14	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        2	
                        57	
                        1	
                        16	
                        1	
                        5	
                        0	
                        0	
                        0	
                        0
                    
	
                        3	
                        48	
                        2	
                        13	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        4	
                        69	
                        1	
                        12	
                        1	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        5	
                        34	
                        2	
                        15	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        6	
                        76	
                        2	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        7	
                        63	
                        1	
                        15	
                        2	
                        1	
                        0	
                        1	
                        0	
                        0
                    
	
                        8	
                        52	
                        2	
                        16	
                        1	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        9	
                        55	
                        2	
                        12	
                        1	
                        1	
                        0	
                        1	
                        1	
                        0
                    
	
                        10	
                        58	
                        2	
                        11	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        11	
                        66	
                        1	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        12	
                        64	
                        1	
                        16	
                        1	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        13	
                        79	
                        2	
                        10	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        14	
                        73	
                        1	
                        8	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        15	
                        55	
                        2	
                        12	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        16	
                        63	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        17	
                        68	
                        2	
                        16	
                        1	
                        4	
                        1	
                        1	
                        0	
                        0
                    
	
                        18	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        19	
                        59	
                        1	
                        12	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        20	
                        25	
                        1	
                        13	
                        2	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        21	
                        35	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        22	
                        78	
                        2	
                        11	
                        1	
                        2	
                        1	
                        1	
                        0	
                        0
                    
	
                        23	
                        67	
                        2	
                        17	
                        2	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        24	
                        64	
                        1	
                        14	
                        1	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        25	
                        58	
                        2	
                        12	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        26	
                        71	
                        1	
                        10	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        27	
                        51	
                        1	
                        17	
                        2	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        28	
                        40	
                        1	
                        12	
                        2	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        29	
                        49	
                        2	
                        17	
                        1	
                        5	
                        0	
                        1	
                        0	
                        0
                    
	
                        30	
                        19	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        31	
                        45	
                        1	
                        13	
                        2	
                        4	
                        1	
                        0	
                        0	
                        0
                    
	
                        32	
                        93	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        33	
                        52	
                        1	
                        13	
                        2	
                        1	
                        0	
                        0	
                        1	
                        0
                    
	
                        34	
                        46	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        35	
                        18	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        36	
                        90	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        37	
                        49	
                        2	
                        16	
                        1	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        38	
                        79	
                        2	
                        12	
                        1	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        39	
                        23	
                        2	
                        14	
                        2	
                        2	
                        0	
                        0	
                        1	
                        0
                    
	
                        40	
                        87	
                        1	
                        11	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        41	
                        50	
                        2	
                        16	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        42	
                        24	
                        2	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        43	
                        75	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        44	
                        53	
                        1	
                        16	
                        2	
                        1	
                        0	
                        0	
                        0	
                        1
                    
	
                        45	
                        29	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        46	
                        66	
                        1	
                        13	
                        1	
                        1	
                        1	
                        1	
                        0	
                        0
                    
	
                        47	
                        31	
                        2	
                        12	
                        2	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        48	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        49	
                        33	
                        1	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        50	
                        19	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        	
                        54.8
                    

            

        

            Sheet2

            
                
            

        

            Sheet3

            
                
            

        

Codebook_QuantitativePatientSafetyData_Week5.pdf

Week 5: Quantitative Analysis Assignment

Code Book: Quantitative Patient Safety Data

Column

Variable Name

Description

Response Categories

A ID Unique patient identification number

B AGE Age of patient in years

C GENDER Sex of patient 1 = female; 2 = male

D EDUC Educational level of patient Education in years completed

E UNIT Inpatient hospital unit 1 = medical unit 1 2 = medical unit 2

F DX Primary diagnosis of patient when admitted to medical unit

1 = congestive heart failure 2 = pneumonia 3 = chronic obstructive pulmonary disease 4 = diabetes 5 = R/O myocardial infarction 6 = other

G FALLS Reported fall during hospitalization 0 = no fall 1 = fell

H CAUTI Reported catheter-associated urinary tract infection

0 = no CAUTI 1 = CAUTI

I RXERR Reported medication error during hospitalization

0 = no medication error 1 = medication error

J MRSA Reported methicillin-resistant Staphylococcus aureus (MRSA) infection

0 = no MRSA 1 = MRSA infection

Instructions_NURS_3150_Week5_Quantitative_SummaryDataAnalysisForm.docx

Week 5: Quantitative Analysis Assignment

Summary Data Analysis Form

Analysis 1:

What is the mean age of patients in the patient safety data set?

54.8 years

Analysis 2:

What percentage of patients were reported to have fallen during their hospitalization?

_ 38____ %

Analysis 3:

What percentage of patients reported catheter-associated urinary tract infections (CAUTIs) during their hospitalization?

__24___ %

Analysis 4:

What percentage of patients reported medication errors during their hospitalization?

_ 30__ %

Analysis 5:

What percentage of patients reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit?

__ 14___ %

Instructions:

Data Analysis

References

QuantitativeDataExcelAssignment_Week5.xlsx

            Sheet1

            
                	
                        ID	
                        AGE	
                        GENDER	
                        EDUC	
                        UNIT	
                        DX	
                        FALL	
                        CAUTI	
                        RXERR	
                        MRSA
                    
	
                        1	
                        22	
                        1	
                        14	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        2	
                        57	
                        1	
                        16	
                        1	
                        5	
                        0	
                        0	
                        0	
                        0
                    
	
                        3	
                        48	
                        2	
                        13	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        4	
                        69	
                        1	
                        12	
                        1	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        5	
                        34	
                        2	
                        15	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        6	
                        76	
                        2	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        7	
                        63	
                        1	
                        15	
                        2	
                        1	
                        0	
                        1	
                        0	
                        0
                    
	
                        8	
                        52	
                        2	
                        16	
                        1	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        9	
                        55	
                        2	
                        12	
                        1	
                        1	
                        0	
                        1	
                        1	
                        0
                    
	
                        10	
                        58	
                        2	
                        11	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        11	
                        66	
                        1	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        12	
                        64	
                        1	
                        16	
                        1	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        13	
                        79	
                        2	
                        10	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        14	
                        73	
                        1	
                        8	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        15	
                        55	
                        2	
                        12	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        16	
                        63	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        17	
                        68	
                        2	
                        16	
                        1	
                        4	
                        1	
                        1	
                        0	
                        0
                    
	
                        18	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        19	
                        59	
                        1	
                        12	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        20	
                        25	
                        1	
                        13	
                        2	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        21	
                        35	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        22	
                        78	
                        2	
                        11	
                        1	
                        2	
                        1	
                        1	
                        0	
                        0
                    
	
                        23	
                        67	
                        2	
                        17	
                        2	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        24	
                        64	
                        1	
                        14	
                        1	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        25	
                        58	
                        2	
                        12	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        26	
                        71	
                        1	
                        10	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        27	
                        51	
                        1	
                        17	
                        2	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        28	
                        40	
                        1	
                        12	
                        2	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        29	
                        49	
                        2	
                        17	
                        1	
                        5	
                        0	
                        1	
                        0	
                        0
                    
	
                        30	
                        19	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        31	
                        45	
                        1	
                        13	
                        2	
                        4	
                        1	
                        0	
                        0	
                        0
                    
	
                        32	
                        93	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        33	
                        52	
                        1	
                        13	
                        2	
                        1	
                        0	
                        0	
                        1	
                        0
                    
	
                        34	
                        46	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        35	
                        18	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        36	
                        90	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        37	
                        49	
                        2	
                        16	
                        1	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        38	
                        79	
                        2	
                        12	
                        1	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        39	
                        23	
                        2	
                        14	
                        2	
                        2	
                        0	
                        0	
                        1	
                        0
                    
	
                        40	
                        87	
                        1	
                        11	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        41	
                        50	
                        2	
                        16	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        42	
                        24	
                        2	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        43	
                        75	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        44	
                        53	
                        1	
                        16	
                        2	
                        1	
                        0	
                        0	
                        0	
                        1
                    
	
                        45	
                        29	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        46	
                        66	
                        1	
                        13	
                        1	
                        1	
                        1	
                        1	
                        0	
                        0
                    
	
                        47	
                        31	
                        2	
                        12	
                        2	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        48	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        49	
                        33	
                        1	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        50	
                        19	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        	
                        54.8
                    

            

        

            Sheet2

            
                
            

        

            Sheet3

            
                
            

        

Codebook_QuantitativePatientSafetyData_Week5.pdf

Week 5: Quantitative Analysis Assignment

Code Book: Quantitative Patient Safety Data

Column

Variable Name

Description

Response Categories

A ID Unique patient identification number

B AGE Age of patient in years

C GENDER Sex of patient 1 = female; 2 = male

D EDUC Educational level of patient Education in years completed

E UNIT Inpatient hospital unit 1 = medical unit 1 2 = medical unit 2

F DX Primary diagnosis of patient when admitted to medical unit

1 = congestive heart failure 2 = pneumonia 3 = chronic obstructive pulmonary disease 4 = diabetes 5 = R/O myocardial infarction 6 = other

G FALLS Reported fall during hospitalization 0 = no fall 1 = fell

H CAUTI Reported catheter-associated urinary tract infection

0 = no CAUTI 1 = CAUTI

I RXERR Reported medication error during hospitalization

0 = no medication error 1 = medication error

J MRSA Reported methicillin-resistant Staphylococcus aureus (MRSA) infection

0 = no MRSA 1 = MRSA infection

Instructions_NURS_3150_Week5_Quantitative_SummaryDataAnalysisForm.docx

Week 5: Quantitative Analysis Assignment

Summary Data Analysis Form

Analysis 1:

What is the mean age of patients in the patient safety data set?

54.8 years

Analysis 2:

What percentage of patients were reported to have fallen during their hospitalization?

_ 38____ %

Analysis 3:

What percentage of patients reported catheter-associated urinary tract infections (CAUTIs) during their hospitalization?

__24___ %

Analysis 4:

What percentage of patients reported medication errors during their hospitalization?

_ 30__ %

Analysis 5:

What percentage of patients reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit?

__ 14___ %

Instructions:

Data Analysis

References

QuantitativeDataExcelAssignment_Week5.xlsx

            Sheet1

            
                	
                        ID	
                        AGE	
                        GENDER	
                        EDUC	
                        UNIT	
                        DX	
                        FALL	
                        CAUTI	
                        RXERR	
                        MRSA
                    
	
                        1	
                        22	
                        1	
                        14	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        2	
                        57	
                        1	
                        16	
                        1	
                        5	
                        0	
                        0	
                        0	
                        0
                    
	
                        3	
                        48	
                        2	
                        13	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        4	
                        69	
                        1	
                        12	
                        1	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        5	
                        34	
                        2	
                        15	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        6	
                        76	
                        2	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        7	
                        63	
                        1	
                        15	
                        2	
                        1	
                        0	
                        1	
                        0	
                        0
                    
	
                        8	
                        52	
                        2	
                        16	
                        1	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        9	
                        55	
                        2	
                        12	
                        1	
                        1	
                        0	
                        1	
                        1	
                        0
                    
	
                        10	
                        58	
                        2	
                        11	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        11	
                        66	
                        1	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        12	
                        64	
                        1	
                        16	
                        1	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        13	
                        79	
                        2	
                        10	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        14	
                        73	
                        1	
                        8	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        15	
                        55	
                        2	
                        12	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        16	
                        63	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        17	
                        68	
                        2	
                        16	
                        1	
                        4	
                        1	
                        1	
                        0	
                        0
                    
	
                        18	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        19	
                        59	
                        1	
                        12	
                        1	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        20	
                        25	
                        1	
                        13	
                        2	
                        2	
                        0	
                        0	
                        0	
                        1
                    
	
                        21	
                        35	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        22	
                        78	
                        2	
                        11	
                        1	
                        2	
                        1	
                        1	
                        0	
                        0
                    
	
                        23	
                        67	
                        2	
                        17	
                        2	
                        3	
                        1	
                        0	
                        0	
                        0
                    
	
                        24	
                        64	
                        1	
                        14	
                        1	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        25	
                        58	
                        2	
                        12	
                        2	
                        5	
                        1	
                        0	
                        0	
                        0
                    
	
                        26	
                        71	
                        1	
                        10	
                        2	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        27	
                        51	
                        1	
                        17	
                        2	
                        5	
                        0	
                        0	
                        1	
                        0
                    
	
                        28	
                        40	
                        1	
                        12	
                        2	
                        3	
                        0	
                        0	
                        0	
                        1
                    
	
                        29	
                        49	
                        2	
                        17	
                        1	
                        5	
                        0	
                        1	
                        0	
                        0
                    
	
                        30	
                        19	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        31	
                        45	
                        1	
                        13	
                        2	
                        4	
                        1	
                        0	
                        0	
                        0
                    
	
                        32	
                        93	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        33	
                        52	
                        1	
                        13	
                        2	
                        1	
                        0	
                        0	
                        1	
                        0
                    
	
                        34	
                        46	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        35	
                        18	
                        2	
                        12	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        36	
                        90	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        37	
                        49	
                        2	
                        16	
                        1	
                        4	
                        0	
                        0	
                        0	
                        1
                    
	
                        38	
                        79	
                        2	
                        12	
                        1	
                        1	
                        1	
                        0	
                        0	
                        0
                    
	
                        39	
                        23	
                        2	
                        14	
                        2	
                        2	
                        0	
                        0	
                        1	
                        0
                    
	
                        40	
                        87	
                        1	
                        11	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        41	
                        50	
                        2	
                        16	
                        2	
                        3	
                        0	
                        0	
                        1	
                        0
                    
	
                        42	
                        24	
                        2	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        43	
                        75	
                        1	
                        8	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        44	
                        53	
                        1	
                        16	
                        2	
                        1	
                        0	
                        0	
                        0	
                        1
                    
	
                        45	
                        29	
                        1	
                        16	
                        2	
                        4	
                        0	
                        0	
                        1	
                        0
                    
	
                        46	
                        66	
                        1	
                        13	
                        1	
                        1	
                        1	
                        1	
                        0	
                        0
                    
	
                        47	
                        31	
                        2	
                        12	
                        2	
                        4	
                        0	
                        1	
                        0	
                        0
                    
	
                        48	
                        80	
                        1	
                        12	
                        1	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        49	
                        33	
                        1	
                        12	
                        2	
                        2	
                        1	
                        0	
                        0	
                        0
                    
	
                        50	
                        19	
                        2	
                        13	
                        1	
                        2	
                        0	
                        1	
                        0	
                        0
                    
	
                        	
                        54.8
                    

            

        

            Sheet2

            
                
            

        

            Sheet3

            
                
            

        

other Questions(10)

ID	AGE	GENDER	EDUC	UNIT	DX	FALL	CAUTI	RXERR	MRSA
1	22	1	14	1	2	0	1	0	0
2	57	1	16	1	5	0	0	0	0
3	48	2	13	1	5	0	0	1	0
4	69	1	12	1	3	1	0	0	0
5	34	2	15	2	4	0	0	1	0
6	76	2	12	2	2	1	0	0	0
7	63	1	15	2	1	0	1	0	0
8	52	2	16	1	2	0	0	0	1
9	55	2	12	1	1	0	1	1	0
10	58	2	11	2	5	1	0	0	0
11	66	1	12	2	4	0	0	1	0
12	64	1	16	1	4	0	1	0	0
13	79	2	10	2	2	1	0	0	0
14	73	1	8	2	3	0	0	1	0
15	55	2	12	2	1	1	0	0	0
16	63	2	13	1	2	0	1	0	0
17	68	2	16	1	4	1	1	0	0
18	80	1	12	1	2	1	0	0	0
19	59	1	12	1	5	0	0	1	0
20	25	1	13	2	2	0	0	0	1
21	35	1	16	2	4	0	0	1	0
22	78	2	11	1	2	1	1	0	0
23	67	2	17	2	3	1	0	0	0
24	64	1	14	1	3	0	0	0	1
25	58	2	12	2	5	1	0	0	0
26	71	1	10	2	1	1	0	0	0
27	51	1	17	2	5	0	0	1	0
28	40	1	12	2	3	0	0	0	1
29	49	2	17	1	5	0	1	0	0
30	19	2	12	2	4	0	0	1	0
31	45	1	13	2	4	1	0	0	0
32	93	1	8	1	2	1	0	0	0
33	52	1	13	2	1	0	0	1	0
34	46	1	16	2	4	0	0	0	1
35	18	2	12	2	4	0	0	1	0
36	90	1	8	1	2	1	0	0	0
37	49	2	16	1	4	0	0	0	1
38	79	2	12	1	1	1	0	0	0
39	23	2	14	2	2	0	0	1	0
40	87	1	11	1	2	0	1	0	0
41	50	2	16	2	3	0	0	1	0
42	24	2	16	2	4	0	0	1	0
43	75	1	8	1	2	1	0	0	0
44	53	1	16	2	1	0	0	0	1
45	29	1	16	2	4	0	0	1	0
46	66	1	13	1	1	1	1	0	0
47	31	2	12	2	4	0	1	0	0
48	80	1	12	1	2	1	0	0	0
49	33	1	12	2	2	1	0	0	0
50	19	2	13	1	2	0	1	0	0
	54.8