Descriptive Statistics in Google Sheets
Descriptive Statistics in Google Sheets
Google Sheets: How to Find Max Value by Group
Often you may want to find the max value of some dataset in Google Sheets based on a category or group.
For example, suppose we...
Descriptive Statistics in Google Sheets
How to Use a Percentile IF Formula in Google Sheets
You can use the following formula to perform a Percentile IF function in Excel:
=PERCENTILE(IF(GROUP_RANGE=GROUP, VALUES_RANGE), k)
This formula finds the kth percentile of all values...
Descriptive Statistics in Google Sheets
How to Calculate a Weighted Percentage in Google Sheets
You can use the following formula to calculate a weighted percentage in Google Sheets:
=SUMPRODUCT(A:A, B:B)/SUM(B:B)
This formula assumes column A contains the percentage values and...
Descriptive Statistics in Google Sheets
How to Calculate Mean and Standard Deviation in Google Sheets
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 Google Sheets
How to Calculate Quintiles in Google Sheets
In statistics, quintiles are numbers that split a dataset into five groups of equal frequency.
The first quintile is the point where 20% of all...
Descriptive Statistics in Google Sheets
How to Calculate Standard Deviation IF in Google Sheets
You can use the following formulas to perform a standard deviation IF calculation in Google Sheets:
Method 1: Standard Deviation IF (One Criteria)
=ArrayFormula(STDEV(IF(A:A="Value",C:C)))
This formula calculates...
Descriptive Statistics in Google Sheets
How to Calculate Square Root & Cube Root in Google Sheets
You can use the following formula to calculate the square root of a value in Google Sheets:
=SQRT(A1)
And you can use the following formula to...
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