Excel

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...

Calculating Mean, Standard Deviation And Error In Excel

In this guide, I will show you how to calculate the mean (average), standard deviation (SD) and standard error of the mean (SEM) by...

How To Perform A Pearson Correlation Test In Excel

In this guide, I will show you how to perform a Pearson correlation test in Microsoft Excel. This includes determining the Pearson correlation coefficient...

How To Calculate The Interquartile Range (IQR) In Excel

In this guide, I will show you how to calculate the interquartile range (IQR) by using Microsoft Excel. I will also show you how...