Unit 3, Lesson 6

Mystery Computations (Optional)

$Course Icon$

Integrated Math 1

Practice

Problem 1

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

<p>A spreadsheet with rows 1 to 6 and columns A to B. A 1 contains “change these”. A 2, 7. A 3, 0. A 4, 13. A 5, 50. A 6, negative 1. B 1, “what happens here?” B 2, 20. B 3, 350. B 4, 0. B 5, 69. B 6, blank.</p>

= B3 * B4
= A2 + A5
= A2 * A5

= Sum(A2:A6)

to access Practice Problem Solutions.

Problem 2

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

to access Practice Problem Solutions.

Problem 3

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

=Product(A2:A6)
=Sum(A2:A6)
= A2 + A3
= A2 * A3
= A3 * A4 * A5
= A3 + A4 + A5

to access Practice Problem Solutions.

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.

<p>A spreadsheet with rows 1 to 5 and columns A to B. A 1 contains “change these”. A 2, 10. A 3, 5. A 4, 0. A 5, negative 7. B 1, “what happens here?” B 2, 0. All other cells are blank.</p>

to access Practice Problem Solutions.

Problem 5

ForLesson 5: Calculating Measures of Center and Variability

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

<p>Dot plot from 3 to 14 by 1’s. Number of books read. Beginning at 3, number of dots above each increment is 0, 1, 3, 5, 6, 2, 1, 0, 0, 0, 1, 0.</p>

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.

to access Practice Problem Solutions.

Problem 6

ForLesson 5: Calculating Measures of Center and Variability

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

<p>Dot plot from 3 to 11 by 1’s. Number of families. Beginning at 3, number of dots above each increment is 0, 1, 3, 5, 6, 5, 3, 1, 0.</p>

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.

to access Practice Problem Solutions.

Navigation

Gradeband

Course

Unit

Lesson

Settings

Audience

Assessment Access

Lesson | Practice | Loading...

Settings

Audience

Assessment Access

Mystery Computations (Optional)

Practice

Problem 1

Problem 2

Problem 3

Problem 4

Problem 5

Problem 6

Lesson 6 Resources