Variance and Standard Deviation

[shaunburke]

I'm trying to calculate the var and stdev of the last 3 weeks of a set of data. I've attached the data.

any help would be appreciated

[mdbct]

Both of the following formulas are array formulas. They need to be confirmed using Ctrl+Shift+Enter:

=STDEV(IF(--(B10:B623>=H2)*--(B10:B623<=H1)=1,E10:E623))

=VAR(IF(--(B10:B623>=H2)*--(B10:B623<=H1)=1,E10:E623))

I noticed your formula in H3 does not include today or the date 21 days ago. The formulas I provided include those two days

[shaunburke]

Thanks...Works perfectly. Now I have to figure out if there is any variance in the number of behaviors that occur. Any Stats whizzes out there?

[ale_hamuche]

variance is the standard deviation squared