Hello!
I am new to this forum, this is my first post, so please forgive me if I make a mistake or two.
I am trying to do some calculations for Standard Deviation of data in a column. I would like the results to be in a cell in that column, on the bottom. This isn't a real issue, except that I have some outliers that I am scientifically required to remove from the data. I cannot seem to find a formula that works for me. This is the base formula for standard deviation that I am working with:=IFERROR(STDEV.S(L8:L32),""). The if error statement is to eliminate the counting of blank cells in the table. From I have tried IF and IFS statements to no avail. I would like to do the standard deviation and have it automatically not count cells in the column that are less than 44 and greater than 55. After I am able to get the standard deviation, I then need to calculate estimate of uncertainty, which looks like this:=IFERROR(L36/SQRT(COUNT(L8:L32)),""). Again, IF ERROR is for blank cells.
Any help is appreciated, thank you!
Bookmarks