Statistics Videos for elementary statistics:

I’m currently working on a slew of statistics videos for this site. Right now, you’ll find videos of the most popular topics plus a range of videos on Microsoft Excel (including Excel 2013) Subscribe to my Youtube Channel so you can receive updates about new videos.

### Basics

- What is Elementary Statistics?
- How to Tell The Difference Between a Statistics vs. Parameter
- What is the Mean, Mode, Median

### Descriptive Statistics

- How To Find an Interquartile Range
- How to Find Outliers
- How to Make a Frequency Distribution Table
- How to Draw a Cumulative Frequency Distribution Table
- How to Find a 5 Number Summary
- How to Find the Variance and Standard Deviation
- How to Find Standard Error

### Probability

### Confidence Intervals

### Regression

### Hypothesis Testing

- What is the Null Hypothesis?
- How to Use Slovin’s Formula
- How to Use Chebyshev’s Thoerem
- How to Calculate an Alpha Level
- How to Find a Critical Value
- How to Calculate a z-score.
- What is an F-Table
- How to Read a Critical Value Chi Square Table
- How to Calculate a Chi-Square Statistic.
- How to Test a Chi-Square Hypothesis

### Microsoft Excel

- How to Use the Random Number Generator in Excel
- How to Make a Box and Whiskers Graph in Excel
- How to Find the Sample Variance in Excel
- How to Find the Median in Excel
- How to Make a Pie Chart in Excel
- How to Make a Scatter Plot in Excel 2007
- How to Make a Bar Graph in Excel 2007
- How to Find the Mean in Excel
- How to Find a Standard Deviation in Excel 2007
- How to Calculate the Mode in Excel
- How to Calculate a Z Score in Excel 2007/2010
- How to Calculate a Chi Square P-Value in Excel.
- How to Calculate a Moving Average in Excel
- How to Make a Histogram in Excel 2013
- How to perform a one-way ANOVA Excel 2013
- How to Perform a Two Way ANOVA in Excel 2013 with replication / without replication
- How to find Covariance in Excel 2013
- How to Calculate Correlation in Excel 2013
- How to Find Kurtosis Excel 2013
- How to Find a Range in Excel 2013
- How to Sum in Excel 2013
- How to Find Standard Deviation in Excel 2013
- How to Find the Mode in Excel 2013
- How to Find Standard Error in Excel 2013
- How to Find a Mean in Excel 2013
- How to Load the Data analysis Toolpak in Excel 2013
- How to find Kurtosis Excel 2013
- How to Find Sample Variance Excel 2013
- How to Perform Exponential Smoothing Excel 2013
- How to run a two sample f test for Variance in Excel 2013
- How to Run Fourier Analysis Excel 2013
- How to Find a Moving Average in Excel 2013
- How to Make an Excel Pivot Table
- How to use Excel Sampling to find a Sample
- How to do a T Test in Excel
- How to perform Excel 2013 Regression analysis
- How to use the Excel PERCENTILE function and Excel PERCENTRANK function
- How to Use the Excel RANK function (Excel 2013)

### Excel 2013

### Minitab for Statistics Articles

- How to Make a Time Plot in Minitab
- How To Create a Bar Graph in Minitab
- How to Make a Boxplot in Minitab
- How to Find Binomial Probabilities in Minitab
- How to Make a Histogram in Minitab
- How to Find an Interquartile Range in Minitab
- How to Find the Mean in Minitab
- How to Find the Median in Minitab
- How to Find the Mode in Minitab
- How to Create a Normal Probability Plot in Minitab
- How to Calculate Pearson’s Correlation Coefficient in Minitab
- How to Find Regression in Minitab
- How to Find the Standard Deviation in Minitab
- How to Make a Scatterplot in Minitab
- How to Find the Variance in Minitab

### Online Calculators

Statistics Videos was last modified: September 2nd, 2017 by

Is there any way that you can make a video or two regarding chi-squared statistics in relation to making tables that include counts, percents, significance tests, and such?

I ask because I have a homework problem which has really stumped me. It would be good motivation for a video.

Stratum Sampled claims Number not allowed

Small 57 6

Medium 17 5

Large 5 1

a) Construct the 3×2 table of counts for these data that includes the marginal totals.

b) Find the percent of claims that were not allowed in each of the three strata.

c) To perform a significant test, combine the medium and large strata. Explain why we do this.

d) State an appropriate null hypothesis to be tested for these data.

e) Perform the significance test and report your test with degrees of freedom and the P-value. State your conclusion.

Answers:

a) For example, in the “small” stratum, 51 claims were allowed, 6 were not allowed, and the total number of claims was 57. Altogether, there were 79 claims; 67 were allowed and 12 were not.

b) 10.5% (small claims), 29.4% (medium), and 20% (large) were not allowed.

c) In the 3×2 table, the expected count for large/not allowed is too small.

d) There is no relationship between claim size and whether a claim is allowed.

e) X^2 = 3.456, df = 1, P = 0.063.

Please and thank you! :D

Hi, Sterling,

Thanks for your suggestion! I’m working on videos now…I have quite a few requests to fill but I’ll see what I can do.

Regards,

S

Hello Stephanie! I came across your videos and I just wanted to thank you so much! They truly cleared up various questions I had. Keep up the excellent work!

Sincerely,

Nancy

Thank you for the kudos! Much appreciated :)