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 should you select to include all data points?
Remember, you need to include both columns and all rows with data.
The scatter plot requires both X and Y values. Selecting A1:B10 includes all data points in both columns and rows.
You want to visualize the relationship between two numeric variables in Google Sheets. Which chart type should you choose?
Think about which chart shows how two numbers relate to each other point by point.
A scatter chart plots pairs of numeric values to show their relationship, which is ideal for two numeric variables.
You created a scatter plot with data from columns C and D. Column C contains dates, and column D contains sales numbers. The scatter plot shows dates on the X-axis and sales on the Y-axis. What is the best way to format the X-axis for clear understanding?
Think about how dates should appear for easy reading on a chart.
Formatting the X-axis as dates shows clear, readable date labels, making the scatter plot easier to understand.
You want to add a linear trendline to your scatter plot in Google Sheets. Which menu option do you use to add this trendline?
Look for trendline options under chart customization.
In Google Sheets, trendlines are added via the Chart editor under Customize > Series > Trendline.
You created a scatter plot showing the relationship between advertising spend (X-axis) and sales revenue (Y-axis). Most points form a clear upward trend, but one point is far away from the others with very high sales but low advertising spend. What does this point represent?
Think about what a point far from the trend usually means in data analysis.
An outlier is a point that differs significantly from others and may indicate an unusual event or data error.