I had a question answered yesterday and I am grateful for it.
I have another, I need to know ho to get excel to calulate +1 and -1 stdev for a list of values and then sum the oultliers! I have tried doing it in a formula that I thought might work, but I keep getting 0 as the answer and I know this is incorrect.
example:
5, 6, 5, 6, 5, 6, 5, 19, 5, 1, 18,
I need the stdev of +1 and -1, which I know how to do in excel, but I cannot get it to sum the numbers ouliers in this example 19, 1, 18.
Sure I could do it manually but i need excel to do it as my calculations need to change as I add future values.
The sum, would go into a seperate cell that would be put into a seperate calculations.
please help!
Bookmarks