
Chapter 9
304
9.3.1 Using MS Excel for Confi dence Interval Construction
In order to use MS Excel for con dence interval construction, select CONFIDENCE.NORM
from the Insert Function dialog box (Figure 9.3). Click OK, the Function Arguments dialog
box as shown in Figure 9.4 will appear on the screen. Place the values of Alpha, Standard
deviation, and sample Size in appropriate boxes and click OK (Figure 9.4). The
z
n
α
σ
2
part of
the formula of con dence interval will be computed in the concerned cell.
9.3.2 Using Minitab for Confi dence Interval Construction
In order to use Minitab for con dence interval construction, click Stat/Basic Statistics/ ...