Use the Spreadsheet Below to Answer the Following Questions) -Use Excel to Calculate the Covariance Between Variables X and Is

question 65

Multiple Choice

Use the spreadsheet below to answer the following questions) .
Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period. The rate of shoes sold per day X) and the price of the shoes Y) . $\begin{array} { | r | r | } \hline \text { Shoes sold in \% X) } & \text { Price Y) } \\\hline 15 & \$ 48 \\\hline 27 & \$ 55 \\\hline 10 & \$ 40 \\\hline 13 & \$ 88 \\\hline 25 & \$ 53 \\\hline 9 & \$ 47 \\\hline 18 & \$ 40 \\\hline\end{array}$
-Use Excel to calculate the covariance between variables X and Y.

• A) 2.67
• B) 0.02
• C) 16.71
• D) 7.04

---

Definitions:

Nullification Crisis

A confrontation between the state of South Carolina and the federal government in 1832-1833 over the state's attempt to nullify federal tariffs.

Secession

The act of withdrawing formally from membership in a federation or body, especially a political state.

Protective Tariffs

Duties levied on goods coming from abroad to safeguard local businesses from overseas competitors by increasing the cost of imports.

Second Seminole War

A conflict from 1835 to 1842 in Florida between the United States and the Seminole tribe, part of a series of conflicts known as the Seminole Wars.