17 Nov Data Analysis (Using Excel or SPSS)
A primary care clinic implemented a new hand hygiene education program. The dataset below represents pre- and post-compliance scores. Students must calculate descriptive statistics and perform a paired t-test. Dataset: Nurse ID | Pre-Compliance (%) | Post-Compliance (%) 01 | 52 | 84 02 | 60 | 88 03 | 55 | 90 04 | 48 | 79 05 | 65 | 92 06 | 50 | 83 07 | 58 | 85 08 | 62 | 91 Tasks: 1. Calculate mean, median, standard deviation (pre and post), percent change for each nurse, and total average change. 2. Conduct a paired t-test. 3. Report t-value, degrees of freedom, p-value, and interpretation.
Part 3 — Interpretation & Clinical Implications
Write a 1–2 page APA-style narrative addressing: 1. Interpretation of statistical results in plain language. 2. Whether the intervention was statistically significant. 3. Implications for clinical practice. 4. Three limitations of the analysis. 5. Recommendations for future evaluation.
Deliverables
Submit one Word document (.docx) including Part 2 calculations and outputs, and Part 3 narrative. APA 7th edition formatting is required.
Grading Criteria (Total 100 pts)
• Definitions & Conceptual Understanding – 20 pts • Accuracy of Calculations – 25 pts • Correct Statistical Test & Reporting – 30 pts • Interpretation & Clinical Implications – 20 pts • APA Formatting & Clarity – 5 pts
