I have a column that includes nearly 2 thousand data points. Some are positive and some are negative. First, I want to only consider the negative values, then calculate the 5th percentiles of those negative values.
This is the formula that I tried, but am convinced it doesn't work, because sometimes it gives me 0 as a value, which makes zero sense.
=PERCENTILE(IF(SHEET 1!$B$4:$B$1898<0,SHEET 1!$B$4:$B$1898),0.05)
I'm a bit lost. Thanks in advanced!
This is the formula that I tried, but am convinced it doesn't work, because sometimes it gives me 0 as a value, which makes zero sense.
=PERCENTILE(IF(SHEET 1!$B$4:$B$1898<0,SHEET 1!$B$4:$B$1898),0.05)
I'm a bit lost. Thanks in advanced!
