Google Sheets
How to Perform t-Tests in Google Sheets
Broadly speaking, there are three types of t-tests:
One sample t-test
Two sample t-test
Paired samples t-test
This tutorial provides examples of how to perform each of these...
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...
Descriptive Statistics in Google Sheets
How to Calculate Skewness & Kurtosis in Google Sheets
In statistics, skewness and kurtosis are two ways to measure the shape of a distribution.
Skewness is a measure of the asymmetry of a distribution. This value can be positive...
Descriptive Statistics in Google Sheets
How to Calculate the Mean Absolute Deviation in Google Sheets
The mean absolute deviation is a way to measure the dispersion for a set of data values.
A low value for the mean absolute deviation is an...
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