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

question 36

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 z-score of X observation 27.

• A) -0.24
• B) 0
• C) 0.18
• D) 1.46

---

Definitions:

Intra-Entity Transfers

Transactions involving the transfer of goods, services, or resources between divisions or entities within the same company.

Operating Income

The profit realized from a business's core operations, excluding deductions of interest and taxes.

Accrual-Based

An accounting method that records revenues and expenses when they are incurred, regardless of when cash is exchanged.

Mutual Ownership

A form of ownership where an institution, such as a mutual insurance company or building society, is owned by its members or policyholders.