Compare and Contrast Methods of Summarizing and Describing Data
Use

Compare and contrast methods of summarizing and describing data
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}\begin{array} { | l | l | } \hline\text { Shoes sold }\\ \text { 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 & \\\hline\end{array}\end{array}$$
-Use Excel to calculate the standard deviation for Y.

A) 49.57
B) 16.47
C) 7.04
D) 2.6