Loss & Gain Deviation

[Natalie]

Dear Any Excel Pros:

I would like to calculate the standard deviation of a
sample "IF" sample value >=0; and seperately "IF" sample
value <0. How can I do this in Excel 2000?

Thanks,
Natalie

 

[Harlan Grove]

I would like to calculate the standard deviation of a
sample "IF" sample value >=0; and seperately "IF" sample
value <0. How can I do this in Excel 2000?

Use the array formulas

=STDEV(IF(Sample>=0,Sample))

and

STDEV(IF(Sample<0,Sample))

Enter array formulas by holding down [Ctrl] and [Shift] keys before pressing
the [Enter] key.

 

[Guest]

Thanks for the prompt response.
This is what I attempted, but it returned #Value!
=STDEV(IF(D725>=0,D725))
Any idea why?

-----Original Message-----

I would like to calculate the standard deviation of a
sample "IF" sample value >=0; and seperately "IF" sample
value <0. How can I do this in Excel 2000?

Use the array formulas

=STDEV(IF(Sample>=0,Sample))

and

STDEV(IF(Sample<0,Sample))

Enter array formulas by holding down [Ctrl] and [Shift] keys before pressing
the [Enter] key.


.

 

[Harlan Grove]

Thanks for the prompt response.
This is what I attempted, but it returned #Value!
=STDEV(IF(D725>=0,D725))
Any idea why?

Yes. You didn't pay attention. The result you're getting means you failed to
enter the formula as an array formula. It *MUST* be entered as an array
formula, so you don't just type the formula and press [Enter]. Try following
the directions in my previous response.

Enter array formulas by holding down [Ctrl] and [Shift]
keys before pressing the [Enter] key.