Excel

How To Perform Descriptive Statistics In Microsoft Excel

In this tutorial, I will show you how to use the Data Analysis ToolPak to return some descriptive statistics about your data in Microsoft...

How To Do Basic Math In Excel (Add, Subtract, Multiply & Divide)

In this tutorial, I'll show you how to perform basic math functions in Microsoft Excel. Specifically, I will show you how to add, subtract,...

How To Calculate A Weighted Average In Microsoft Excel

In this step-by-step tutorial, I'm going to show you how to calculate a weighted average in Microsoft Excel. Specifically, I will demonstrate calculating a...

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