Excel

Type these into any cell. The examples reuse numbers from the topics, so you can check each answer.

Mean, median, mode

=AVERAGE(A2:A21)
=MEDIAN(A2:A21)
=MODE.MULT(A2:A21)

MODE.MULT returns every mode when there is a tie.

Sample SD and variance

=STDEV.S(A2:A21)
=VAR.S(A2:A21)

Use STDEV.P and VAR.P for a whole population.

Coefficient of variation

=STDEV.S(A2:A21)/AVERAGE(A2:A21)

Correlation and covariance

=CORREL(A2:A21,B2:B21)
=COVARIANCE.S(A2:A21,B2:B21)

Combinations

=COMBIN(5,2)

Returns 10.

Binomial

=BINOM.DIST(2,8,0.2,FALSE)
=BINOM.DIST(2,8,0.2,TRUE)

Exactly 2 is 0.294; at most 2 is 0.797.

Poisson

=POISSON.DIST(3,3,FALSE)
=POISSON.DIST(4,6,TRUE)

Exactly 3 is 0.224; at most 4 is 0.285.

Normal areas and cutoffs

=NORM.DIST(525,400,50,TRUE)
=NORM.INV(0.9,400,50)

0.9938, and 464.1 cups.

Critical values

=NORM.S.INV(0.975)
=T.INV.2T(0.05,15)

1.96 and 2.131.

Confidence interval margins

=CONFIDENCE.NORM(0.05,5,25)
=CONFIDENCE.T(0.05,12,16)

1.96 and 6.39. Add and subtract from the mean.

Simple regression

=SLOPE(B2:B7,A2:A7)
=INTERCEPT(B2:B7,A2:A7)
=RSQ(B2:B7,A2:A7)

y values first, then x.

Full regression output

Data > Data Analysis > Regression

Turn on the Analysis ToolPak add-in first. It gives the F test, t tests, and residuals.