What is the VAR.P Function? The VAR.P Function is categorized under Excel Statistical functions. This function will return the variance of a given set of values. It was introduced in MS Excel’s 2010 version. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the…
What are the LOOKUP vs VLOOKUP Functions? Knowing the difference between LOOKUP vs VLOOKUP Functions in Excel enables users to take full advantage of the benefits of using each function. The LOOKUP function allows a user to search for a piece of data in a row or column and return a corresponding piece of data…
What is the WORKDAY.INTL Function? The WORKDAY.INTL Functionis categorized under Excel Date and Time functions. It is a robust modification of the WORKDAY function, as it works with customizable weekend parameters. WORKDAY.INTL will provide us with a date that is N working days in the future or in the past and allows us to determine…
What is the VARA Function? The VARA Function is categorized under Excel Statistical functions. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the…
What is the FORECAST.LINEAR Function? The FORECAST.LINEAR Function is categorized under Excel Statistical functions. It will calculate or predict a future value using linear regression. In financial modeling, the FORECAST.LINEAR function can be useful in calculating the statistical value of a forecast made. For example, if we know the past earnings and expenses that are…
What is the FORECAST Function? The FORECAST Function is categorized under Excel Statistical functions. It will calculate or predict a future value using existing values. In financial modeling, the FORECAST function can be useful in calculating the statistical value of a forecast made. For example, if we know the past earnings and expenses, we can…
What is the PERCENTRANK Function? The PERCENTRANK Function is categorized under Excel Statistical functions. This function will return the rank of a value in a data set as a percentage. It can be used to evaluate the relative standing of a value within a data set. In corporate finance, we can use PERCENTRANK to evaluate…
What is the PERCENTILE Function? The PERCENTILE Function is categorized under Excel Statistical functions. PERCENTILE will return the k-th percentile of the values in a particular range. In corporate finance, we can use the function to analyze, for example, the number of employees who scored above a certain percentile on a test. In MS Excel…
What are Closed-end Mutual Funds? Closed-end mutual funds are mutual funds that raise a fixed amount of capital from investors through an initial public offering (IPO) and lists its shares on a stock exchange. A closed-end mutual fund is overseen by a fund manager, trades similarly to securities, and is considered a publicly traded investment…
What are Open-end Mutual Funds? Open-end mutual funds refer to mutual funds that issue shares to investors based on the fund’s net asset value (NAV) per share. In an open-end mutual fund, investors purchase shares directly from the mutual fund at the net asset value (the value of the fund’s underlying securities) per share rather…
