Statistical
★ 5 · ◉ 40 · Excel 2010
=BETA.INV()
.INV(probability,alpha,beta,[A],[B])
=BETA.INV(probability,alpha,beta,[A],[B])
Probability & Hypothesis Testing
Statistical
★ 5 · ◉ 40 · Excel 2016
=FORECAST.ETS.STAT()
Returns a statistical value as a result of time series forecasting.
=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])
Forecasting & Trends
Math & Trig
★ 5 · ◉ 38 · Excel 2013
=ARABIC()
Converts a Roman numeral to an Arabic numeral.
=ARABIC( text )
Scientific & Unit Conversion
Statistical
★ 5 · ◉ 35 · All versions
=KURT()
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.
=KURT(number1, [number2], ...)
Descriptive Statistics
Financial
★ 5 · ◉ 33 · All versions
=INTRATE()
Returns the interest rate for a fully invested security.
=INTRATE(settlement, maturity, investment, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 32 · All versions
=YIELDMAT()
Returns the annual yield of a security that pays interest at maturity.
=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 30 · All versions
=PRICEMAT()
Returns the price per $100 face value of a security that pays interest at maturity.
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 29 · All versions
=RECEIVED()
Returns the amount received at maturity for a fully invested security.
=RECEIVED(settlement, maturity, investment, discount, [basis])
Financial Calculations
Securities & Bonds
Statistical
★ 4 · ◉ 62 · Excel 2010
=GAMMA.INV()
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.
=GAMMA.INV(probability,alpha,beta)
Probability & Hypothesis Testing
Statistical
★ 4 · ◉ 59 · Excel 2010
=NEGBINOM.DIST()
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.
=NEGBINOM.DIST(number_f,number_s,probability_s,cumulative)
Probability & Hypothesis Testing
Statistical
★ 4 · ◉ 55 · Excel 2010
=LOGNORM.INV()
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.
=LOGNORM.INV(probability, mean, standard_dev)
Probability & Hypothesis Testing
Database
★ 4 · ◉ 50 · All versions
=DSTDEV()
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.
=DSTDEV(database, field, criteria)
Conditional Aggregation
Statistical
★ 4 · ◉ 50 · All versions
=STDEVPA()
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).
=STDEVPA(value1, [value2], ...)
Descriptive Statistics
Financial
★ 4 · ◉ 48 · All versions
=COUPDAYBS()
The COUPDAYBS function returns the number of days from the beginning of a coupon period until its settlement date.
=COUPDAYBS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 46 · All versions
=DOLLARDE()
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).
=DOLLARDE(fractional_dollar, fraction)
Financial Calculations
Securities & Bonds
Statistical
★ 4 · ◉ 45 · Excel 2010
=F.INV()
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.
=F.INV(probability,deg_freedom1,deg_freedom2)
Probability & Hypothesis Testing
Financial
★ 4 · ◉ 45 · All versions
=TBILLPRICE()
Returns the price per $100 face value for a Treasury bill.
=TBILLPRICE(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 43 · All versions
=COUPDAYSNC()
Returns the number of days from the settlement date to the next coupon date.
=COUPDAYSNC(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 43 · All versions
=TBILLYIELD()
Returns the yield for a Treasury bill.
=TBILLYIELD(settlement, maturity, pr)
Financial Calculations
Securities & Bonds
Statistical
★ 4 · ◉ 42 · Excel 2013
=SKEW.P()
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.
=SKEW.P(number 1, [number 2],…)
Descriptive Statistics
Statistical
★ 4 · ◉ 42 · All versions
=VARA()
Estimates variance based on a sample.
=VARA(value1, [value2], ...)
Descriptive Statistics
Financial
★ 4 · ◉ 41 · All versions
=COUPNCD()
Returns a number that represents the next coupon date after the settlement date.
=COUPNCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 40 · All versions
=COUPNUM()
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
=COUPNUM(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 40 · All versions
=COUPPCD()
Returns a number that represents the previous coupon date before the settlement date.
=COUPPCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 40 · All versions
=DOLLARFR()
Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.
=DOLLARFR(decimal_dollar, fraction)
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 39 · All versions
=COUPDAYS()
Returns the number of days in the coupon period that contains the settlement date.
=COUPDAYS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Statistical
★ 3 · ◉ 63 · Excel 2013
=GAUSS()
Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.
=GAUSS(z)
Probability & Hypothesis Testing
Math & Trig
★ 3 · ◉ 59 · All versions
=SUMX2MY2()
This Excel function returns the sum of the difference of the squares of corresponding values in two arrays.
=SUMX2MY2(array_x, array_y)
Scientific & Unit Conversion
Statistical
★ 3 · ◉ 57 · All versions
=FISHERINV()
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.
=FISHERINV(y)
Probability & Hypothesis Testing
Statistical
★ 3 · ◉ 56 · Excel 2013
=GAMMA()
Return the gamma function value.
=GAMMA(number)
Probability & Hypothesis Testing
Scientific & Unit Conversion
Database
★ 3 · ◉ 55 · All versions
=DSTDEVP()
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.
=DSTDEVP(database, field, criteria)
Conditional Aggregation
Math & Trig
★ 3 · ◉ 51 · Excel 2013
=MUNIT()
The MUNIT function returns the unit matrix for the specified dimension.
=MUNIT(dimension)
Scientific & Unit Conversion
Financial
★ 3 · ◉ 49 · All versions
=ODDLPRICE()
Returns the price per $100 face value of a security having an odd (short or long) last coupon period.
=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 48 · All versions
=ODDLYIELD()
Returns the yield of a security that has an odd (short or long) last period.
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Database
★ 3 · ◉ 47 · All versions
=DPRODUCT()
Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.
=DPRODUCT(database, field, criteria)
Conditional Aggregation
Lookup & Reference
★ 3 · ◉ 45 · All versions
=AREAS()
Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.
=AREAS(reference)
Worksheet Info & Navigation
Statistical
★ 3 · ◉ 45 · All versions
=FISHER()
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.
=FISHER(x)
Probability & Hypothesis Testing
Financial
★ 3 · ◉ 42 · All versions
=ODDFPRICE()
Returns the price per $100 face value of a security having an odd (short or long) first period.
=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 41 · All versions
=TBILLEQ()
Returns the bond-equivalent yield for a Treasury bill.
=TBILLEQ(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Statistical
★ 3 · ◉ 41 · All versions
=VARPA()
Calculates variance based on the entire population.
=VARPA(value1, [value2], ...)
Descriptive Statistics
Database
★ 3 · ◉ 40 · All versions
=DVAR()
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.
=DVAR(database, field, criteria)
Conditional Aggregation
Financial
★ 3 · ◉ 40 · All versions
=ODDFYIELD()
Returns the yield of a security that has an odd (short or long) first period.
=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Database
★ 3 · ◉ 34 · All versions
=DVARP()
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.
=DVARP(database, field, criteria)
Conditional Aggregation
Statistical
★ 2 · ◉ 51 · Excel 2013
=PHI()
Returns the value of the density function for a standard normal distribution.
=PHI(x)
Probability & Hypothesis Testing
Statistical
★ 2 · ◉ 43 · All versions
=GAMMALN()
Returns the natural logarithm of the gamma function, Γ(x).
=GAMMALN(x)
Probability & Hypothesis Testing
Statistical
★ 2 · ◉ 37 · Excel 2010
=GAMMALN.PRECISE()
Returns the natural logarithm of the gamma function, Γ(x).
=GAMMALN.PRECISE(x)
Probability & Hypothesis Testing