Lesson 7
Spreadsheet Computations
Problem 1
Write a formula you could type into a spreadsheet to compute the value of each expression.
- \((19.2) \boldcdot 73\)
- \(1.1^{5}\)
- \(2.34 \div 5\)
- \(\frac{91}{7}\)
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
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?
= 7 * 45
= 7 / 45
= 7 * (3 / 4)
= 7 / (3 / 4)
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
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.
= 3.4 * 5.6
= 3.4 * 5.6 * 2
= 3.4 * 5.6 / 2
= 3.4 * 5.6 * (1/2)
= (3.4 * 5.6) / 2
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
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.

- 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.
- How would the output of the formula change if the value in cell B1 was changed to 10?
- What would change about the sparkling grape juice if the value in B3 was changed to 10?
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
Problem 5
The dot plot and the box plot represent the same distribution of data.
- How does the median change when the highest value, 5.2, is removed?
- How does the IQR change when the highest value, 5.2, is removed?
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
(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.
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
(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.
- If possible, find the mean. If not possible, explain why not.
- If possible, find the median. If not possible, explain why not.
- Did the soccer team ever score exactly 3 goals in one of the games?
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
(From Unit 1, Lesson 2.)