[Solved]-Question 1 20 Points Given Following Set Data Tasks J Asked Perform Operations Numbers Co Q37191978

Hi, I need some excel help. Thank you in advance.

Question 1 (20 points) 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) 13 34 40 29 4 5 16 1 43 0 58 9 10 (a) Calculate the minimum of the data set. 4 (b) Calculate the volume of a spherer3) with r being the value contained in cell 3 A5 (c) Calculate the sum of the numbers in cells A1, A4, A7, and A10 (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 log2(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? (j) 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. Show transcribed image text Question 1 (20 points) 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) 13 34 40 29 4 5 16 1 43 0 58 9 10 (a) Calculate the minimum of the data set. 4 (b) Calculate the volume of a spherer3) with r being the value contained in cell 3 A5 (c) Calculate the sum of the numbers in cells A1, A4, A7, and A10 (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 log2(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? (j) 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.

Expert Answer

---

Answer to Question 1 (20 points) Given the following set of data, do the tasks from (a) through (j). when asked to perform operati… . . .