How to calculate variance in Excel

The method for calculating variance in Excel is as follows:

1. Create a new Excel document and enter the relevant data that needs statistics.

2. Enter "variance" in the cell below the data and "=" in another cell;

3. Select "fx (Insert Function)" under the menu bar, select "Common Functions" in the pop-up dialog box, then select "VAR (variance)", and click "OK";

4. In the "Function Parameters" dialog box, select "Value 1 or Value 2". If the data are together, you can select "Data 1"

5. If the data is separated, you need to select "Data 1 and Data 2", and then select all the data that require variance;

6. Select "Confirm", corresponding The variance data appears in the previously selected cell.

Recommended: Excel Basic Tutorial

The above is the detailed content of How to calculate variance in Excel. For more information, please follow other related articles on the PHP Chinese website!