What is the NORMINV Function? The NORMINV Function is categorized under Excel Statistical functions. It will calculate the inverse of the normal cumulative distribution for the specified mean and standard deviation. Suppose we are given a normally distributed random variable that is denoted by x. For the value of x, if we wish to get…
What is the TBILLEQ Function? The TBILLEQ Function is categorized under Excel Financial functions. The function helps calculate the bond-equivalent yield of a T-bill. In financial analysis, if we wish to compare T-bills yields with bond yields, we can use TBILLEQ. Formula =TBILLEQ(settlement, maturity, discount) The TBILLEQ function uses the following arguments: Settlement (required argument) –…
What is a Collar Option Strategy? A collar option strategy, also referred to as a hedge wrapper or simply collar, is an options strategy employed to reduce both positive and negative returns of an underlying asset. It limits the return of the portfolio to a specified range and can hedge a position against potential volatility…
What is the Excel CONVERT units Function? The Excel CONVERT Function is an Excel Engineering Function. The function is useful for conversion of units from one measurement system to another measurement system. For example, CONVERT will help us to convert pounds to kilograms, feet to centimeters, or Fahrenheit to Celsius. Learn Excel unit conversion in…
What is the ISNONTEXT Function? The ISNONTEXT Function is categorized under Excel Information functions. The function helps to check if a cell contains text or not (is anything typed into a cell?). It will return TRUE if the value is text and if not, FALSE. For example, if the given value is a number, date,…
What is the ISNA Excel Function? The ISNA Excel Function is categorized under Information functions. This function helps in checking if a cell contains the #N/A! error. It will return a FALSE value for other types of errors. As a financial analyst, we deal with data and perform analysis on it. The ISNA function helps…
What is the ISLOGICAL Function? The ISLOGICAL Function is categorized underExcel Information functions. The function will test the value or expression provided and return a logical value. That is, it will evaluate the value or expression to provide a TRUE or FALSE result. ISLOGICAL is part of a group of functions called the IS functions,…
What is the ISEVEN Function? The ISEVEN Function is categorized under Excel Information functions. ISEVEN will return TRUE if the number is even or FALSE if the number is not even, or odd. In financial analysis, we need to deal with numbers. The ISEVEN function is useful in data analysis where we need to understand…
What is the STDEVA Function? The STDEVA Function is categorized under Excel Statistical functions. It will estimate the standard deviation based on a sample. As a financial analyst, STDEVA can be useful in finding out the rate of return on an investment and measuring the investment’s volatility. If a stock is volatile, it will have a…
