MO-211 practice question 18 of 35
What chart type would you use to show the relationship between two variables?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
A scatter chart (also known as an XY chart) is specifically designed to display and compare numeric values, showing the relationship between two sets of numbers. It plots one set of numeric data along the horizontal axis (x-axis) and another along the vertical axis (y-axis). Each data point combines these x and y values into single points, visually revealing any correlation or patterns between the two variables. This makes it the standard choice for relationship analysis.
B. Area chart: This chart type emphasizes the magnitude of change over time or other categories, not the correlation between two distinct numeric variables.
C. Line chart: This chart is primarily used to display trends in data at equal intervals, such as over time, rather than showing the relationship between two general variables.
D. Pie chart: This chart represents the proportion of parts to a whole for a single data series and is unsuitable for showing relationships between two variables.
1. Microsoft Office Support Documentation: "A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and displays them in irregular intervals
or clusters. Scatter charts are commonly used for displaying and comparing numeric values
such as scientific
statistical
and engineering data."
Source: Microsoft Corporation. (n.d.). Available chart types in Office. Microsoft Support. Retrieved from the "Scatter and bubble charts" section.
2. University Courseware: "Use a Scatter plot (also known as an XY scatter) to show the relationship between two variables. Scatter plots are useful to show the correlation between the two variables."
Source: MIT Libraries Data Management Services. (2023). Data Visualization with Excel: Chart Types. MIT Libraries. Retrieved from the "Scatter Plot" section.
3. University Courseware: "Scatterplots are used to display the relationship between two continuous variables. In a scatterplot
each subject in the data set is represented by a single point."
Source: PennState University Libraries. (n.d.). Data Visualization with Excel - Part 2: Chart Types. Retrieved from the "Scatterplots" section.
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
