Need help with Excel? Here are some Excel help Videos! https://www.burkeyacademy.com/excel

Stats:  Basics

Stats Intro Vocabulary 1 Boring but necessary stats vocabulary (First half): e.g. Qualitative, categorical, parameter, statistic, ratio vs. interval data, etc.

Stats Intro Vocabulary 2 Continuation of above

(OLD) Stats Tables and Graphs 1  Frequency Distribution, Graphing Categorical data, Bar Graph, Excel pivot table

(OLD) Stats Tables and Graphs 2  Frequency Distribution, Graphing Quantitative data, Excel pivot table, Histogram.

Categorical Data in Excel 2016: Update Here we make frequency distributions two ways: First using the COUNTIF function, and then using a Pivot Table.

Quantitative Data in Excel 2016:Frequency and Histogram Using Quantitative Data to create a Frequency Distribution, and graph a Histogram using Excel 2016 pivot table.

More on Histograms:   Accurate Limits   Add Normal Curve

Two additional videos on making Histograms:In the first we talk about how to force Excel to label the endpoints of our classes properly.  In the second, we talk about how to add a Normal distribution curve to an existing histogram. Both are pains to do, but here it is in case you need it.

Quantitative Data and CUMULATIVE distributions in Excel 2016 In this video we make a Cumulative Frequency Distribution, and make a graph of an Ogive.

Crosstabulations in Excel 2016 Here we use Excel's PivotTable feature to make a cross-tabulation in Excel.

Making Scatterplots and Trendlines How to make and understand scatterplots and trendlines in Excel 2016.

How to ID a point in a Scatterplot I show a couple of quick ways to find a scatter plot point in your data set.

Stats:  Numerical Descriptive Statistics

Mean, Median, Mode Some details about how to find and interpret the mean, median, and mode.

Percentiles, Quartiles, and Simple Box Plots How to calculate and interpret percentiles, quartiles, range, interquartile range, and make a simple boxplot.

Dispersion: Variance, Std. Dev. Etc. Here we calculate variance, standard deviation, coefficient of variation, range, and interquartile range.

Skewness and Kurtosis How to think about skewness and Kurtosis Measures 

Stats:  Introduction to Probability

Intro Probability A  Preliminary rules and symbols used in probability

Intro Probability B Complement and addition rules for probability

Intro Probability C Conditional probability rule, multiplication rule, and statistical independence.

Intro Probability D Multiplication rule for independent events, and what I call Burkey's rule of common sense for probability.

Intro Probability E Using probability rules with a joint probability table: Calculating unions, finding intersections and marginal probabilities in a table.

Intro Probability F Using a joint probability table to calculate conditional probabilities, and check for statistical independence.

Probability G Bayes Rule A derivation of Bayes' rule, a numerical example so that you can see WHY it works, and an example calculation using drug tests.

Stats: Discrete Probability Distributions 

(Tables, Poisson, Binomial, and Hypergeometric)

Discrete Numeric Probability Distributions Overview  An overview of what a discrete numeric probability distribution is, and three examples: the Poisson, binomial, and hypergeometric. I just give an overview here, no formulas. Further videos focus on each distribution individually.

Basic Formulas for Discrete Distributions Mean, Variance, and Standard Deviation for discrete probability distributions, working with tables.

Poisson  The Poisson probability distribution and how it works.

Binomial The binomial probability distribution and how to use it.

Hypergeometric The hypergeometric probability distribution and how to use it. An example using cards is given.

Discrete Distributions: Applications with Lottery Tickets

Scratchers Basic Formulas applied to Scratch-Off Style Tickets

Pick Three and Pick Four The Binomial Distribution, to analyze Pick 3 and Pick 4 tickets (each balled pulled from separate urns)

Lotto The Hypergeometric Distribution to Analyze multiple balls pulled from one urn.

Stats: Continuous Probability Distributions (Uniform, Normal, Exponential) 

Continuous Uniform Distribution Calculations Introduction to continuous distributions; how to solve problems with the continuous Uniform distribution. Includes variance, standard deviation, expected value, and probability calculations.

Uniform distribution variance: Why the 12? Everyone who studies the uniform distribution wonders: Where does the 12 come from in (b-a)^2/12? Here I show you!

Normal Distribution Intro Here we take an introductory look at the Normal distribution and the Empirical Rule.

Normal Dist. Calculations 1: Finding Probailities  How to use a z score table and solve basic problems like: Given an x, what is the probability of being more than x? Or less than x? Or between 2 x's?

Normal Calcs 2: Finding X's  Here we do what I call a "backward problem": given a probability, find the x value that would result in that probability.

Normal Dist. Calcs 3: Finding Two Symmetric X's with Alpha  Here we solve a common problem: Given that say, 95% is in the middle of the normal distribution, how do I find two x's the same distance on either side?  I introduce the concept of Alpha here, the probability that "ain't in the middle" 

Introduction to Sampling Distributions

Introduction to Sampling Distributions- Central Limit Theorem and LLN Here we introduce the idea of a sampling distribution and what they are about.  I also discuss the meaning of the central limit theorem and the law of large numbers-- two commonly confused ideas.

Sampling Distribtion: Means and Standard Errors Here we calculate some problems with sample means and sampling distributions.

Sampling Distribution: Proportions Here we calculate some problems with sample proportion sampling distributions.

How to Make Confidence Intervals

Confidence Intervals: An Introduction Here is an overview of the ides of a confidence interval, and some of the terminology used.

Confidence Intervals for Means Here we focus on doing confidence intervals for means, with an introduction to the t distribution.

Confidence intervals for means: Practice Problem Here we do a practice problem making confidence intervals for means with both the t and z, and discuss why you use each.

Confidence Intervals for Proportions Here we look at how to make confidence intervals for proportions.

Crash Course (or Review) of Hypothesis Testing

Review of Hypothesis Testing1 Review of basic statistical ideas needed for hypothesis testing: deviation, standard deviation, empirical rule, and z scores.

Review of Hyp.Testing2 An overview of the idea behind hypothesis testing.

Review of Hyp.Testing3 Standard errors, and a z test of proportions for coin flipping data.

Review of Hypothesis Testing 4 z  Review of several kinds of z-based hypothesis tests, z test for one proportion, two proportions, 1 mean, and two means.

Review of Hypothesis Testing5 t  A comparison of many different types of t tests that you might see, and how they are similar. Hypothesis testing using a t with one mean, paired t tests, and two independent samples.

Review of Hypothesis Testing6 x2    A review of what the chi square distribution is, and 3 common chi square tests. Testing a sample variance, test of independence (contingency table), and a goodness of fit test.

Review of Hyp.Testing6 x2  confidence interval Using a chi-square distribution to make a confidence interval for a population variance based on a sample variance.

Review of Hypothesis Testing7 F Introduction to the F distribution and F tests: Comparing two sample variances and a One-Way Anova.