Easy Statistical Tests YOU Can Do in Excel to Compare Outcomes Between Groups
Rob Kallmeyer, PhD
Associate Professor Arts & Sciences
The Christ College of Nursing and Health Sciences
If you avoid conducting or discussing statistical research because it seems complicated, you’re not alone. However, there are many simple statistical tests YOU can conduct, right in Excel. All you need is a step-by-step guide on what to click. This workshop will show you two of the simplest and most common tests to compare group differences, such as comparing pre/post test scores or comparing survey results between two samples. I’ll guide you step-by-step through how to use this in your research, what to click in Excel, understanding the results, and creating a results statement and table for a peer-reviewed publication or presentation. Once you have data, you could have a results section completed in an afternoon, with time for a long lunch. This workshop is perfect for educational, behavioral science, and medical researchers who want to conduct, present, and understand statistical research.
1) Attendees will learn two tests to show statistically significant differences between two groups
2) Attendees will be able to conduct those statistical tests in Excel
3) Attendees will be able to create a results statement and table for a peer-reviewed
publication or presentation based on the Excel test results
Register on Faculty One Stop
The University of Cincinnati is accredited by the Accreditation Council for Continuing Medical Education (ACCME) to provide continuing medical education for physicians.
The University of Cincinnati designates this live activity for a maximum of 1 AMA PRA Category 1 Credit(s)™. Physicians should claim only the credit commensurate with the extent of their participation in the activity.