What is the CHISQ.TEST Function? The CHISQ.TEST function is categorized under Excel statistical functions. It will calculate the chi-square distribution of two provided datasets, specifically, the observed and expected frequencies. The function helps us understand whether the differences between the two sets is simply due to sampling error, or not. In financial analysis, CHISQ.TEST can…
Chi Square Test Excel Function The CHISQ.DIST Function is categorized under Excel Statistical functions. It will return the chi-square distribution. The distribution is commonly used for studying the variations in percentage across samples. This guide will break down the Chi Square Test Excel function in detail. In financial analysis, this function can be useful in finding out…
What is Theta? Theta is a sensitivity measurement used in assessing derivatives. It is one of the measures denoted by a Greek letter. The series of risk and sensitivity measurements denoted by Greek letters are aptly named the Greeks. Theta measures the value of a derivative in relation to the time left before the expiration…
What is a Non-Deliverable Swap (NDS)? A non-deliverable swap (NDS) is an exchange of different currencies, between a major currency and a minor currency, which is restricted. With most swaps, currency flows physically change. With an NDS, it is not the case because the currencies are not convertible. The two currencies that are involved in…
What is a No Dealing Desk? A no dealing desk is a system that allows for instant forex trades on the interbank market. Brokers that use the system work with several liquidity providers. It enables them to access the best bid and ask prices directly. Investors are given rates that can be executed immediately. Orders…
What is a Non-Equity Option? A non-equity option is an option with an underlying asset that is something other than common stock. In most cases, non-equity options include indexes and commodities as underlying assets. It’s really a broad term to define a variety of options, provided the option doesn’t involve common stocks. Non-equity options usually…
What is the ISERROR Excel Function? The ISERROR Excel Function is categorized under Information functions. The function will return TRUE if the given value is an error and FALSE if it is not. It works on errors – #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL. ISERROR is used in combination with the IF function…
What is the ISERR Excel Function? The ISERR Excel Function is categorized under Information functions. The function will return TRUE if the given value is an error (except N/A) and FALSE if it is not. It belongs to the IS group of functions, which includes ISERROR, IFERROR, etc. ISERR is used in combination with the…
Who are Strats? Strats refer to mathematicians, statisticians, computer scientists, and engineers who work in the financial services industry. In particular, strats are used to describe the mathematicians, statisticians, software developers, and engineers who work at investment banks in a front office role. The first strats team was set up within the strategies team at…
What is Shadow (Candlestick Wick)? In the world of finance and charting, a shadow is a line that makes up a candlestick pattern’s wick – the portion of the candlestick that represents price action outside of the candlestick body formed by the opening and closing prices of the period. Every candlestick chart must contain a…
