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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →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 →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 →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 →CSCH Function in Excel: Hyperbolic Cosecant
CSCH Function in Excel: Hyperbolic Cosecant
Maths & trigLevel: ExpertAvailable in: Excel 2013+CSCH returns 1/SINH(x).Syntax=CSCH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →