Can someone help me answer Chapter 12 problem 1 in Financial Analysis with Microsoft Excel 7th edition?

Telluride Tours is currently evualuating two mutually exclusive investments. After doing a scenario analysis and applying probabilities to each scenario, it has determined that the investments have the following distribustions around the expected NPVs:

Probability	NPV A	NPV B
10%	(30,600.00)	(11,475.00)
20%	(7,650.00)	1,913.00
40%	15,300.00	15,300.00
20%	38,250.00	28,688.00
10%	61,200.00	42,075.00

Several members of the management team have suggested that Project A should be selected because it has a higher potential NPV. Other members have suggested that Project B appears to be more conservative and should be selected. They have asked you to resolve this question.

a. calculate the expected NPV for both projects. Can the question be resolved with this information alone?

b. calculate the variance and standard deviation of the NPVs for both projects. Which project appears to be risker?

c. calculate the coefficient of variation for both projects. Does this change your opinion from part b?

d. Calculate the probablity of a negative NPV for both projects.

e. Which project should be accepted? Why?

Can you explain how you found these ansewers in excel.