ACCA Applied Knowledge · Management Accounting · Spreadsheets
Monthly sales in cells B2:B7 are 12, 15, 9, 18, 15 and 11 (in $000). Which of the following correctly gives the result of =MEDIAN(B2:B7) and =MAX(B2:B7)-MIN(B2:B7)?
The median is 13.5 and the range is 9. Sorting gives 9, 11, 12, 15, 15, 18; the middle two values 12 and 15 average to 13.5, and subtracting the minimum 9 from the maximum 18 gives 9.
- AMedian 13.5; range 9Correct
- BMedian 15; range 9
- CMedian 13.5; range 18
- DMedian 12; range 9
Explanation
Sorted values are 9, 11, 12, 15, 15, 18. With six values the median is the average of the third and fourth: (12 + 15) / 2 = 13.5. The range is 18 - 9 = 9. A median of 15 is the mode, not the median.
Did you get it right without looking?
One question tells you little. A timed set on Spreadsheets shows your real accuracy, how long you take and where you lose marks.
More Spreadsheets questions
- Cell C5 contains units sold (800). Cell C6 contains the selling price per unit ($15). Cell C7 contains variable cost per unit ($9). Fixed co…
- Cell A1 contains 200, B1 contains 50 and C1 contains 4. What is the result of the formula =A1-B1*C1/2+(A1-B1)/3 ?
- A cell contains the formula =IF(AND(B2>100,C2<50),B2*0.1,IF(B2>100,B2*0.05,0)). What value will it return when B2 = 200 and C2 = 50?
- A spreadsheet holds monthly sales in cells C5:C16 (in $). Cell E1 should show total sales only for months where sales exceed $10,000. Which …
- In a spreadsheet, cell B2 contains the formula =A2*$D$1 and is copied down to cell B3. Which formula will appear in B3?
- A budget model calculates total cost in cell F2 as =B2*C2+D2, where B2 is 500 units, C2 is a variable cost of $6 per unit and D2 is fixed co…