Excel Formulas

Returns values along a linear trend

Returns the mean of the interior of a data set

Returns the probability associated with a Student's t-test

Estimates variance based on a sample

Calculates variance based on the entire population

Returns the Weibull distribution

Returns the one-tailed probability-value of a z-test

Returns the accrued interest for a security that pays periodic interest

Returns the accrued interest for a security that pays interest at maturity

Returns the depreciation for each accounting period using depreciation coefficient

Returns the depreciation for each accounting period

Returns the number of days from the beginning of the coupon period to the settlement date

Returns the number of days in the coupon period that contains the settlement date

Returns the number of days from the settlement date to the next coupon date

Returns the next coupon date after the settlement date

Returns the number of coupons payable between the settlement date and maturity date

Returns the previous coupon date before the settlement date

Returns the discount rate for a security

Returns the annual duration of a security with periodic interest payments

Returns the modified Macauley duration for a security with an assumed par value of $100