Descriptive Statistics in Excel

A trimmed mean is the mean of a dataset that has been calculated after removing…

In statistics, covariance is a way to measure how changes in one variable are associated…

The following step-by-step example shows how to delete a calculated field from a pivot table…

The following step-by-step example shows how to add a running total column to a pivot…

The following step-by-step example shows how to calculate the percentage difference between two columns in…

The following step-by-step example shows how to sum two columns in a pivot table in…

The following step-by-step example shows how to calculate a weighted average within a pivot table…

You can use the AVERAGEIF function in Excel to calculate a conditional mean. This function…

You can use the following basic formulas to add and subtract hours from a time…

Often you may want to calculate an average percentage of some dataset. Fortunately this is…