1. Which Excel function would be least useful to calculate the quartiles for a column of data?
=STANDARDIZE
=PERCENTILE.EXC
=QUARTILE.EXC
=RANK
2. Which statistics offer robust (resistant to outliers) measures of center?
Mean, midrange, mode.
Median, midhinge, trimmed mean.
Trimmed mean, midrange, midhinge.
Mean, mode, quartiles.