Part II: Working with Formulas and Functions
FIGURE 15.26
The Create Forecast Worksheet dialog boxThe confidence interval (depicted as thinner lines in the chart) determines the “plus or
minus” values for the forecast and indicates the degree of confidence in the forecast. A
higher confidence interval results in a wider prediction range. Note that the chart shown in
the dialog box adjusts as you change options.