Hi! I have data for the slope calculation: X's (A:A) and Y's (B:B). The slope should be calculated for Y's which lie within the range between (AVERAGE(b$2:b$11)+STDEV(b$2:b$11)*3) and (AVERAGE(LARGE((b12:b100),{1,2,3,4,5})))-(AVERAGE(LARGE((b12:a100),{1,2,3,4,5}))*20/100). Any ideas on how it can be achieved?
Thanks!