CHISQ.INV.RT Function in Excel: Chi-Square Critical Value
CHISQ.INV.RT gives the critical value for a chi-square test: if your statistic is bigger, the result is significant.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
ATAN Function in Excel: Angle From a Slope
ATAN Function in Excel: Angle From a Slope
MathLevel: ExpertAvailable in: Excel 2007+ATAN turns a slope (rise/run) into an angle. ATAN2 handles all four quadrants.Syntax=ATAN(number)ArgumentWhat it.
Read article →ACOS Function in Excel: Angle From a Cosine
ACOS Function in Excel: Angle From a Cosine
ACOS is the inverse of COS. It appears in the formula for distance between two places on Earth.
Read article →ASINH Function in Excel: Inverse Hyperbolic Sine
ASINH Function in Excel: Inverse Hyperbolic Sine
Maths & trigLevel: ExpertAvailable in: Excel 2007+ASINH returns the inverse hyperbolic sine.Syntax=ASINH(number)ArgumentWhat it meansnumberValue (angles.
Read article →ACOT Function in Excel: Inverse Cotangent
ACOT Function in Excel: Inverse Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+ACOT returns the angle (0 to π) whose cotangent is x.Syntax=ACOT(number)ArgumentWhat it meansnumberValue.
Read article →ASIN Function in Excel: Angle From a Sine
ASIN Function in Excel: Angle From a Sine
MathLevel: ExpertAvailable in: Excel 2007+ASIN returns the angle (in radians) whose sine is the given number.Syntax=ASIN(number)ArgumentWhat it.
Read article →ATAN2 Function in Excel: Angle From X and Y
ATAN2 Function in Excel: Angle From X and Y
ATAN2 returns the angle of a point, handling all four quadrants. Note Excel’s order is (x, y) — the reverse of many programming languages.
Read article →ATANH Function in Excel: Inverse Hyperbolic Tangent
ATANH Function in Excel: Inverse Hyperbolic Tangent
Maths & trigLevel: ExpertAvailable in: Excel 2007+ATANH returns the inverse hyperbolic tangent (input between -1 and 1).Syntax=ATANH(number)ArgumentWhat.
Read article →COTH Function in Excel: Hyperbolic Cotangent
COTH Function in Excel: Hyperbolic Cotangent
Maths & trigLevel: ExpertAvailable in: Excel 2013+COTH returns 1/TANH(x).Syntax=COTH(number)ArgumentWhat it meansnumberValue (angles in.
Read article →COS Function in Excel: Cosine of an Angle
COS Function in Excel: Cosine of an Angle
COS also expects radians. Seasonal models sometimes use SIN and COS of the month to capture yearly cycles.
Read article →TAN Function in Excel: Tangent of an Angle
TAN Function in Excel: Tangent of an Angle
MathLevel: IntermediateAvailable in: Excel 2007+TAN links an angle to a slope. Radians again — wrap degrees in RADIANS().Syntax=TAN(number)ArgumentWhat it.
Read article →DEGREES Function in Excel: Radians to Degrees
DEGREES Function in Excel: Radians to Degrees
MathLevel: IntermediateAvailable in: Excel 2007+DEGREES converts radians back to degrees.Syntax=DEGREES(angle)ArgumentWhat it meansangleIn.
Read article →