JavaScript Lesson 2: Variables, Types and Strings
Declare variables with const and let, understand numbers, strings and booleans, use template literals, format Indian numbers with toLocaleString, and common string methods.
Read article →Declare variables with const and let, understand numbers, strings and booleans, use template literals, format Indian numbers with toLocaleString, and common string methods.
Read article →Run your first JavaScript in the browser console and with Node.js, use VS Code, understand where JavaScript runs, and print output with console.log.
Read article →COVAR returns the population covariance. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends COVARIANCE.P for new work. Both give the same result.
Read article →One #N/A ruins a SUM. Ignore errors with AGGREGATE, SUMIF and IFERROR inside arrays, count the errors so they stay visible, and know when to fix them at source instead.
Read article →TDIST gives a one- or two-tailed t probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends T.DIST.2T / T.DIST.RT for new work. Both give the same result.
Read article →HEX2OCT converts a hexadecimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →T.DIST.2T turns a t statistic into a two-tailed p-value, the usual one for 'is there any difference?'.
Read article →StatisticsLevel: ExpertAvailable in: Excel 2010+T.DIST.RT gives the right-tailed t probability, for 'is it greater?' tests.Syntax=T.DIST.RT(x.
Read article →TANH returns the hyperbolic tangent; also an activation function in neural networks.
Read article →CHIINV returns the chi-square critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends CHISQ.INV.RT for new work. Both give the same result.
Read article →Maths & trigLevel: ExpertAvailable in: Excel 2013+CSC returns 1/SIN(x).Syntax=CSC(number)ArgumentWhat it meansnumberValue (angles in.
Read article →Maths & trigLevel: ExpertAvailable in: Excel 2013+COT returns 1/TAN(x).Syntax=COT(number)ArgumentWhat it meansnumberValue (angles in.
Read article →