Lesson 6
Mystery Computations
Problem 1
What could be the formula used to compute the value shown in cell B3?
![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.](https://cms-im.s3.amazonaws.com/Q6ugPLceB8Suij9xea2hLDm2?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2013.42.07.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252013.42.07.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240726%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240726T235528Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=97fa55f81a4511e0c936e1875d76e39d23a037f89ccb8f8a0f026296c939589f)
= B3 * B4
= A2 + A5
= A2 * A5
= Sum(A2:A6)
Solution
For access, consult one of our IM Certified Partners.
Problem 2
What number will appear in cell B2 when the user presses Enter?
![A spreadsheet.](https://cms-im.s3.amazonaws.com/WaWTLJGioAGyZ3Rc2zrWRSE6?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2013.54.47.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252013.54.47.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240726%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240726T235528Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=859f175ee6d0d3d5f5f857760539d1ffaea7750ab423c743fd460ead07f1967b)
Solution
For access, consult one of our IM Certified Partners.
Problem 3
Select all the formulas that could be used to calculate the value in cell B4.
![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.](https://cms-im.s3.amazonaws.com/Q6ugPLceB8Suij9xea2hLDm2?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2013.42.07.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252013.42.07.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240726%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240726T235528Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=97fa55f81a4511e0c936e1875d76e39d23a037f89ccb8f8a0f026296c939589f)
=Product(A2:A6)
=Sum(A2:A6)
= A2 + A3
= A2 * A3
= A3 * A4 * A5
= A3 + A4 + A5
Solution
For access, consult one of our IM Certified Partners.
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.
![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.](https://cms-im.s3.amazonaws.com/1trtY1gXvaBoQom2KSGToLRw?response-content-disposition=inline%3B%20filename%3D%22Screenshot%202018-09-17%2013.56.41.png%22%3B%20filename%2A%3DUTF-8%27%27Screenshot%25202018-09-17%252013.56.41.png&response-content-type=image%2Fpng&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAXQCCIHWF3XOEFOW4%2F20240726%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240726T235528Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=b1b4ef7283693701b53bd855a63edc394cd3425f94cd8bf3d8e72ef4b06c26b1)
Solution
For access, consult one of our IM Certified Partners.
Problem 5
The dot plot displays the number of books read by students during the semester.
- 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.
Solution
For access, consult one of our IM Certified Partners.
(From Unit 1, Lesson 5.)Problem 6
The dot plot displays the number of families living in different blocks of a town.
- 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.
Solution
For access, consult one of our IM Certified Partners.
(From Unit 1, Lesson 5.)