Excel

How To Perform A Two-Sample F-Test In Excel (Variance Test)

In this tutorial, I’m going to show you how to perform a two-sample F-test for variances in Microsoft Excel. I’ll show you how to...

How To Perform A Linear Regression Test In Microsoft Excel

In this article, I will show you how to perform a simple linear regression test in Microsoft Excel. Not only will I show you how...

How To Perform A One-Way ANOVA Test In Microsoft Excel

In this video tutorial, I’m going to show you how to perform a one-way analysis of variance (one-way ANOVA) test by using Microsoft Excel. I'll...

How To Add Error Bars To Graphs In Microsoft Excel

In this tutorial, I will show you how to add error bars to graphs in Microsoft Excel. Specifically, I will be adding error bars...

How To Calculate Odds Ratio In Microsoft Excel

In this tutorial, I will show you how to calculate the odds ratio (OR) and 95% confidence intervals (CIs) in Microsoft Excel. Example data To start...

How To Perform A One-Sample T-Test In Excel

In this tutorial, I will show you how to perform a one-sample T-test by using Microsoft Excel. What is a one-sample T-test? A one-sample T-test is...

How To Calculate Cohen’s d In Microsoft Excel

In this tutorial, I will show you how to calculate Cohen's d in Microsoft Excel. What is Cohen's d? Cohen's d is an effect size between...

How To Easily And Quickly Calculate Z Scores In Excel

In this tutorial, I will show you how to calculate Z scores by using Microsoft Excel. What is a Z score? A Z score is the...

How To Perform A Spearman’s Rank Correlation Test In Excel

In this guide, I will show you how to perform a Spearman's Rank correlation test in Microsoft Excel. This includes determining the Spearman correlation...

How To Calculate Confidence Intervals In Excel

In this guide, I will show you how to calculate the lower and upper confidence intervals (CIs) of the mean in Microsoft Excel. Unfortunately, there...