Descriptive Statistics in Google Sheets

Often you may want to calculate an average percentage of some dataset. Fortunately this is easy to do using built-in functions in…

The 90th percentile of a dataset is the value that cuts off the bottom 90 percent of the data values from the…

A trimmed mean is the mean of a dataset that has been calculated after removing a specific percentage of the smallest and…

Often you may want to find the max value of some dataset in Google Sheets based on a category or group. For…

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…

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 mean represents the average value in a dataset. It gives us a good idea of where the center of a dataset…

In statistics, quintiles are numbers that split a dataset into five groups of equal frequency. The first quintile is the point where…

You can use the following formulas to perform a standard deviation IF calculation in Google Sheets: Method 1: Standard Deviation IF (One…

You can use the following formula to calculate the square root of a value in Google Sheets: =SQRT(A1) And you can use…