Is there a built in Variance function in vba?

[abberyfarm]

Hi there,

I calculate the standard deviation of range using the code below

I am wondering if there is a similar one for calculating the variance of the range?

StandardDevVel = Application.StDevP(Worksheets("raw").Range(Cells(sp, 3), Cells(ep, 3)))

Thanks

 

[VoG]

Variance is the standard deviation squared.

 

[abberyfarm]

That is what I thought but they don't equal?

Eample

0,1,2,3,4,5,6,7,8,9

The STDEVP of these numbers is 2.87.

2.87 squared is 8.25

but the VAR of the above numbers is 9.17?

 

[VoG]

You would have to use VARP for that example. See if this helps

Excel Workbook
	A	B	C	D
1	0	3.02765	9.166667	9.166667
2	1	2.872281	8.25	8.25
3	2
4	3
5	4
6	5
7	6
8	7
9	8
10	9
Sheet2

 

[abberyfarm]

Oh I didn't realize that there were two variance functions for population and sample.

Thank you