Excel

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

How To Create A Linear Standard Curve In Excel

In this guide I will explain how to create a linear standard curve using Microsoft Excel and how to use it to calculate unknown...

How To Calculate The Coefficient Of Variation (CV)

What is the coefficient of variation? The coefficient of variation (CV) is a measure of precision from repeated measures. Within the lab, it is mainly...