Lesson 7

Problem 1

Write a formula you could type into a spreadsheet to compute the value of each expression.

1. $$(19.2) \boldcdot 73$$
2. $$1.1^{5}$$
3. $$2.34 \div 5$$
4. $$\frac{91}{7}$$

Problem 2

A long-distance runner jogs at a constant speed of 7 miles per hour for 45 minutes. Which spreadsheet formula would give the distance she traveled?

A:

= 7 * 45

B:

= 7 / 45

C:

= 7 * (3 / 4)

D:

= 7 / (3 / 4)

Problem 3

In a right triangle, the lengths of the sides that make a right angle are 3.4 meters and 5.6 meters. Select all the spreadsheet formulas that would give the area of this triangle.

A:

= 3.4 * 5.6

B:

= 3.4 * 5.6 * 2

C:

= 3.4 * 5.6 / 2

D:

= 3.4 * 5.6 * (1/2)

E:

= (3.4 * 5.6) / 2

Problem 4

This spreadsheet should compute the total ounces of sparkling grape juice based on the number of batches, ounces of grape juice in a single batch, and ounces of sparkling water in a single batch.

1. Write a formula for cell B4 that uses the values in cells B1, B2, and B3, to compute the total ounces of sparkling grape juice.
2. How would the output of the formula change if the value in cell B1 was changed to 10?
3. What would change about the sparkling grape juice if the value in B3 was changed to 10?

Problem 5

The dot plot and the box plot represent the same distribution of data.

1. How does the median change when the highest value, 5.2, is removed?
2. How does the IQR change when the highest value, 5.2, is removed?
(From Unit 1, Lesson 5.)

Problem 6

Describe the shape of the distribution shown in the histogram which displays the light output, in lumens, of various light sources.

(From Unit 1, Lesson 4.)

Problem 7

The dot plot represents the distribution of the number of goals scored by a soccer team in 10 games.