Ellen Is a Recent College Graduate

question 16

Multiple Choice

Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.
-Ellen wants to find out what her median monthly spending is.The monthly totals for her spending appear in the range A10:L10.Which of the following is NOT a way to enter the MEDIAN function into her database?

• A)Type =MEDIAN(A10:L10) into an empty cell.
• B)Select the range A10:L10, click the Quick Analysis button, click TOTALS, and then click Median.
• C)Click the More Functions button in the Function Library group on the FORMULAS tab, point to Statistical, and then click MEDIAN.
• D)Click the Insert Function button in the Function Library group on the FORMULAS tab, scroll the Select a function list, then click MEDIAN.

---

Definitions:

Practical Importance

Refers to the relevance and applicability of an idea, research finding, or theory to real-world situations.

Central Tendency

A statistical measure that identifies a single value as representative of an entire distribution of data, commonly using the mean, median, or mode.

Standard Deviation

A statistical measure that quantifies the amount of variation or dispersion of a set of data values from their average (mean).

Variance

A measure of the dispersion of a set of data points around their mean; it quantifies the spread of the data.