Excel

How To Perform Random Sampling In Microsoft Excel

In this tutorial, I will show you two completely different ways of performing random sampling in Microsoft Excel. What is random sampling? Random sampling is a...

How To Perform A Chi-Square Test Of Independence In Excel

In this tutorial, I will show you step-by-step how to perform a chi-square test of independence by using Microsoft Excel. Example data Let’s say I have...

How To Calculate Variance In Microsoft Excel

In this tutorial, I will demonstrate how to calculate the variance in Microsoft Excel. Specifically, I will show you how to calculate the variance...

How To Create A Correlation Matrix In Microsoft Excel

In this tutorial, I will show you how to create a correlation matrix by using Microsoft Excel. I'll also show you how to colour...

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