Analyzing and Visualizing Data with Microsoft Excel — Question 57

You have a table that contains data relating to exam candidates and their associated exam scores.
You need to visualize the exam data by separating the data into quartiles. The visualization must display the mean score and must identify any outliers.
Which type of chart should you use?

Answer options

• A. line
• B. pie
• C. box and whisker
• D. histogram

Correct answer: C

Explanation

A box and whisker plot is ideal for visualizing data in quartiles as it displays the median, quartiles, and potential outliers effectively. A line chart is not suitable for this type of data representation, a pie chart does not convey statistical distribution, and a histogram focuses on frequency rather than quartile separation.