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

question 8

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

---

Definitions:

Product Life Cycle

The sequence of stages a product goes through from introduction to growth, maturity, and decline in the market.

Product Life Cycle

The progression of a product through stages from development and introduction to growth, maturity, and decline.

Innovation Spreads

The process by which a new idea, product, or method is accepted and adopted by the market or society.

Market Group

A set of consumers or businesses with similar needs or characteristics that a company aims to serve.