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.