does this seem right so far? now how do i calculate the duration now for each coupon? please show me how in excel

Part 1: Duration and Coupon Interest Consider a five-year $1,000 face value, Treasury bond with a 10 percent yield to maturity selling at par. A) Calculate the duration if the semiannual coupon is 7% (5 Points) B) Calculate the duration if the semiannual coupon is 12% ( 5 Points) C) Calculate the duration if the semiannual coupon is 17% ( 5 Points) D) Plot the relationship between coupon interest rate ( x-axis) and the duration ( y-axis). Be sure to label the y-axis, x-axis, and chart title (5 Points) In your report, identify and contment on the relationship between duration and coupon interest rate. 8) 17k capon