Question

9.1 it begins with data
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 the vertical line between columns c and d to allow the entire words to

Explanation:

Step1: Count data values

Count the number of cells in column A with values. There are 10 values (7, 8, 4, 13, 5, 15, 14, 8, 12, 2).

Step2: Locate number 13

Find the position of 13 in the data - set. The number 13 is in cell A4.

Answer:

1. There are 10 values in the spreadsheet because there are 10 non - empty cells in column A with data values.
2. The cell that contains the number 13 is A4.