# Lesson 6

Mystery Computations

Let's explore spreadsheets.

### Problem 1

What could be the formula used to compute the value shown in cell B3?

A:

= B3 * B4

B:

= A2 + A5

C:

= A2 * A5

D:

= Sum(A2:A6)

### Problem 2

What number will appear in cell B2 when the user presses Enter?

### Problem 3

Select **all** the formulas that could be used to calculate the value in cell B4.

A:

=Product(A2:A6)

B:

=Sum(A2:A6)

C:

= A2 + A3

D:

= A2 * A3

E:

= A3 * A4 * A5

F:

= A3 + A4 + A5

### Problem 4

The formula in cell B2 is = Product(A2 : A5). Describe a way to change the contents of column A so that the value in cell B2 becomes -70.

### Problem 5

The dot plot displays the number of books read by students during the semester.

- Which measure of center would you use given the shape of the distribution in the dot plot? Explain your reasoning.
- Which measure of variability would you use? Explain your reasoning.

### Problem 6

The dot plot displays the number of families living in different blocks of a town.

- Which measure of center would you use, given the shape of the distribution in the dot plot? Explain your reasoning.
- Which measure of variability would you use? Explain your reasoning.