so I asked my friends bout this and my parents but they didn't know what went wrong so here it goes...
I was doing an assignment on excel and I had to calculate the lower quartile. so I put in the formula
=QUARTILE.EXC(Q2:R2,1)
and it says #NUM!
what went wrong?
@TheForgotten20 "#NUM!" Shows up if the supplied value of quart is less than 0 or greater than 4 or the supplied array is empty.
@TheForgotten20 Might be too late now, but are you sure you have the right data or range in the spreadsheet? You've only highlighted two cells, which would also return #NUM!. You can't really have a lower quartile for two numbers.
gee thanks! I found my error, I shouldn't have used the max and min to calculate my quartiles, instead I should've used my input values
also nut job it wasn't too late, you helped too!
interquartile range is upper quartile - lower quartile right?
