Often you may want to calculate an average percentage of some dataset. Fortunately this is…
Category:
Descriptive Statistics in Google Sheets
-
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate the 90th Percentile in Google Sheets
by Erma Khanby Erma KhanThe 90th percentile of a dataset is the value that cuts off the bottom 90…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate a Trimmed Mean in Google Sheets
by Erma Khanby Erma KhanA trimmed mean is the mean of a dataset that has been calculated after removing…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
Google Sheets: How to Find Max Value by Group
by Erma Khanby Erma KhanOften you may want to find the max value of some dataset in Google Sheets…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Use a Percentile IF Formula in Google Sheets
by Erma Khanby Erma KhanYou can use the following formula to perform a Percentile IF function in Excel: =PERCENTILE(IF(GROUP_RANGE=GROUP,…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate a Weighted Percentage in Google Sheets
by Erma Khanby Erma KhanYou can use the following formula to calculate a weighted percentage in Google Sheets: =SUMPRODUCT(A:A,…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate Mean and Standard Deviation in Google Sheets
by Erma Khanby Erma KhanThe mean represents the average value in a dataset. It gives us a good idea…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate Quintiles in Google Sheets
by Erma Khanby Erma KhanIn statistics, quintiles are numbers that split a dataset into five groups of equal frequency.…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate Standard Deviation IF in Google Sheets
by Erma Khanby Erma KhanYou can use the following formulas to perform a standard deviation IF calculation in Google…
-
Descriptive Statistics in Google SheetsGoogle SheetsSoftware Tutorials
How to Calculate Square Root & Cube Root in Google Sheets
by Erma Khanby Erma KhanYou can use the following formula to calculate the square root of a value in…
Newer Posts