What chart type would you use to show the relationship between two variables?

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.