Descriptive Statistics in Google Sheets

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...

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...

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...

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...

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...

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...

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...