How do i calculate Standard Deviation on Negative Numbers Only


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.
 
Ad

Advertisements

R

rbrychckn

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
 
Ad

Advertisements

vvc

Joined
Jul 18, 2019
Messages
1
Reaction score
0
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.
 

Ask a Question

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.

Ask a Question

Top