Given the following set of data, do the tasks from (a) through (j). When asked to...

 

Transcribed Image Text:

Given the following set of data, do the tasks from (a) through (j). When asked to perform operations on the numbers contained in a cell, do use the cell reference (e.g., A1, A2, A3) instead of the numeric values (e.g., 13, 34, 40). A 12 13 34 3 40 4 29 5 11 6 16 7 8 43 9 10 LETS 1 0 58 (a) Calculate the minimum of the data set. (b) Calculate the volume of a sphere (V=r) with r being the value contained in cell A5. (c) Calculate the sum of the numbers in cells A1, A4, A7, and A1C. (d) Calculate the variance of the entire data set. (e) Convert the number in A2 (in meters) to inches. (f) Calculate the sum of the square roots of all the numbers in one single line of formula. (g) Calculate log (the number in A5). (h) The number in A8 is in degrees. Compute the tangent of the number in A8. (i) Consider the formula: if (A10>A2, Yes, NO) What is wrong with it? (i) Label Al to A5 as a matrix named M1 and label A6 to A10 as a matrix named M2. Can you do so? Justify your answer. Given the following set of data, do the tasks from (a) through (j). When asked to perform operations on the numbers contained in a cell, do use the cell reference (e.g., A1, A2, A3) instead of the numeric values (e.g., 13, 34, 40). A 12 13 34 3 40 4 29 5 11 6 16 7 8 43 9 10 LETS 1 0 58 (a) Calculate the minimum of the data set. (b) Calculate the volume of a sphere (V=r) with r being the value contained in cell A5. (c) Calculate the sum of the numbers in cells A1, A4, A7, and A1C. (d) Calculate the variance of the entire data set. (e) Convert the number in A2 (in meters) to inches. (f) Calculate the sum of the square roots of all the numbers in one single line of formula. (g) Calculate log (the number in A5). (h) The number in A8 is in degrees. Compute the tangent of the number in A8. (i) Consider the formula: if (A10>A2, Yes, NO) What is wrong with it? (i) Label Al to A5 as a matrix named M1 and label A6 to A10 as a matrix named M2. Can you do so? Justify your answer.