Descriptive Statistics in Excel
Descriptive Statistics in Excel
STDEV.P vs. STDEV.S in Excel: What’s the Difference?
There are three different functions you can use to calculate standard deviation in Excel:
1. STDEV.P: This function calculates the population standard deviation. Use this...
Descriptive Statistics in Excel
How to Calculate the Mean and Standard Deviation in Excel
The mean represents the average value in a dataset. It gives us a good idea of where the center of a dataset is located.
The...
Descriptive Statistics in Excel
How to Calculate Relative Standard Deviation in Excel
The relative standard deviation is a measure of the sample standard deviation relative to the sample mean for a given dataset.
It is calculated as:
Relative...
Descriptive Statistics in Excel
How to Calculate Point-Biserial Correlation in Excel
Point-biserial correlation is used to measure the relationship between a binary variable, x, and a continuous variable, y.
Similar to the Pearson correlation coefficient, the point-biserial correlation coefficient...
Descriptive Statistics in Excel
How to Create a Contingency Table in Excel
A contingency table (sometimes called “crosstabs”) is a type of table that summarizes the relationship between two categorical variables.
Fortunately it’s easy to create a contingency table...
Descriptive Statistics in Excel
How to Create a Frequency Distribution in Excel
A frequency distribution describes how often different values occur in a dataset. It’s a useful way to understand how data values are distributed in a dataset.
Fortunately it’s...
Descriptive Statistics in Excel
How to Calculate the Standard Error of the Mean in Excel
The standard error of the mean is a way to measure how spread out values are in a dataset. It is calculated as:
Standard error...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read