You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range. From that calculation you ...

Find out how to use Microsoft Excel to calculate the coupon rate of a bond using its par value and the amount and frequency of its coupon payments.