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.