Analyze the table below. It is a comparative study of how the weights of infants increase as they grow up. What LOOKUP function will you use to find out the weight of Infant 3 during month 2?

(Answers may vary, but your answer should include the following points.)

I used the Matrix LOOKUP function because I needed to find a value that’s at the intersection of a column and a row.

Next, I identified each parameter in the formula.

Finally, I put the values in the formula and computed the result as below:

INDEX (A2:E6, MATCH (A5, A2:A6, FALSE), MATCH (C2, A2:E2, FALSE))

The answer is 11.46.

Explanation:

sam knew that staying up late on a weeknight would effect his exam performance the next day. however, he believed that his friends would be mad at him if he didn't join them. peer pressure and the thought of losing his friends scared sam. he planned to meet them for a couple of hours and then leave early to study for the exam.