Use the Following Dataset to Answer the Following Question Using a Spreadsheet Software, Such as Excel, to Preview Different

Multiple Choice

Use the following dataset to answer the following question. $$\begin{array} { | c | c | c | c | c |} \hline \text { State } & \text { Year } & \text { Sales } & \text { Capital Expenditures } & \text { Wages } \\\hline \text { Westerm } & 2016 & \$ 750,000 & \$ 130,000 & \$ 330,000 \\\hline \text { Eartem1 } & 2016 & \$ 645,000 & \$ 225,000 & \$ 430,000 \\\hline \text { Westerm } & 2017 & \$ 770,050 & \$ 145,000 & \$ 230,000 \\\hline \text { Eartern } & 2017 & \$ 925,000 & \$ 125,000 & \$ 530,000 \\\hline\end{array}$$ Using a spreadsheet software, such as Excel, to preview different views of this dataset, such as Sales in the Eastern part of the country, would be aided by what?

A) Linear regression
B) Cluster analysis
C) Pivot table
D) Scorecard