### Course Resources Site

**By Dr. Justin Bateh**

Email: drbateh@gmail.com | Phone: 904.863.7051

### Course Content

Introduction, Defining and Collecting Data | Notes | PowerPoint |

Visualizing Data | Notes | PowerPoint |

Descriptive Statistics | Notes | PowerPoint |

Basic Probabilities | Notes | PowerPoint |

Binomial Distribution (Discrete) | Notes | PowerPoint |

Normal Distribution (Continuous) | Notes | PowerPoint |

Confidence Intervals / Sample Sizes | Notes | PowerPoint |

Introduction to Hypothesis Testing | Notes | PowerPoint |

One and Two Sample Hypothesis Testing | Notes | PowerPoint |

Analysis of Variance | Notes | PowerPoint |

Correlation and Regression | Notes | PowerPoint |

Chi Square Test for Independence | Notes |

### Practice Problems

T-Test Bank Problem | Problem | Solution |

T-Test Blood Samples Problem | Problem | Solution |

T-Test Class Type Difference Solution | Problem | Solution |

T-Test Phone Problem Solution | Problem | Solution |

Confidence Interval Problem | Problem | Solution |

Simple Regression Pet Food problem | Problem | Solution |

Simple Regression Pizza problem | Problem | Solution |

Simple Regression Potter Movies problem | Problem | Solution |

ANOVA Shift Changes | Problem | Solution |

### Statistics Video Demonstrations in Excel

*These videos are all posted on YouTube and in the public domain and are presented here to provide demonstration to topics covered inside and outside of this course as a supplemental to my lecture notes and screenshots. If, during your tenure in this course, you find other videos that may be helpful in addition to or in place of these, please feel free to share them with me as I will consider adding them to the video bank for future students. Thank you – Dr. Bateh*

- Installing the Analysis Took Pak
- Creating a Random List in Excel
- Creating Pie Carts
- Creating Bar Charts
- Creating Histograms
- Creating Pivot Table
- Descriptive Statistics in Excel (Measures of Central Tendency and Variation)
- Quartiles and Percentiles
- Quartiles and Percentiles
- Correlation and Scatter Plots
- Linear Regression

Simple Regression

Multivariate Regression - Two Sample T-Tests
- Confidence Interval
- Analysis of Variance
- Introduction to Statistics (11:56)

This video introduces statistics and data. - Introductory Statistics – Chapter 1: Introduction (9:05)

This video introduces you to the first chapter of an introductory statistics course. - Basic Statistics (10:13)

This video discusses basic statistics and its role in decision making. - How to Install the Data Analysis ToolPak in Microsoft Excel (2:05)

This tutorial explains how to install the Data Analysis ToolPak in Microsoft Excel. - Descriptive Statistics in Excel (2:39)

Learn how to use descriptive descriptions with the Excel ToolPak. - Normal Distributions (6:49)

This video provides a brief discussion of the normal and standard normal distributions including examples. - Calculating Descriptive Statistics in Excel (1:32)

This video provides a brief example of calculating descriptive statistics using Excel. - Correlation and Regression in MS Excel 2013 (20:22)

This video covers correlation and regression using Excel. - Linear Regression in Excel (6:32)

This video shows common mistakes you can make when using Excel to perform regression. - Confidence Intervals in Excel (1:49)

This video tutorial shows how to construct a confidence interval in Excel. - T-Test and P Value (6:20)

This video explains the t-test for one population using six steps. - One-Way ANOVA in Excel (2:33)

This video explains the one-way ANOVA using Excel. - Chi-Square Test of Independence in Excel (4:25)

This video shows how to use Excel for chi-square test for independence.

#### Other Resources

- How to Install Excel’s Analysis ToolPak

This article shows step-by-step instructions for installing the Analysis ToolPak for Excel. - Descriptive Statistics in Excel-Tutorial

This article discusses descriptive statistics. - Normal Distribution

This article has great examples of distributions. - The Excel Confidence Function

This webpage explains the confidence function. - T Hypothesis Test Example

Here is a sample hypothesis test with answers provided. - P Value Calculator for Student T-Test

This article provides a useful statistics online calculator for t-test. - One-Way ANOVA in Excel

This beginner statistics website explains the one-way ANOVA. - Chi-Square Test of Independence in Excel

This article shows several examples of chi-square tests.

#### Excel Template Files

These files are designed to help you complete problems. You cannot download and save them, but must download them each time from this site and use them directly here due to copyright restrictions. When you open them you will be asked for a password. Leave it blank and click “Read Only”. Then the files should work. You may need to click “Enable Editing” as well.

- Analysis of Variance
- Categorical Data Analysis
- Chi Square Testing
- Confidence Interval
- Correlation & Regression
- Descriptive Statistics
- Discrete Probability
- Frequency Distribution
- Hypothesis Testing for One Sample
- Hypothesis Testing for Two Samples
- Multiple Regression
- Normal Probability
- Sample Sizes
- Stem and Leaf Plot
- Tutorial for Pivot Tables