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