Mathematics, 13.04.2021 04:10 jorgefrom584

H. O.T. S. FOCUS ON HIGHER ORDER THINKING B 13. Multistep In a spreadsheet, before entering any data values, first enter "mean="into cell A2 and the formula =AVERAGE(A1:J1) into cell B2. Next, enter "MAD =" into cell A3 and the formula =AVEDEV(A1:J1) into cell B3. You should see #DIV/0! in cell B2 and #NUM! in cell B3 as shown. Now do the following: 1 2 3 #DIV/0! #NUM! mean = MAD = a. Enter"1"into cell A1. What do you get for the mean and the MAD of the data set? Explain why this makes sense. AD of

Answers: 2

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 16:20, whitneyt3218

7.(03.01 lc)which set represents the range of the function shown? {(-1, 5), (2,8), (5, 3), 13, -4)} (5 points){-1, 2, 5, 13){(5, -1), (8, 2), (3,5), (-4, 13)){-4, 3, 5, 8}{-4, -1, 2, 3, 5, 5, 8, 13}

Answers: 3

continue

Mathematics, 21.06.2019 18:00, tasnimsas3

Plz a. s. a. p. the table shows the number of male and female contestants who did not win a prize. what is the probability that a randomly selected contestant won a prize, given that the contestant was female? write the probability as a percent. round to the neares tenth, if needed.

Answers: 1

continue

Mathematics, 21.06.2019 18:30, Raewolf25

Need an artist designed a badge for a school club. figure abcd on the coordinate grid below shows the shape of the badge: the badge is enlarged and plotted on the coordinate grid as figure jklm with point j located at (2, -2) and point m is located at (5, 4). which of these could be the coordinates for point l? a. (2, 4) b. (8, 4) c. (5, 1) d. (5, 7)

Answers: 2

continue

Mathematics, 21.06.2019 23:00, ManBun99

Assume that there is a 11% rate of disk drive failure in a year. a. if all your computer data is stored on a hard disk drive with a copy stored on a second hard disk drive, what is the probability that during a year, you can avoid catastrophe with at least one working drive? b. if copies of all your computer data are stored on four independent hard disk drives, what is the probability that during a year, you can avoid catastrophe with at least one working drive?

Answers: 2

continue

You know the right answer?

H. O.T. S. FOCUS ON HIGHER ORDER THINKING B 13. Multistep In a spreadsheet, before entering any data...