Question content area top

Part $1$

Enhance the accompanying Treasury Yield Rates database file to perform a database query that finds the rate associated with any day and term.$($This is a challenging question because you will not be able to use the term headers in a MATCH function.$$ Hint: Add a row that assigns a code from $1$ to $11$ for each term. Then use the code for your input value. You might also use a lookup function to convert the code back to the actual term as part of the$$ output.$)$

LOADING... Click the icon to view the Treasury Yield Rates database.

Question content area bottom

Part $1$

Add a row that assigns a code from $1$ to $11$ for each term.

$($Type whole numbers. Use ascending$$ order.$)$

A

B

C

D

E

F

G

H

I

J

K

L

$1$

Term Code

$$

$1$

$$

$2$

$$

$3$

$$

$4$

$$

$5$

$$

$6$

$$

$7$

$$

$8$

$$

$9$

$$

$10$

$$

$11$

$2$

Bold Day left parenthesis Jan $2008$ right parenthesis

$1$ mo

$3$ mo

$6$ mo

$1$ yr

$2$ yr

$3$ yr

$5$ yr

$7$ yr

$10$ yr

$20$ yr

$30$ yr

$3$

$2$

$3\mathrm{.}11$

$3\mathrm{.}26$

$3\mathrm{.}32$

$3\mathrm{.}17$

$2\mathrm{.}88$

$2\mathrm{.}89$

$3\mathrm{.}28$

$3\mathrm{.}54$

$3\mathrm{.}91$

$4\mathrm{.}39$

$4\mathrm{.}35$

$4$

$3$

$3\mathrm{.}18$

$3\mathrm{.}24$

$3\mathrm{.}13$

$3\mathrm{.}13$

$2\mathrm{.}83$

$2\mathrm{.}85$

$3\mathrm{.}26$

$3\mathrm{.}54$

$3\mathrm{.}91$

$4\mathrm{.}41$

$4\mathrm{.}37$

$5$

$4$

$3\mathrm{.}2$

$3\mathrm{.}2$

$3\mathrm{.}2$

$3\mathrm{.}06$

$2\mathrm{.}74$

$2\mathrm{.}75$

$3\mathrm{.}18$

$3\mathrm{.}47$

$3\mathrm{.}88$

$4\mathrm{.}4$

$4\mathrm{.}36$

$6$

$7$

$3\mathrm{.}27$

$3\mathrm{.}27$

$3\mathrm{.}29$

$3\mathrm{.}11$

$2\mathrm{.}76$

$2\mathrm{.}76$

$3\mathrm{.}16$

$3\mathrm{.}46$

$3\mathrm{.}86$

$4\mathrm{.}37$

$4\mathrm{.}34$

$7$

$8$

$3\mathrm{.}31$

$3\mathrm{.}25$

$3\mathrm{.}27$

$3\mathrm{.}11$

$2\mathrm{.}76$

$2\mathrm{.}76$

$3\mathrm{.}16$

$3\mathrm{.}47$

$3\mathrm{.}86$

$4\mathrm{.}39$

$4\mathrm{.}35$

$8$

$9$

$3\mathrm{.}34$

$3\mathrm{.}2$

$3\mathrm{.}2$

$3\mathrm{.}04$

$2\mathrm{.}69$

$2\mathrm{.}69$

$3\mathrm{.}1$

$3\mathrm{.}4$

$3\mathrm{.}82$

$4\mathrm{.}35$

$4\mathrm{.}32$

$9$

$10$

$3\mathrm{.}43$

$3\mathrm{.}24$

$3\mathrm{.}21$

$3\mathrm{.}04$

$2\mathrm{.}71$

$2\mathrm{.}74$

$3\mathrm{.}16$

$3\mathrm{.}49$

$3\mathrm{.}91$

$4\mathrm{.}47$

$4\mathrm{.}44$

Part $2$

The term code $2$ and day $10$ have been entered into cells O$2$ and$$ O$3,$ respectively. Use a MATCH function with this term code to find the rate associated with this day and term. Select the correct formula for cell O$5.$