# How to Create a Residual Plot in Excel

A residual plot is a type of plot that displays the fitted values against the residual values for a regression model. This type of plot…

# How to Use the Poisson Distribution in Excel

The Poisson distribution is one of the most commonly used distributions in statistics. In Excel, we can use the POISSON.DIST() function to find the probability that…

# How to Use the Binomial Distribution in Excel

The binomial distribution is one of the most commonly used distributions in statistics. This tutorial explains how to use the following functions in Excel to solve questions…

# How to Create a Prediction Interval in R

A linear regression model can be useful for two things: (1) Quantifying the relationship between one or more predictor variables and a response variable. (2) Using the…

# Welch’s t-test: When to Use it + Examples

When we want to compare the means of two independent groups, we can choose between using two different tests: Student’s t-test: this test assumes that both…

# How to Create a Confidence Interval Using the F Distribution

To determine if the variances of two populations are equal, we can calculate the variance ratio σ21 / σ22, where σ21 is the variance of population 1 and σ22 is the…

# How to Read the F-Distribution Table

This tutorial explains how to read and interpret the F-distribution table. What is the F-Distribution Table? The F-distribution table is a table that shows the critical values…

# What is the Difference Between a T-test and an ANOVA?

This tutorial explains the difference between a t-test and an ANOVA, along with when to use each test. T-test A t-test is used to determine whether or not there…

# How to Create a t-Distribution Graph in Excel

A t-distribution is a type of continuous probability distribution. It has the following properties: It is continuous It is bell-shaped It is symmetric around zero…

# What is a Criterion Variable? (Explanation + Examples)

A criterion variable is simply another name for a dependent variable or a response variable. This is the variable that is being predicted in a statistical analysis. Just as explanatory…