Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account.
Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.
Returns the interest rate for a fully invested security.
Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period, the prorated depreciation is taken into account. The function is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.
Converts a Roman numeral to an Arabic numeral.
Returns the annual yield of a security that pays interest at maturity.
Returns the price per $100 face value of a security that pays interest at maturity.
Returns the amount received at maturity for a fully invested security.
Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent. For example, you need to find 10 people with excellent reflexes, and you know the probability that a candidate has these qualifications is 0.3. NEGBINOM.DIST calculates the probability that you will interview a certain number of unqualified candidates before finding all 10 qualified candidates.
Calculates standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data.
Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices. The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).
Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Returns the yield for a Treasury bill.
The COUPDAYBS function returns the number of days from the beginning of a coupon period until its 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 a number that represents the next coupon date after the settlement date.
Returns the inverse of the gamma cumulative distribution. If p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
1, number 2,… Number 1 is , subsequent numbers are Number 1, number 2,… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness.
Returns the inverse of the F probability distribution. If p = F.DIST(x,...), then F.INV(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of income diversity.
Estimates variance based on a sample.
Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Returns a number that represents the previous coupon date before the settlement date.
Returns the price per $100 face value for a Treasury bill.
Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
Return the gamma function value.
Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.
Calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.
The MUNIT function returns the unit matrix for the specified dimension.
This Excel function returns the sum of the difference of the squares of corresponding values in two arrays.
Returns the yield of a security that has an odd (short or long) last period.
Returns the price per $100 face value of a security having an odd (short or long) last coupon period.
Returns the bond-equivalent yield for a Treasury bill.
Returns the yield of a security that has an odd (short or long) first period.
Estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Returns the price per $100 face value of a security having an odd (short or long) first period.
Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.
Calculates variance based on the entire population.
Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.
Calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
Returns the value of the density function for a standard normal distribution.
Returns the natural logarithm of the gamma function, Γ(x).
Returns the natural logarithm of the gamma function, Γ(x).