Probability from Z value
p = normsdist(Z)
Z-value for a probability
Z = normsinv(p)
Mean Median
=average(cell range) =median(cell range)
Range Standard Deviation
=max(cell range) – min(cell range) =stdev(cell range)
Normal Distribution
Probability from Z value
p = normsdist(Z)
Z-value for a probability
Z = normsinv(p)
t Distribution
Probability from t value
p = tdist(t, df, 1)
t-value for a probability
t = tinv(p, df)
Confidence Interval (n > 30)
=confidence(significance, s, n)
Hypothesis test (n > 30)
=ztest(cell range, c)
Binomial Probabilities
=binomdist(successes, trials, probability, true/false)
true = cululative, false = not cumulative
