You don't need statistical tables if you have Excel or Mathematica. Here I give the relevant Excel and Mathematica functions described in Chapter 14 of my book. You can save all the formulas in one spreadsheet or notebook and use it multiple times.

### Cumulative Distribution Function of the Standard Normal Distribution

For a given real , the value of the distribution function of the standard normal is

In Excel, use the formula =NORM.S.DIST(z,TRUE).

In Mathematica, enter CDF[NormalDistribution[0,1],z]

### Probability Function of the Binomial Distribution

For given number of successes number of trials and probability the probability is

.

In Excel, use the formula =BINOM.DIST(x,n,p,FALSE)

In Mathematica, enter PDF[BinomialDistribution[n,p],x]

### Cumulative Binomial Probabilities

For a given cut-off value number of trials and probability the cumulative probability is

In Excel, use the formula =BINOM.DIST(x,n,p,TRUE).

In Mathematica, enter CDF[BinomialDistribution[n,p],x]

### Values of the exponential function

In Excel, use the formula =EXP(-lambda)

In Mathematica, enter Exp[-lambda]

### Individual Poisson Probabilities

For given number of successes and arrival rate the probability is

In Excel, use the formula =POISSON.DIST(x,lambda,FALSE)

In Mathematica, enter PDF[PoissonDistribution[lambda],x]

### Cumulative Poisson Probabilities

For given cut-off and arrival rate the cumulative probability is

In Excel, use the formula =POISSON.DIST(x,lambda,TRUE)

In Mathematica, enter CDF[PoissonDistribution[lambda],x]

### Cutoff Points of the Chi-Square Distribution Function

For given probability of the right tail and degrees of freedom , the cut-off value (critical value) is a solution of the equation

In Excel, use the formula =CHISQ.INV.RT(alpha,v)

In Mathematica, enter InverseCDF[ChiSquareDistribution[v],1-alpha]

### Cutoff Points for the Student’s t Distribution

For given probability of the right tail and degrees of freedom , the cut-off value is a solution of the equation .

In Excel, use the formula =T.INV(1-alpha,v)

In Mathematica, enter InverseCDF[StudentTDistribution[v],1-alpha]

### Cutoff Points for the F Distribution

For given probability of the right tail , degrees of freedom (numerator) and (denominator), the cut-off value is a solution of the equation .

In Excel, use the formula =F.INV.RT(alpha,v1,v2)

In Mathematica, enter InverseCDF[FRatioDistribution[v1,v2],1-alpha]

## Leave a Reply

You must be logged in to post a comment.