Sovi.AI - AI Math Tutor

Scan to solve math questions

QUESTION IMAGE

technological graphing lets use technology to represent data. warm - up…

Question

technological graphing lets use technology to represent data. warm - up it begins with data technology required. open a spreadsheet window and enter the data so that each value is in its own cell in column a. 1 how many values are in the spreadsheet? explain your reasoning. 2 if you entered the data in the order that the values are listed, the number 7 is in the cell at position a1 and the number 5 is in cell a5. list all of the cells that contain the number 13. 3 in cell c1 type the word “sum,” in c2 type “mean,” and in c3 type “median.” you may wish to double - click or drag the vertical line between columns c and d to allow the entire words to be seen.

Explanation:

Step1: Count data values

Count the number of cells in column A of both tables. There are 20 cells in total.

Step2: Locate number 13

Scan through the values in column A of both tables. The number 13 is in cells A4, A12, A14.

Answer:

  1. There are 20 values in the spreadsheet because there are 20 cells in column A of the two - table data set.
  2. The cells that contain the number 13 are A4, A12, A14.
  3. (This part is an instruction, not a question with an answer. Just follow the instruction to type "Sum" in C1, "Mean" in C2 and "Median" in C3)