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)

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?

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.