Here is a spreadsheet showing the computations for a different version of the birthday trick:

A spreadsheet with rows 1 to 10 and columns A and B. A 1 contains “month”. A 2, “day”.  A 4, “multiply month by 50”. A 5, “add 30”. A 6, “multiply by 2”. A 7, “add the day”. A 8, “subtract 60”. B 1, 7. B 2, 4. All other cells are blank.

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.

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

1. \(\frac25\) of 35
2. \(25 \div \frac53\)
3. \(\left( \frac{1}{11} \right) ^ 4\)
4. The average of 0, 3, and 17

The values represent 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

1. What is the median? Interpret this value in the situation.
2. What is the IQR?

The values represent 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

1. What is the mean?
2. What is the MAD?