## Introduction to Statistics with Excel

This section includes a complete introductory course on statistical analysis, using Excel as a (sophisticated) "stats calculator". No prior experience with Excel or Statistics is required, the course is completely self-contained. Have fun, and |

### 1. Introduction

### 2. Using Microsoft Excel

- What is Excel
- Creating, saving, and retrieving data
- Calculations with Spreadsheet Data
- Installing the Analysis Pak
- Quiz

### 3. Graphical Data Representation

- What is graphical data representation
- Creating Pie Charts
- Creating Bar Charts
- Frequency Histograms
- Bending the Rules
- Bar Charts for Categorical Data
- Quiz

### 4. Numerical Data Representation

- What is numerical data representation
- Measures of Central Tendency: Mean, Median, and Mode
- How to select Random Samples
- Measures of Variability: Range, Variance, and Standard Deviation
- Quartiles and Percentiles
- Box Plot and Skewed Distributions
- Descriptive Statistics in Excel
- Quiz

### 5. Percentage Tables and Crosstabs

- Frequency Histograms for Categorical Variables
- Percentage Tables
- Crosstabs Tables
- The Chi-Square Test for Categorical Crosstabs
- Quiz

### 6. Relations between Variables

### 7. Estimation

- The Normal Distribution and its Relatives
- The Central Limit Theorem
- Confidence Intervals for Means
- Quiz