Data Analysis Example

You can use the Magazine Sales.xls workbook, provided in the Crystal Ball Examples folder, to experiment with the Batch Fit tool. This model shows the estimated gross profit resulting from newsstand sales of four of the company’s most popular magazines (Figure 87, Magazine Sales workbook).

Figure 87. Magazine Sales workbook

This figure displays the Magazine Sales workbook that is provided in the Crystal Ball examples folder.

This model shows sales figures for four magazines. The accompanying Sales Data worksheet contains historical data for each magazine. For this example, you will import the data into the Data Analysis tool, automatically create a forecast for each magazine, run a simulation, display the simulated data as forecast charts, correlate the forecasts for each magazine, and produce other charts using buttons in the new DataAnalysisOutput worksheet generated by the tool.