Generating Batch Fit Results

  To work through the Batch Fit example:

1. In Microsoft Excel with Crystal Ball loaded, open the example workbook Magazine Sales.xls.

2. Start the tool; select Run, then More Tools, then Batch Fit. (In Microsoft Excel 2007 or later, select More Tools in the Tools group.)

   If this is the first time you have opened the Batch Fit tool, the Welcome panel opens.

3. If the Welcome panel opens, click Next to display the Input Data panel.

   On the Input Data panel, the Batch Fit data selector attempts to select relevant data and indicate its orientation. In this case, you need to select data on another worksheet.

4. On the Input Data panel, click the Select Cells icon beside the Location Of Data Series field.

5. Select the Sales Data worksheet.

6. Select cells A1 through D361 .

7. Click OK to return to the Batch Fit panel.

8. Select Data In Columns, the default.

9. Select Top Row Has Headers.

10. Click Next.

    The Fitting Options panel opens.

11. On the Fitting Options panel, select All Continuous in the Distributions To Fit group.

12. Select Anderson-Darling in the Rank By Goodness-of-Fit Statistic group.

13. Click Next.

    The Output Options panel opens, similar to Figure 58, Output Options panel, Batch Fit tool but with different settings.

    Figure 58. Output Options panel, Batch Fit tool

    

14. For Fit Results, select Current Workbook and then select Existing Sheet.

15. Click the cell selector () in the Starting Cell box.

16. Select cell B13 on the Model worksheet.

17. Click OK to return to the Output Options panel.

18. Select Fill Downward and AutoFormat.

19. Include a correlation analysis of the data:

    1. Select "Show correlation matrix between data series."

    2. Select "Define correlations between assumptions..." For now, leave 0.0 in the box to display all correlations.

       The threshold must be between 0 and 1 (inclusive). The tool displays the correlation matrix at the end of the results section.

    3. Do not select "Keep correlations linked to matrix."

    The settings should look like those in Figure 58, Output Options panel, Batch Fit tool.

20. Click Next to open the Reports panel.

21. Select Create Goodness-Of-Fit Report but do not select Show All Goodness-Of-Fit Statistics.

    Use the default Sheet Name setting.

22. Do not select Create Assumptions Report.

23. Click Run.

    The tool fits each selected distribution to each data series. The Batch Fit results are displayed on the Batch Fit Output worksheet, similar to Figure 59, Batch Fit Results Below the Model.

    Figure 59. Batch Fit Results Below the Model