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:

IQ Score

A measure of a person's intelligence as indicated by an intelligence test, relative to the average for people of the same age.

Heritability Estimates

Statistical calculations that attempt to measure how much of the variation in a trait within a population can be attributed to genetic differences among individuals.

Fraternal Twins

Twins that develop from two different eggs fertilized by two different sperm, resulting in siblings that are genetically distinct.

Identical Twins

Twins that develop from a single fertilized egg, sharing 100% of their genetic material and often used in studies to explore the nature vs. nurture debate.