Inferential and Descriptive Statistics in Excel

Course coming soon!

This course provides best practices for creating datasets and documentation, and step-by-step instructions to perform common statistical analyses using Excel.

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;
• Select from and use various descriptive and 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.

Prerequisites: Prior knowledge of evaluation and of descriptive and inferential statistics

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