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 z-score of X observation 27.
A) -0.24
B) 0
C) 0.18
D) 1.46

Question

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 z-score of X observation 27.
A) -0.24
B) 0
C) 0.18
D) 1.46

Quizplus · Accepted Answer

The z-score is calculated using the formula $z = \frac{(X - \mu)}{\sigma}$, where $X$ is the value, $\mu$ is the mean, and $\sigma$ is the standard deviation. For $X = 27$, the mean of X values is approximately 16.71 and the standard deviation is approximately 6.32. Thus, $z = \frac{(27 - 16.71)}{6.32} ≈ 1.63$, which is closest to option D, 1.46, considering potential rounding differences in calculations.

Use the Spreadsheet Below to Answer the Following Questions) -Use Excel to Calculate the Z-Score of X Observation 27