VARPA Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel is one of the best applications that you can find in your PC. It lets you work on statistical formulas, graphs, and documents easily. However, excel is a daunting task where you have to be familiar with all of its functions well so you can easily work on it. One of the functions that can be useful to you in excel is  VARPA function. Let us discuss this function as you go on with the article.

VARPA Function Description

Excel VARPA function returns the variance of the given set of values. Syntax for this function is:

= VARPA (valueone, valuetwo …)

Where, number argument offers minimum of two numerical values to function. You can place more than 254 number arguments to VARPA function in 2007 and 2010 of Excel. Though, you can enter more than thirty number argument in excel 2003.

Take In Consideration:

VARPA function is often used for computing variance of the whole population. When the data is sample of population, that is when the statistics set records the person’s heights of sample of UK males; you have to use the Excel VARA function.

VARP and VARPA Function

Excel VARPA function is similar with the excel VARP function, both functions computes the variance of supplied set of value. The only difference between the two is that when array of values, contains logical values or texts, where VARPA function assign the value zero to the text and values one or zero to the logical values.

How to Apply VARPA Function in Excel?

Excel VARPA function stands for the variance population argument. This computes the variance based in the whole population. Argument lists are considered to be the whole population, so variance should be computed with the use of VARPA when the arguments represent a population sample. Here are some of the steps that you can use to be able to work with excel VARPA function.

  • Learn VARPA function formula which is: VARPA (value1, value2, …)
  • Then study valid argument type for VARPA function. It could wiht the following: names, numbers, text representation, and the logical values. Arguments that can’t be translated in the n umber or error values would cause error.
  • Names could be in a form of reference or arrays which contains number. In this, the values in range  or reference would be use. Text values and empty cells would be ignored.
  • Enter the text representation or with logical values of numbers straight in the argument when desired. Make use of the VRAP function instead of the VARPA if you don’t like to include the values in reference for VARPA calculation. The logical values can be reference as well which are equivalent to true or false. The arguments that contains true assess one and arguments contains false or text asses as zero.
  • Compute the VARPA as total of the (value- AVERAGE (valueone, valuetwo …)) ^2/N where the value is each in population and the N is number of the values in population.

Post comment