What is the VARA Function?
The VARA Function is categorized under Statistical functionsFunctionsThe VARA Function is categorized under Statistical functions. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the average value. As a financial. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values.
Variance is a statistical measure used across a set of values to identify the amount that the values vary from the average value.
As a financial analystCertified Financial AnalystCFI Financial Modeling & Valuation Analyst program is your path to become a certified financial analyst. With 12 required courses on topics ranging from accounting and finance fundamentals to financial modeling, valuation and advanced Excel skills, the CFI financial analyst certification will help, the VARA Function can be useful in calculating variance in revenue. Portfolio managersPortfolio ManagerPortfolio managers manage investment portfolios using a six-step portfolio management process. Learn exactly what does a portfolio manager do in this guide. Portfolio managers are professionals who manage investment portfolios, with the goal of achieving their clients’ investment objectives. often use this function to measure and keep a track of their portfolio risks.
Formula
=VARA(number1,[number2],…)
The VARA function uses the following arguments:
- Number1 (required argument) – It is the first argument corresponding to a population.
- Number 2,.. (optional argument) – Here, the number arguments can be up to 254 values or arrays of values that provide at least two values to the function. However, we can only enter up to 30 number arguments in Excel 2003 and earlier versions.
When providing the arguments, we need to remember that:
- We can enter up to 254 number arguments to the VARA function in current versions of Excel (2007 and later). However, we can only enter up to 30 number arguments in Excel 2003.
- VARA is used when we are calculating the variance for a sample of a population. If we wish to calculate the variance for an entire population, we should use the Excel VARP function.
VAR vs. VARA function
Both the functions are similar but differ in the following ways:
- When an array of values containing logical values is provided, VAR ignores logical values whereas VARA will assign the value 0 for the FALSE logical value and 1 for the TRUE logical value.
- Text – including empty text “”, text representations of numbers, or other text – within arrays or reference arguments are ignored by VAR but counted as zero by VARA.
How to use VARA to calculate variance in Excel?
As a worksheet function, VARA can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:
Example
Suppose we are given data about the height of children from three cities, as shown below:
For variance, the formula used is:
We get the results below:
In the example above, we took the arguments for the VARA function as input in the form of three cell ranges. However, we can also enter the figures directly, either as individual numbers or number arrays.
Few things to remember about the VARA Function
- #DIV/0 error – Occurs if we did not provide any numeric values as arguments.
- #VALUE! error – Occurs when any of the values provided directly to this function are text values that cannot be interpreted as numbers.
Click here to download the sample Excel file
Additional resources
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial modeling analysis. To learn more, check out these additional resources:
- Excel Functions for FinanceExcel for FinanceThis Excel for Finance guide will teach the top 10 formulas and functions you must know to be a great financial analyst in Excel. This guide has examples, screenshots and step by step instructions. In the end, download the free Excel template that includes all the finance functions covered in the tutorial
- Advanced Excel Formulas Lessons
- Financial Modeling GuideFree Financial Modeling GuideThis financial modeling guide covers Excel tips and best practices on assumptions, drivers, forecasting, linking the three statements, DCF analysis, Excel modeling and much more. Designed to be the best free modeling guide for analysts by using examples and step by step instructions. Investment banking, FP&A, research
- All Excel ResourcesExcel ResourcesThe VARA Function is categorized under Statistical functions. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the average value. As a financial