This course is a companion course to Stats in Excel 1: Tidy Datasets and Descriptive Statistics. If you are not already familiar with setting up datasets for conducting statistical analysis or descriptive statistics, we recommend you take Stats in Excel 1. This course also requires that you are familiar with some of the advanced features of Excel like setting up pivot tables and using functions. If you do not know how to do these things there are lots of how-to videos and instructions on the internet; just google what do you want to learn about.

Bundle price: We offer a discount of $100 off Stats in Excel 2 if you purchase both Stats in Excel 1 and 2 together. If you have previously purchased Stats in Excel 1, you are also eligible for the discount. Contact einstitute_mgr@evaluationcanada.ca to take advantage of this offer.

This self-paced course provides step-by-step instructions and best practices for performing common inferential statistical analyses using Microsoft Excel. You will learn some of the most common analyses used in evaluations including how to find associations between variables, testing for a linear relationship between variables, and comparing groups.

Course Objectives:

By the end of this course you will be able to:

• State the hypotheses for, and write conclusions for, eight types of inferential statistics tests;
• Select from and use various inferential statistics to be able to calculate values and determine conclusions; and
• Use built-in features of Excel or the Analysis Toolpak for Excel to conduct statistical analysis or create your own formulas where there are no built-in functions.

Estimated time to complete: 10 hours

Prerequisites: Prior knowledge of evaluation and of descriptive statistics

Evaluation Competencies addressed: [ ] reflective; [x] technical; [ ] situational; [ ] management; [ ] interpersonal

Note: For all self-paced courses on the e-Institute, you will be granted access once payment is received in full. You then have three months to complete the course starting from the date access is granted.