Excel Guides

This page lists every Excel tutorial on Statology.

Operations
How to Load the Analysis ToolPak in Excel
How to Compare Two Excel Sheets for Differences
How to Select a Random Sample in Excel
How to Find the Top 10% of Values in an Excel Column
How to Find the Top 10 Values in an Excel Column
How to Use Linear Interpolation in Excel
How to Interpolate Missing Values in Excel
How to Calculate the Difference Between Dates in Excel
How to Sort by Multiple Columns in Excel

Descriptive Statistics
How to Calculate a Five Number Summary in Excel
How to Calculate the Mean and Standard Deviation 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 Calculate Standard Error in Excel
How to Create a Covariance Matrix in Excel
How to Create a Frequency Distribution in Excel
How to Create a Contingency Table 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
How to Calculate Class Width in Excel
How to Calculate Relative Frequency in Excel
How to Calculate Cumulative Frequency in Excel
How to Calculate Partial Correlation in Excel
How to Calculate Point-Biserial Correlation in Excel
How to Easily Find Outliers in Excel
How to Calculate Fleiss’ Kappa in Excel
How to Calculate Relative Standard Deviation in Excel
How to Calculate Hamming Distance in Excel
How to Calculate Euclidean Distance in Excel
How to Calculate Deciles in Excel
How to Calculate Probability in Excel
How to Winsorize Data in Excel
How to Calculate Weighted Standard Deviation in Excel
STDEV.P vs. STDEV.S 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
How to Make a Bell Curve in Excel: Example + Template
How to Make a Frequency Polygon in Excel
How to Create a Population Pyramid in Excel
How to Create a Gantt Chart in Excel
How to Create a Dot Plot in Excel
How to Create a Log-Log Plot in Excel
How to Plot an Equation in Excel
How to Add Error Bars to Charts in Excel
How to Rotate Slices of a Pie Chart in Excel
How to Change Bin Width of Histograms in Excel
How to Fit a Curve in Excel
How to Create a Normal Probability Plot in Excel

Probability Distributions
How to Apply Chebyshev’s Theorem in Excel
How to Apply the Central Limit Theorem in Excel
How to Calculate Sampling Distributions in Excel
How to Calculate Z-Scores in Excel
How to Calculate the P-Value of an F-Statistic in Excel
How to Find the P-Value of a Chi-Square Statistic in Excel
How to Find a P-Value from a Z-Score in Excel
How to Find a P-Value from a t-Score in Excel
How to Convert Between Z-Scores and Percentiles in Excel
How to Create a t-Distribution Graph in Excel
How to Apply the Empirical Rule in Excel
How to Use the Binomial Distribution in Excel
How to Use the Poisson Distribution in Excel
How to Use the Uniform Distribution 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 Calculate NormalCDF Probabilities 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
McNemar’s Test 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
How to Calculate Cohen’s D in Excel
How to Calculate Odds Ratio and Relative Risk in Excel
How to Perform Levene’s Test in Excel
How to Perform a Jarque-Bera Test in Excel
How to Find the P-value for a Correlation Coefficient in Excel
How to Calculate Confidence Intervals in Excel
How to Perform a Normality Test in Excel

Chi-Square Tests
How to Perform a Chi-Square Goodness of Fit Test in Excel
How to Perform a Chi-Square Test of Independence in Excel
How to Perform Fisher’s Exact Test in Excel

Regression
How to Perform Simple Linear Regression in Excel
How to Perform Multiple Linear Regression in Excel
How to Perform Logistic Regression in Excel
How to Perform Quadratic Regression in Excel
How to Perform Exponential Regression in Excel
How to Perform Logarithmic Regression in Excel
How to Perform Polynomial Regression in Excel
How to Construct a Prediction Interval in Excel
How to Create a Residual Plot in Excel
How to Calculate Standardized Residuals in Excel
How to Calculate VIF in Excel
How to Calculate the Standard Error of Regression in Excel
How to Perform a Breusch-Pagan Test in Excel
How to Create a Q-Q Plot in Excel
How to Calculate R-Squared in Excel
How to Calculate Adjusted R-Squared in Excel
How to Calculate Residual Sum of Squares in Excel
How to Add a Regression Line to a Scatterplot in Excel
How to Create Dummy Variables in Excel
How to Calculate SST, SSR, and SSE in Excel

ANOVA
How to Perform a One-Way ANOVA in Excel
How to Perform a Tukey-Kramer Post Hoc Test in Excel
How to Perform a Two-Way ANOVA in Excel
How to Perform a Repeated Measures ANOVA in Excel
How to Perform a Kruskal-Wallis Test in Excel
How to Perform the Friedman Test in Excel
How to Perform an ANCOVA 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
How to Calculate Autocorrelation in Excel
How to Calculate Rolling Correlation in Excel
Naive Forecasting in Excel