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

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 correlation between variables X and Y.

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