How do i calculate Standard Deviation on Negative Numbers Only

  • Thread starter Thread starter daapower
  • Start date Start date
D

daapower

I have a spreadsheet with both positive and negative numbers. How would
I calculate the standard deviation for just the negative numbers
without selecting them manually.
 
Using an array formula (once entered, hit cntrl+shift+Enter in th
formula field), use the following formula where A1:A9 is you
range/array of positive and negative numbers:

=STDEV(IF(A1:A9<0,A1:A9))

(which will look like {=STDEV(IF(A1:A9<0,A1:A9))} once entered a
mentioned above)

To
 
hello everyone,

i've a series of positive and negative values, i would like to calculate standard deviation for all of them. How can i calculate the standard deviation for both positive and negative values?

thanks in advance.
 
Back
Top