Descriptive Statistics in Google Sheets
How to Calculate the Coefficient of Variation in Google Sheets
A coefficient of variation, often abbreviated as CV, is a way to measure how spread out values are in a dataset relative to the...
Descriptive Statistics in Google Sheets
How to Calculate the Midrange in Google Sheets
The midrange of a dataset is calculated as:
Midrange = (largest value + smallest value) / 2
This value is simply the average of the largest and smallest...
Descriptive Statistics in Google Sheets
How to Calculate the Interquartile Range in Google Sheets
The interquartile range, often denoted IQR, is a way to measure the spread of the middle 50% of a dataset. It is calculated as the...
Google Sheets
How to Make a Box Plot in Google Sheets
A box plot is a type of plot that we can use to visualize the five number summary of a dataset, which includes:
The minimum
The first...
Descriptive Statistics in Google Sheets
How to Calculate a Five Number Summary in Google Sheets
A five number summary is a way to summarize a dataset using the following five values:
The minimum
The first quartile
The median
The third quartile
The maximum
The five number summary...
Google Sheets
Google Sheets: Change Color when Checkbox is Checked
You can use the custom formula function in Google Sheets to change the color of a cell when a checkbox is checked.
The following example...
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