arguellesjavier15
arguellesjavier15
13.04.2021 • 
Mathematics

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​

Solved
Show answers

Ask an AI advisor a question