You have data in columns A and B from rows 1 to 10. You want to create a scatter plot using this data. Which range selection correctly includes all data points for the scatter plot?
Remember, a scatter plot needs both X and Y values for each point.
The scatter plot requires both X and Y data ranges. Selecting A1:B10 includes both columns fully. Options A and B select only one column, and D misses the last row.
You want to visualize the relationship between two numeric variables in Excel. Which chart type should you choose?
Think about which chart shows how two numbers relate to each other as points.
A scatter plot shows the relationship between two numeric variables by plotting points on X and Y axes. Pie charts show parts of a whole, column charts show categories, and line charts show trends over time.
You created a scatter plot with data points forming a clear upward trend from left to right. What does this pattern most likely indicate?
Think about what an upward trend means in terms of variable relationships.
An upward trend in a scatter plot means as one variable increases, the other also increases, showing a positive correlation. A downward trend would indicate a negative correlation.
You add a linear trendline to your scatter plot in Excel and choose to display the equation on the chart. What does the equation represent?
Think about what a trendline does in relation to the data points.
The trendline equation shows the mathematical relationship between X and Y, allowing prediction of Y from X. It is not a sum, average, or count.
You have a scatter plot showing most data points clustered along a line, but one point is far away from the others. What is this point called and what should you consider?
Think about points that do not fit the pattern of the rest.
An outlier is a point far from others that may indicate an error or unique case. Trendlines show direction, clusters are groups, and labels identify data.