# Lesson 6

Mystery Computations

### 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)

### Solution

For access, consult one of our IM Certified Partners.

### Problem 2

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

### Solution

For access, consult one of our IM Certified Partners.

### 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

### Solution

For access, consult one of our IM Certified Partners.

### 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.

### Solution

For access, consult one of our IM Certified Partners.

### Problem 5

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

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

### Solution

For access, consult one of our IM Certified Partners.

(From Unit 1, Lesson 5.)

### Problem 6

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

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

### Solution

For access, consult one of our IM Certified Partners.

(From Unit 1, Lesson 5.)