4
AssignmentMultiple Select

Use Spreadsheet Functions and Formulas

Question 4 • CHS- TX-Professional Communications (CR)

Suppose you have a spreadsheet containing population counts collected on an annual basis. You decide to use a scatter plot to present your data. Which of the following reasons support your decision? Choose all that apply.

Answer
A
to show parts of a whole
B
to show changes over time
C
to emphasize changes between individual data points
D
to show a general trend of data points

Explanation

Put the year on the horizontal axis and population on the vertical axis. The plotted points can show how population changes over time and reveal its overall trend. A scatter plot does not show parts of a whole, and without connecting lines it does not emphasize changes between each pair of consecutive points.

AI-written and checked against the verified answer.