Excel

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

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