Was hoping that someone could helpme with the spreadsheet below and the related questions. Thank you.

Consider the following probability distribution of returns estimated for a proposed project that involvesa new ultrasound machine:

State of Economy Probability of Occurrence Rate of Return

Very Poor 0.1 -10%

Poor 0.2 0

Average 0.4 10%

Good 0.2 20%

Very Good 0.1 30%

1) What is the expected rate of return on the project?

2) What is the project's standard deviation of returns?

3) What is the project's coefficient of variation (CV) of returns?

4) What type of risk does the standard deviation and CV measure?

5) In what situation is this risk relevant?