Pinterest Pixel

Varp in Excel Pivot Tables

It is very easy to use a Pivot Table to summarize data for you by giving the... read more

Download Excel Workbook
Bryan
Posted on

Overview

Varp in Excel Pivot Tables | MyExcelOnline Varp in Excel Pivot Tables | MyExcelOnline

It is very easy to use a Pivot Table to summarize data for you by giving the sum, count, or average. But did you know it can give you the standard deviation and variance as well? This is crucial if you want to understand how volatile your data is!

Let us explore how to get Varp in Pivot Table, this shows the variability from the average or mean value of the group.

 

Exercise Workbook:

download excel workbookVarp.xlsx


STEP 1: Here is our Pivot Table. Drag UNITS SOLD to the Values Area

Product in Excel Pivot Tables

 

STEP 2: This will default to Sum of UNITS SOLD. Let us change that by clicking on the arrow and selecting Value Field Settings

Product in Excel Pivot Tables

STEP 3: Select Varp and click OK.

We will use the Varp function as we have the complete data (population) used in the calculation. When only a portion of the data is used, then Var should be used instead.

See also  Highlight Cell Rules based on date labels

Product in Excel Pivot Tables

Now you have your Variance.

Product in Excel Pivot Tables

Did you know that the square root of the variance will give you the standard deviation value? Click here to learn how!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Varp in Excel Pivot Tables | MyExcelOnline Varp in Excel Pivot Tables | MyExcelOnline
Varp in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...