Please provide step-by-step explanations and how to make a graph and indicate which Microsoft platform you used to graph and please provide the solutions. Thank you so much!

6-1 Yield Curves Assume that yields on U.S. Treasury securities were as follows:

TermRate

6 months4.69%

1 year5.49

2 years5.66

3 years5.71

4.years5.89

5 years6.05

10 years6.12

20 years6.64

30 years6.76

a.Plot a yield curve based on these data.

b.What type of yield curve is shown?

c.What information does this graph tell you?

d.Based on this curve, if you needed to borrow short term and renew the loan or borrow long term? Explain.