Lesson 7

Spreadsheet Computations

Let's use spreadsheets as calculators.

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.

A spreadsheet.
  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.

Dot plot
Box plot from 2 point 8 to 5 point 4 by 0.1's. Whisker from 2 point 9 to 3 point 1. Box from 3 point 1 to 4 point 5 with vertical line at 3 point 5, Whisker from 4 point 1 to 5 point 2.
  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.

Histogram from 200 to 1,200 by 200’s. lumens. Beginning at 200 up to but not including 400, height of bar at each interval is 9, 19, 7, 5, 4.

 

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

Dot plot from 0 to 5 by 1’s. goals scored. Beginning at 0, number of dots above each increment is 3, 4, 2, 0, 1.
  1. If possible, find the mean. If not possible, explain why not.
  2. If possible, find the median. If not possible, explain why not.
  3. Did the soccer team ever score exactly 3 goals in one of the games?
(From Unit 1, Lesson 2.)