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

Multiple Choice

Use the spreadsheet below to answer the following question(s) .
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} { | l | l | } \hline \begin{array} { c } \text { Shoes sold } \\\text { in \% } ( \mathbf { X } ) \end{array} & \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 & \\\hline\end{array}$$
-Use Excel to calculate the covariance between variables X and Y.

A) 2.66
B) 0.02
C) 16.71
D) 7.04