Use the Spreadsheet Below to Answer the Following Questions) -Use Excel to Calculate the Coefficient of Variation of X

question 104

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 coefficient of variation of X.

• A) 0.42
• B) 0.31
• C) 7.04
• D) 16.47

---

Definitions:

Revenue In Advance

Income received by a company for goods or services that are to be provided in the future, also known as deferred revenue.

Liability Account

An account on the balance sheet representing amounts owed to creditors or other parties, typically categorized as current or long-term.

Adjusting Entry

A journal entry made in accounting records to correct or allocate revenues and expenses to the appropriate period.

Wages Expense

This is the total amount of wages a company pays to its employees, which is considered an expense on the income statement.