This short course will provide an introductory, hands-on introduction to statistics used in educational research and evaluation. Participants will learn statistical concepts, principles, and procedures by building Excel spreadsheets from scratch in a guided learning approach using very short video-based tutorials. Examples of specific skills to be learned include scales or measurement, measures of central tendency, measures of variability, and the computation of the following: mean, mode, and median, standard deviation, z (standard) scores, Pearson product-moment correlation coefficient (r), dependent t test, and one-way analysis of variance (ANOVA). Read More.
The course is designed primarily for two audiences: 1) educational professionals who would like to be more informed about how to compute basic statistics and how to use them intelligently in their work; and 2) first-year doctoral students who want a short and friendly introduction (or brush up) to basic statistics before taking full graduate-level statistics courses. However, this course would be useful to anyone who wants a good short, hands-on, friendly, introduction to the most fundamental statistical ideas.
By the end of the course, you will know or be able to do the following:
Introduction to Statistics
- Scales of measurement
- Measures of Central Tendency: Mean, Median, & Mode
- The Normal Distribution
- How to compute a mean using Excel
- Measures of variability: Standard deviation
- Standard (z) scores
- How to compute the standard deviation using Excel
- How to compute a z score using Excel
- The difference between univariate and bivariate distributions
- The concept of correlation and the difference between positive and negative correlations
- How to compute a Pearson product-moment correlation coefficient (r) using Excel
- Hypothesis testing and the null hypothesis
- Statistical significance
- Independent and dependent variables
- How to compute a t-test value for an independent-samples design using Excel
- How to compute a t-test value for a correlated-samples design (i.e. dependent t test) using Excel
- Testing for differences between more than two means: The F distribution
- How to compute an analysis of variance (ANOVA) using Excel
Course is offered by Canvas Network.