22. (11 points in total) Given a range table B3:C7 as below: FILL IN CHART

	A	B	C
1	0.7321
2	0.0833	Cumulative Prob.	Possible value
3		0	10
4		0.2	20
5		0.64	30
6		0.8	40
7		1
8

(You may verify your following answers in Excel)

(22.1) What is the value of function =VLOOKUP(0.15, B3:C7, 2)?

(22.2) What is the value of function =VLOOKUP(0.85, B3:C7, 2)?

(22.3) What is the value of function =VLOOKUP(A1, B3:C7, 2)? (Note: A1 a cell address)

(22.4) Write out a =VLOOKUP() function in which value to look up is 0.57443 and range table is in B3:C7.

(22.5) (3 points) Suppose you have =VLOOKUP(A1, B3:C7, 2) in cell F15, and you want to copy this function to F16 to find the possible value associated with A2. What modification do you need to do with the function before copying it? Show the function in cell F15 after modification.