Statistical functions: trend, var, vara, varp, varpa
Looking at the following x y value.
X | Y |
1 | 50 |
2 | 52 |
3 | 62 |
4 | 63 |
5 | 68 |
6 | 72 |
7 | 78 |
8 | 80 |
9 | 85 |
10 | 87 |
11 | 90 |
12 | 100 |
Excel Function TREND
The TREND() function is used to calculate the linear trend line for a specified x and y values.
The least square method is used to calculate the linear trend.
The syntax of the function is as given below:
TREND(x_values,y_values,[new_x_values],[const])
The last two parameters are optional.
X | TREND() | Formula | |
13 | 100.372727 | =TREND($B$6:$B$16;$A$6:$A$16;F26) | |
16 | 112.72727 | =TREND($B$6:$B$16;$A$6:$A$16;F27) | |
20 | 129.2 | =TREND($B$6:$B$16;$A$6:$A$16;F28) | |
5 | 67.4272727 | =TREND($B$6:$B$16;$A$6:$A$16;F29) | |
9 | 83.9 | =TREND($B$6:$B$16;$A$6:$A$16;F30) |
Excel Function VAR
The VAR() function is used to find the variance of a given set of numeric.
The variance is nothing but a measure of deviation of value from average value.
The syntax of the function is given below:
VAR(num1,num2,�num254)
Note that, only 254 arguments are possible in this function.
Excel Function VARA
The VARA() function is also used to determine the variance of given set of values.
The difference of this function from that of VAR() is that, this function can include text and Boolean arguments.
The syntax of the function is given below:
VARA(value1,value2,�value254)
Excel Function VARP
The VARP() function is used to calculate the variance of entire set of population.
This differs from VAR() in the sense that, VAR() calculates variance for a sample set of numbers only.
The syntax of this function is given below:
VARP(num1,num2,�num254)
Excel Function VARPA
The VARPA() function is used to calculate the variance of entire set of population.
The thing is , this function can include text, TRUE or FALSE values also unlike VARP() which takes only numbers.
This differs from VARP() in the sense that, VARP() calculates the variance of entire population of numbers only.
The syntax of this function is given below:
VARPA(value1,value2,..value3)