Use the Spreadsheet Below to Answer the Following Questions) -Use Excel to Calculate the Standard Deviation for Y

question 74

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 standard deviation for Y.

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

---

Definitions:

Concept

Refers to an abstract idea or a mental symbol that is typically a fundamental building block of human thinking and communication.

Terms

Words or phrases used in specific contexts with particular meanings, often within academic, legal, or technical fields.

Sweat

The process of perspiring as a means for the body to regulate its temperature and remove certain waste products.

Perspire

To emit sweat through the pores of the skin as a natural process of cooling and excretion.