Descriptive Statistics in Excel

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

In statistics, covariance is a way to measure how changes in one variable are associated with changes in another variable. A positive…

The following step-by-step example shows how to delete a calculated field from a pivot table in Excel. Step 1: Create the Pivot…

The following step-by-step example shows how to add a running total column to a pivot table in Excel. Step 1: Enter the…

The following step-by-step example shows how to calculate the percentage difference between two columns in a pivot table in Excel. Step 1:…

The following step-by-step example shows how to sum two columns in a pivot table in Excel. Step 1: Enter the Data First,…

The following step-by-step example shows how to calculate a weighted average within a pivot table in Excel. Step 1: Enter the Data…

You can use the AVERAGEIF function in Excel to calculate a conditional mean. This function uses the following basic syntax: =AVERAGEIF(A2:A7, “some…

You can use the following basic formulas to add and subtract hours from a time in Excel: Formula 1: Add Hours to…

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