## What does VAR do in Excel?

The Microsoft Excel VAR function returns the variance of a population based on a sample of numbers.

It can be used as a worksheet function (WS) in Excel.

As a worksheet function, the VAR function can be entered as part of a formula in a cell of a worksheet.

## What does a pivot table do?

Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field.

## What is the difference between VAR and VARP in Excel?

STDEV.S replaces the older STDEV function, with the same behavior. The Excel VAR.P function returns the variance in an entire population. The Excel VAR function estimates the variance of a sample of data. If data represents the entire population, use the VARP function or the newer VAR.P function.

## What is a pivot table and how does it work?

Simply defined, a Pivot Table is a tool built into Excel that allows you to summarize large quantities of data quickly and easily. Given an input table with tens, hundreds, or even thousands of rows, Pivot Tables allow you to extract answers to a series of basic questions about your data with minimal effort.