# How to Calculate Odds Ratio and Relative Risk in Excel

We often use the odds ratio and relative risk when performing an analysis on a 2-by-2 table, which takes on the following format: The odds ratio tells us the ratio of…

# How to Create and Interpret Box Plots in Excel

A box plot is a type of plot that we can use to visualize the five number summary of a dataset, which includes: The minimum The first…

# How to Perform Multiple Linear Regression in Excel

Multiple linear regression is a method we can use to understand the relationship between two or more explanatory variables and a response variable. This tutorial explains how…

# How to Perform Simple Linear Regression in Excel

Simple linear regression is a method we can use to understand the relationship between an explanatory variable, x, and a response variable, y. This tutorial explains how…

# How to Perform Fisher’s Exact Test in Excel

Fisher’s Exact Test is used to determine whether or not there is a significant association between two categorical variables. It is typically used as an alternative to…

# How to Convert Between Z-Scores and Percentiles in Excel

A z-score tells us how many standard deviations away a certain value is from the mean of a dataset. A percentile tells us what percentage of observations fall below a…

# How to Calculate Cohen’s d in Excel

In statistics, when we’re interested in determining whether or not there is a significant difference between two groups we often perform a hypothesis test, which…

# How to Calculate the Midrange in Excel

The midrange of a dataset is calculated as: Midrange = (largest value + smallest value) / 2 This value is simply the average of the largest and…

# How to Normalize Data in Excel

To “normalize” a set of data values means to scale the values such that the mean of all of the values is 0 and the standard…

# How to Create a Q-Q Plot in Excel

A Q-Q plot, short for “quantile-quantile” plot, is often used to assess whether or not a set of data potentially came from some theoretical distribution. In…