How would you calculate the interquartile range (IQR) in Excel using built-in functions?
- A) =QUARTILE.INC(data, 3) - QUARTILE.INC(data, 1)
- B) =MAX(data) - MIN(data)
- C) =PERCENTILE(data, 0.25) - PERCENTILE(data, 0.75)
- D) =QUARTILE(data, 3) - QUARTILE(data, 1)