Just replace array with the range of cells. You can directly type, =Quartile(array,3)-Quartile(array,1) You can use 1 single formula to calculate IQR in excel. Instead of calculating Q1 & Q3 and then subtracting. Use the simple subtract formula i.e type =D4-D3.
0 Comments
Leave a Reply. |