# Learn Statistics This Summer

## EDIT 6990E/4990E Topical Seminar in Learning, Design, & Technology

The University of Georgia
Thru Session (June 5 to July 17, 2017)

This is a special section of EDIT 6990/4990 that will focus almost exclusively on learning statistics. This course is designed for “mere mortals,” meaning that it is designed for people who want to know about and use statistics as but one important tool in their work, but who are not -- and don’t want to be -- mathematicians or statisticians. This course would be useful to anyone who wants a friendly, hands-on introduction to the most fundamental ideas of statistics in educational research and evaluation. The course was also designed with doctoral students in mind, especially those who are about to take their first bona fide statistics course. This course is based on Lloyd Rieber's award-winning MOOC "Statistics in Education for Mere Mortals" taken so far by over 5000 people worldwide.

Here's the approach… You build an Excel spreadsheet from scratch to compute each statistic covered in the course -- you learn the concepts, principles, and skills through the act of building, then you let Excel do the hard (and tedious) work of calculating. You can then use your spreadsheets to answer questions on all assessments.

## What will be covered?

Make no mistake, you will learn how to calculate a wide range of statistics in this course. Examples of specific skills to be learned include the scales of 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), correlated-samples t test (i.e. dependent t test), independent-samples t test, and a one-way analysis of variance (ANOVA).

## Not sure you can handle Excel?

Only the most basic Excel skills are needed. Still not sure? Check out this course video to find out. (And, it is fine to use Google Sheets instead of Excel.)
Statistics in Education for Mere Mortals: Computing a Mean with Excel