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 choose 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.
Define Correlations Between Assumptions If The Absolute Value Of The Correlation Is Above __ — When selected, defines correlations between assumptions if the absolute value of the correlation is above the indicated level. The default is 0.0, which intercorrelates all assumptions.
Keep Correlations Linked To Matrix — When selected, changes correlations between assumptions if a new matrix is generated.
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.