IMSQRT

Function Type: Engineering Description: Returns the square root of a complex number. Function Structure: =IMSQRT(inumber). Argument breakdown: inumber – A complex number for which you want the square root. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

IMSINH

Version Availability: Desktop version starting Excel 2013 Function Type: Engineering Description: Returns the hyperbolic sine of a complex number. Function Structure: =IMSINH(inumber). Argument Breakdown: inumber – A complex number for which you want the hyperbolic sine. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back toContinue reading “IMSINH”

IMSIN

Function Type: Engineering Description: Returns the sine of a complex number. Function Structure: =IMSIN(inumber). Argument Breakdown: inumber – A complex number for which you want the sine. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

IMLN

Function Type: Engineering Description: Returns the natural logarithm of a complex number. Function Structure: =IMLN(inumber). Argument Breakdown: inumber – A complex number for which you want the natural logarithm. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

CHIDIST

Function Type: Compatibility Description: Returns the one-tailed probability of the chi-squared distribution. In Excel 2007, this is a Statistical function. Function Structure: =CHIDIST(x, deg_freedom). Argument Breakdown: x – The value at which the chi-square distribution is to be evaluated (must be ≥ 0). deg_freedom – The number of degrees of freedom (must be an integer between 1Continue reading “CHIDIST”

BINOMDIST

Function Type: Compatibility Description: Returns the individual term binomial distribution probability. In Excel 2007, this is a Statistical function. Function Structure: =BINOMDIST(number_s, trials, probability_s, cumulative) Argument Breakdown: number_s – The number of successes. trials – The number of independent trials. probability_s – The probability success on each trial. cumulative – TRUE = cumulative distribution function,Continue reading “BINOMDIST”

BETAINV

Function Type: Compatibility Description: Returns the inverse of the cumulative distribution function for a specified beta distribution. In Excel 2007, this is a Statistical function. Function Structure: =BETAINV(probability, alpha, beta, [A], [B]). Argument Breakdown: probability – The probability of the Beta distribution, for which you want to find the value of x. alpha – AContinue reading “BETAINV”