Data that has outliers can be analyzed quickly with conditional formatting, by highlighting only cells that have data that is more than 3 standard deviations from the mean. True False

What visual should be used to display outliers? The line chart is best to display outliers.The scatter chart is best to display outliers.The clustered column chart is best to display outliers.

"Which MS Excel feature is most often used as color-based formatting to highlight, emphasize or differentiate among data and information stored in a spreadsheet?"Conditional formattingData analysisData validationData sort

n outlier is an observation (or recorded response) that is an extreme or atypical distance outside the normal range of other data values. True False

Conditional formatting can format the values above the average only, turning the cell and the font to a different view  when checked. This can be turned on and off with a grouping button True False

Quartile Analysis: A method to split data into quarters, revealing distribution and outliers, chosen for robustness and clarity.