What is the CHOOSE Function? The CHOOSE Function is categorized under Excel Lookup and Reference functions. It will return a value from an array corresponding to the index number provided. The function will return the nth entry in a given list. As a financial analyst, the CHOOSE function is very useful when creating scenarios in…
What is the INDEX Function? The INDEX Function is categorized under Excel Lookup and Reference functions. The function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function. We can say it is an alternative way to do VLOOKUP. As a financial…
What is the Cell ADDRESS Function? The cell ADDRESS Function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or…
What is the STANDARDIZE Z-Score Function? The STANDARDIZE Function is available under Excel Statistical functions. It will return a normalized value (z-score) based on the mean and standard deviation. A z-score, or standard score, is used for standardizing scores on the same scale by dividing a score’s deviation by the standard deviation in a data…
What is the SLOPE Function? The SLOPE Function is categorized under Excel Statistical functions. It will return the slope of the linear regression line through the data points in known_y’s and known_x’s. In financial analysis, the SLOPE function can be used to calculate the beta of a stock. Slope / Beta Formula =SLOPE(known_y’s, known_x’s) The…
What is the Maturity RECEIVED Function? The RECEIVED Function is categorized under Excel Financial functions. It will calculate the amount received at maturity for a fully invested security. As a financial analyst, the RECEIVED function helps calculate the amount that we will get from an investment if the duration of the investment and interest rate…
What is the F Distribution Function? The F.DIST Function is categorized under Excel Statistical functions. It will calculate the probability density function or the Cumulative Distribution Function for the F Distribution. It measures the degree of diversity between two data sets. For example, if we wish to find out the variability in the IQ scores…
What is the F.INV (Inverse F Distribution) Function? The F.INV Function is categorized under Excel Statistical functions. It will calculate the inverse of the Cumulative F Distribution for a supplied probability. As a financial analyst, the function is useful in understanding the variability of two data sets. One example is when we wish to analyze…
What is the F.TEST Probability Function? The F.TEST Function is categorized under Excel Statistical functions. It will return the result of an F-test for two given arrays or ranges. The function will return the two-tailed probability that the variances in the two supplied arrays are not significantly different. As a financial analyst, the function is…
