CHISQ.DIST Function in Excel: Chi-Square Distribution (Left Tail)
CHISQ.DIST gives the left-tailed chi-square probability; most tests need the right tail, CHISQ.DIST.RT.
Read article →Atul Vij
Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Build a full loan amortisation schedule in Excel: EMI with PMT, month-by-month interest and principal, yearly totals with CUMIPMT/CUMPRINC, outstanding balance, prepayment scenarios and…
Read article →CHIDIST Function in Excel: Chi-Square p-Value (Older Name)
CHIDIST Function in Excel: Chi-Square p-Value (Older Name)
CHIDIST returns the right-tailed chi-square probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →EMI and Loan Amortisation Schedule in Excel (PMT, IPMT, PPMT)
EMI and Loan Amortisation Schedule in Excel (PMT, IPMT, PPMT)
Calculate a home or car loan EMI with PMT, split each EMI into interest and principal, build the full month-by-month schedule and see the…
Read article →Phantom Vibration Syndrome
Phantom Vibration Syndrome
Phantom vibration syndrome or phantom ringing is the perception that one’s mobile phone is vibrating or ringing when it is not. Other terms include…
Read article →CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability
CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+CHISQ.INV is the inverse of CHISQ.DIST (left tail).Syntax=CHISQ.INV(probability, deg_freedom)ArgumentWhat.
Read article →CHISQ.DIST.RT Function in Excel: Chi-Square p-Value (Right Tail)
CHISQ.DIST.RT Function in Excel: Chi-Square p-Value (Right Tail)
CHISQ.DIST.RT turns a chi-square statistic into a p-value: the chance of a result at least this extreme if nothing is going on.
Read article →SECH Function in Excel: Hyperbolic Secant
SECH Function in Excel: Hyperbolic Secant
Maths & trigLevel: ExpertAvailable in: Excel 2013+SECH returns 1/COSH(x).Syntax=SECH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →COSH Function in Excel: Hyperbolic Cosine
COSH Function in Excel: Hyperbolic Cosine
COSH returns the hyperbolic cosine (e^x + e^-x)/2: the shape of a hanging cable.
Read article →ACOTH Function in Excel: Inverse Hyperbolic Cotangent
ACOTH Function in Excel: Inverse Hyperbolic Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+ACOTH returns the inverse hyperbolic cotangent (|x| > 1).Syntax=ACOTH(number)ArgumentWhat it.
Read article →AMORDEGRC Function in Excel: French Degressive Depreciation
AMORDEGRC Function in Excel: French Degressive Depreciation
AMORDEGRC returns depreciation for each period using the French degressive method with coefficients (for French accounting). Most users want DB or SLN instead.
Read article →SINH Function in Excel: Hyperbolic Sine
SINH Function in Excel: Hyperbolic Sine
Maths & trigLevel: ExpertAvailable in: Excel 2007+SINH returns the hyperbolic sine (e^x - e^-x)/2.Syntax=SINH(number)ArgumentWhat it meansnumberValue.
Read article →