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)

 

You can find similar Excel Questions and Answer hereunder

1) Excel 2010 vba replacement of application filesearch in Excel

2) statistical functions avedev average averagea countblank countif

3) statistical functions normsdist normsinv percentile percentrank permut

4) Formula does not calculate in Excel

5) Remove the apostrophe cell text values in Excel

6) Userform initialize vs userform show in Excel

7) How to read a value from a cell in vba in Excel

8) statistical functions stdev stdeva stdevp stdevpa steyx

9) Millions thousands custom number formatting in Excel

10) statistical functions poisson prob quartile skew slope standardize

 

Here the previous and next chapter