The Output Options panel of the Batch Fit wizard sets output options that control the tool. Available settings and buttons are:
Fit Results Location (Assumptions) — Specifies locations of results:
New Workbook — Places results in a new workbook.
Current Workbook — Places results in the current workbook. You can select New Sheet, which places results in a new sheet of the current workbook, or Existing Sheet, which places results in an existing sheet of the current workbook.
Sheet Name — The name of a new sheet where the results (assumptions) will be placed.
Note:
If you select Current Workbook, and then Existing Sheet, Sheet Name is not available. Use the cell selector (
) to select the sheet and cell where the results output should start.Starting Cell — The first (upper left) cell of the output range.
Direction — Indicates the direction that output data is written, with the starting cell in the upper left of the output range.
Fill Downward lists data series at the top of each column with data for each series extending below the series label. This is the default.
Fill To The Right lists data series in the first column with data for each series extending to the right of the series label.
AutoFormat — When selected, uses special cell formatting for the data in the output.
Correlations — Specifies whether correlations are generated and defined:
Show Correlation Matrix Between Data Series — When selected, correlates the data series with each other and displays the results in a matrix.
Link fitted assumptions to the correlation matrix — When selected, links assumptions to the correlation matrix saved to the worksheet; changes to the matrix in the worksheet are reflected in the Define Correlations dialog and the reverse (Viewing and Editing Linked Matrixes).
Back — Returns to the Fitting Options panel.
Next — Opens the Reports panel.
Run — Runs the tool, automatically fitting distributions to the data and creating output of the assumptions and statistics.