Enter a VLOOKUP formula in cell C7. Specifically, consider a table represented by the range A3:B5. The inputs (number of PAC-12 conference wins in basketball) are in column A and their associated outputs (probability of winning the conference) are in column B. The table contains three such options (winning 18, 19, or 20 conference games), and the probabilities should sum to 100% (i.e., enter any three probabilities that you want to in cells B3, B4, and B5, but be certain that they sum to 100%). Enter an integer between 18 and 20 in Cell A7. In cell C7, use VLOOKUP to provide the probability of wining the conference, given the number of wins represented by the value in cell A7.

needs to be in excel.