4.) Find the following: a. In an Excel spreadsheet, a set of data is stored in a
ID: 3074907 • Letter: 4
Question
4.) Find the following:
a.
In an Excel spreadsheet, a set of data is stored in ascending order in cells A1, A2, A3, ..., A18. Write an Excel formula that would calculate the median of this set of data.
=MEDIAN(A1,A18)
=MED(A1:A18)
=MEAN(A1:A18)
=MEDIAN(A1:A18)
b.)
Seven cash registers at a supermarket averaged a mean sales of $2900.88 in one day. What were the total sales?
$29,844.44
$2,306.16
$20,306.16
$29,000.00
c.)
A manufacturer of batteries took a sample of 13 batteries from a day's production and used them continuously until they were drained. He recorded the number of hours it took for each battery to drain: 348, 420, 310, 546, 264, 453, 638, 1018, 518, 270, 498, 298, and 565. Find the range of this data.
754 hours
1235 hours
472 hours
172 hours
1472 hours
=MEDIAN(A1,A18)
=MED(A1:A18)
=MEAN(A1:A18)
=MEDIAN(A1:A18)
Explanation / Answer
4)a) MEDIAN(A1 : A18)
Option - D is correct.
b) The total sale = 7 * 2900.88 = 20306.16
Option-C is correct.
C) Range = 1018 - 264 = 754
Option - A is correct.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.