Lesson 8
Spreadsheet Shortcuts
Problem 1
Technology required. Open a blank spreadsheet. Use "fill down" to recreate this table of equivalent ratios. You should not need to type anything in rows 3–10.
![A spreadsheet with rows 1 to 10 and columns A to B. Column A contains numbers increasing by 3. 3, 6, 9, until 30. Column B contains numbers increasing by 7. 7, 14, 21, until 70.](https://cms-im.s3.amazonaws.com/jUnHYupBGm627SegkHKAaddr?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2014.32.16.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252014.32.16.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240727T002328Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=f951cb932fd646d137df2564af036423ffdc36451510327702fcff15b69ab244)
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 list of numbers is made with the pattern: Start with 11, and subtract 4 to find the next number.
Here is the beginning of the list: 11, 7, 3, . . .
Explain how you could use "fill down" in a spreadsheet to find the tenth number in this list. (You do not need to actually find this number.)
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
Problem 3
Here is a spreadsheet showing the computations for a different version of the birthday trick:
![A spreadsheet.](https://cms-im.s3.amazonaws.com/u5Qi7jxh63FhFaxXeDyVR4sx?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2014.45.20.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252014.45.20.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240727T002328Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=3aa59b3353ca68e9411a059098e377efb404bcb5be51f4692211853e74c33e3f)
Explain what formulas you would enter in cells B4 through B8 so that cell B8 shows a number representing the month and day. (In this example, cell B8 should show 704.) If you have access to a spreadsheet, try your formulas with a month and day to see whether it works.
Solution
Teachers with a valid work email address can click here to register or sign in for free access to Formatted Solution.
Problem 4
Write a formula you could type into a spreadsheet to compute the value of each expression.
- \(\frac25\) of 35
- \(25 \div \frac53\)
- \(\left( \frac{1}{11} \right) ^ 4\)
- The average of 0, 3, and 17
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 7.)Problem 5
The data set represents the number of cars in a town given a speeding ticket each day for 10 days.
- 2
- 4
- 5
- 5
- 7
- 7
- 8
- 8
- 8
- 12
- What is the median? Interpret this value in the situation.
- What is the IQR?
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
The data set represents the most recent sale price, in thousands of dollars, of ten homes on a street.
- 85
- 91
- 93
- 99
- 99
- 99
- 102
- 108
- 110
- 115
- What is the mean?
- What is the MAD?
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.)