Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Count by Group in Excel
You can use the following formula to count the number of occurrences by group in an Excel spreadsheet:
=COUNTIF(group_range, criteria)
The following example shows how to...
Descriptive Statistics in Excel
How to Calculate the Sum by Group in Excel
You can use the following simple formula to calculate the sum of values by group in an Excel spreadsheet:
=SUMIF(group_range, "group name", sum_range)
The following example...
Descriptive Statistics in Excel
Arcsine Transformation in Excel (With Examples)
An arcsine transformation can be used to “stretch out” data points that range between the values 0 and 1.
This type of transformation is typically...
Descriptive Statistics in Excel
PERCENTILE.EXC vs. PERCENTILE.INC in Excel: What’s the Difference?
The nth percentile of a dataset is the value that cuts off the first n percent of the data values when all of the...
Descriptive Statistics in Excel
QUARTILE.EXC vs. QUARTILE.INC in Excel: What’s the Difference?
Quartiles are values that split up a dataset into four equal parts.
There are three different functions you can use to calculate quartiles in Excel:
1....
Descriptive Statistics in Excel
How to Find Mean, Median & Mode in Excel (With Examples)
You can use the following formulas to find the mean, median, and mode of a dataset in Excel:
=AVERAGE(A1:A10)
=MEDIAN(A1:A10)
=MODE.MULT(A1:A10)
It’s worth noting that each...
Descriptive Statistics in Excel
Calculate Cumulative Percentage in Excel (With Examples)
Often you may want to calculate a cumulative percentage of some dataset. Fortunately this is easy to do using built-in functions in Excel.
The following...
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