Descriptive Statistics in Google Sheets
Descriptive Statistics in Google Sheets
How to Create a Correlation Matrix in Google Sheets
One way to quantify the relationship between two variables is to use the Pearson correlation coefficient, which is a measure of the linear association between two variables. It...
Descriptive Statistics in Google Sheets
How to Calculate Frequencies in Google Sheets
Frequencies tell us how often different values occur in a dataset.
We can easily calculate frequencies in Google Sheets by using the FREQUENCY() function, which has the...
Descriptive Statistics in Google Sheets
How to Normalize Data in Google Sheets
To normalize a set of data values means to scale the values such that the mean of all of the values is 0 and...
Descriptive Statistics in Google Sheets
How to Calculate Spearman Rank Correlation in Google Sheets
In statistics, correlation refers to the strength and direction of a relationship between two variables. The value of a correlation coefficient can range from -1 to...
Descriptive Statistics in Google Sheets
How to Easily Calculate the Dot Product in Google Sheets
This tutorial explains how to calculate the dot product in Google Sheets.
What is the Dot Product?
Given vector a = and vector b =...
Descriptive Statistics in Google Sheets
How to Create a Covariance Matrix in Google Sheets
Covariance is a measure of how changes in one variable are associated with changes in a second variable. Specifically, it’s a measure of the...
Descriptive Statistics in Google Sheets
How to Calculate Standard Error of the Mean in Google Sheets
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