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.
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.