This page lists every Excel tutorial on Statology.

**Basics
**

**How to Load the Analysis ToolPak in Excel**

**Descriptive Statistics**

**How to Calculate a Five Number Summary in Excel
How to Calculate the Interquartile Range (IQR) in Excel
How to Calculate the Midrange in Excel
How to Calculate the Coefficient of Variation in Excel
How to Calculate Skewness in Excel
How to Create a Covariance Matrix in Excel
How to Create a Survival Curve in Excel
How to Easily Calculate the Dot Product in Excel
How to Calculate Conditional Probability in Excel
How to Calculate Spearman Rank Correlation in Excel
How to Normalize Data in Excel
**

**Visualizations**

**How to Create a Stem-and-Leaf Plot in Excel
How to Create and Interpret Box Plots in Excel
How to Create a Double Doughnut Chart in Excel
How to Create an Ogive Graph in Excel
How to Create and Interpret a Correlation Matrix in Excel
**

**Hypothesis Tests**

**How to Conduct a One Sample t-Test in Excel
How to Conduct a Two Sample t-Test in Excel
How to Perform Welch’s t-test in Excel
How to Conduct a Paired Samples t-Test in Excel
How to Conduct Grubbs’ Test in Excel
How to Calculate Z-Scores in Excel
How to Find a P-Value from a Z-Score in Excel
How to Convert Between Z-Scores and Percentiles in Excel
McNemar’s Test in Excel
How to Perform Chi-Square Tests in Excel
How to Create a t-Distribution Graph in Excel
How to Find the F Critical Value in Excel
How to Find the Chi-Square Critical Value in Excel
How to Find the T Critical Value in Excel
How to Find the Z Critical Value in Excel
How to Apply the Empirical Rule in Excel
How to Perform a One Proportion Z-Test in Excel
How to Perform a Two Proportion Z-Test in Excel
How to Perform a Mann-Whitney U Test in Excel
How to Perform a Binomial Test in Excel
A Guide to Using the Binomial Distribution in Excel
A Guide to Using the Poisson Distribution in Excel
How to Calculate Cohen’s D in Excel
How to Perform Fisher’s Exact Test in Excel
How to Calculate Odds Ratio and Relative Risk in Excel
How to Perform Levene’s Test in Excel
**

**Regression**

**How to Perform Simple Linear Regression in Excel
How to Perform Multiple Linear Regression in Excel
How to Construct a Prediction Interval in Excel
How to Easily Perform Quadratic Regression in Excel
How to Create a Residual Plot in Excel
How to Calculate VIF in Excel
How to Perform a Breusch-Pagan Test in Excel
How to Create a Q-Q Plot in Excel
**

**ANOVA**

**How to Perform a One-Way ANOVA in Excel
How to Perform a Kruskal-Wallis Test in Excel
How to Perform a Repeated Measures ANOVA in Excel
How to Perform the Friedman Test in Excel
**

**Time Series**

**How to Calculate Mean Absolute Percentage Error (MAPE) in Excel
How to Calculate Weighted MAPE in Excel
How to Calculate Mean Squared Error (MSE) in Excel
How to Calculate Root Mean Square Error (RMSE) in Excel
How to Calculate the Mean Absolute Deviation in Excel
How to Perform Exponential Smoothing in Excel
How to Find Moving Averages in Excel
How to Find Weighted Moving Averages in Excel**