Buzz
This article provides detailed instructions on how to use the VARP Function, which calculates population variance across the entire dataset.
Description: The function calculates the population variance across the entire dataset. Its arguments can only be arrays or references, where logical values and numeric representations are counted directly when entered.
Syntax: VARP(number1,[number2],...).
Regarding:
- Number1: The first numeric argument corresponding to a dataset, is a required parameter.
- Number2,…: Are numeric arguments from 2 -> 255 corresponding to a dataset, are optional parameters.
Note:
- Assuming its arguments are the entire set, the VARP function is designed to compute variance when data represents a sample of a set, VAR function should be used.
- Function arguments can be numbers, names, arrays, or references containing numbers.
- In case arguments are arrays or references, only numeric values or newly referenced ones are calculated while logical, textual, empty values are ignored.
- If arguments are text or error values, the function returns an error value because those values cannot be converted to numeric type.
- If you wish to include logical values and text-formatted numbers in a reference for calculation, you need to use the VARPA function.
- The equation of the VARP function:
Where:
- x represents the sample mean AVERAGE (number 1, number 2, …).
- n represents the sample size.
Example:
Calculate the value of the VARP function to determine the variance for the durability of tools with the following number values:
Step 1: In the cell where you want to calculate, enter the formula: =VARP(D6:D11).
Step 2: Press Enter -> the value of the VARP function is:
In case the arguments are not in numeric form or are empty values -> these values are ignored:
Above is how to use the VARP function and some notes when using it.
Wishing you success!
