What is the STDEV.S Function? The STDEV.S Function is an Excel Statistical function that will calculate the standard deviation that is based on a sample of the population. It will ignore logical values and text. While doing financial analysis, the STDEV.S function can be useful in, for example, measuring the income standard deviation representative of…
What is the STDEV.P Function? The STDEV.P Function is categorized under Excel Statistical functions. STDEV.P will calculate the standard deviation that is based on an entire population given as arguments. It will ignore logical values and text. As a financial analyst, the STDEV.P function can be useful in, for example, calculating deviations in revenue. Portfolio…
What is the TBILLYIELD Function? The TBILLYIELD Function is categorized under Excel FINANCIAL functions. It will calculate the yield on a Treasury bill. In financial analysis, TBILLYIELD can be useful in calculating the yield on a Treasury bill when we are given the start date, end date, and price. Formula =TBILLYIELD(settlement, maturity, pr) The TBILLYIELD…
What is the TBILLPRICE Function? The TBILLPRICE Function is categorized under Excel FINANCIAL functions. The function will calculate the fair market value of a Treasury bill / bond. In financial analysis, TBILLPRICE can be useful in determining the value of a bond and deciding if an investment should be made or not. It helps calculate…
What is the TRANSPOSE Function? The TRANSPOSE Function is categorized under Excel Lookup and Reference functions. It will flip the direction of a given range or array. The function will convert a horizontal range into a vertical range and vice versa. In financial analysis, the TRANSPOSE function is useful in arranging data in our desired…
What is the SMALL Function? The SMALL Function is categorized as an Excel Statistical function. It will return numeric values based on their position in a list, ranked by value. Essentially, it calculates and returns the k smallest value in a dataset. In financial analysis, the SMALL function can be useful in finding the smallest value…
What is the TODAY Function? The TODAY Function is categorized under Excel Date and Time functions. It will calculate and give the current date. It is updated continuously whenever a worksheet is changed or opened by a user. The function’s purpose is to get today’s date. As a financial analyst, the TODAY function can be…
What is the YIELDMAT Function? The YIELDMAT Function is categorized under Excel FINANCIAL functions. It will return the annual yield of a security that pays interest at maturity. In financial analysis, YIELDMAT can be useful in calculating the yield on a bond that pays interest at maturity. The annual yield is the total increase in…
What is the PROPER Function? The PROPER Function is categorized under Excel Text functions. PROPER will capitalize the first letter in a text string and any other letters in text that follow any character other than a letter. In financial analysis, we often import data from external sources. The PROPER function will help us convert…
What is the TYPE Function? The TYPE Function is categorized under Excel Information functions. It will return the type of a given value. The function will return a numeric code representing the type of value. As a financial analyst, we use many Excel functions in our financial analysis. The TYPE function is useful when the…
