Stats in Excel 1: Tidy Data Sets & Descriptive Statistics

Learn how to set up your spreadsheets, clean your data, choose appropriate analyses, and conduct common descriptive statistics in Microsoft Excel.

This self-paced course offers best practices and step-by-step instructions for getting the most out of your data in Excel.  The course’s instructional videos and examples using real datasets allow you to practice these new skills.

Course Objectives:

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

• Follow dataset best practices to make data retrieval, cleaning and analysis easier;
• Use spreadsheet best practices and some features of Excel to ensure data quality assurance and quality control; and
• Select from and use various descriptive statistics to be able to calculate values and determine conclusions.

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 have three months to complete the course, starting from the date of purchase.