Linear Regression Dialog

1 Recalculate
2 Multi-Data Fit Mode
3 Input Data
4 Fit Options
5 Quantities to Compute
6 Residual Analysis
7 Output Settings
8 Fitted Curves Plot
9 Find Specific X/Y
10 Residual Plots

Recalculate

Recalculate	Controls recalculation of analysis results None Auto Manual

Recalculate

Controls recalculation of analysis results

None
Auto
Manual

Multi-Data Fit Mode

Multi-Data Fit Mode	This control is available only when there is more than one input dataset. Independent-Consolidated Report The input datasets are fitted separately. The reports are consolidated into one sheet. Independent-Separate Report The input datasets are fitted separately. The reports are output to different worksheets. Concatenate All input datasets are concatenated and fitted as one curve.

Multi-Data Fit Mode

This control is available only when there is more than one input dataset.

Independent-Consolidated Report
The input datasets are fitted separately. The reports are consolidated into one sheet.
Independent-Separate Report
The input datasets are fitted separately. The reports are output to different worksheets.
Concatenate
All input datasets are concatenated and fitted as one curve.

Input Data

Range	Specify the input XY data range X X column of the curve. Y Y column of the curve. Error The Y error column. Rows Specify a range of the X column to be fitted. When Rows is set to By Row or By X, you can use the From and To textboxes to specify the range to be fitted. All Specify all rows of the dataset that will be fitted. By Row Specify the range of the X column by row index. By X Specify the range of the X column by X value When fitting multiple XY datasets from either worksheet or graph, you can use the Apply Row Range to All menu item to apply the same X row range to all input data. Specify a row range for the input colum for Range 1, click the button to the right of Range 1, and then click Apply Row Range to All.

Range

Specify the input XY data range

X column of the curve.

Y column of the curve.

Error

The Y error column.

Rows

Specify a range of the X column to be fitted. When Rows is set to By Row or By X, you can use the From and To textboxes to specify the range to be fitted.

All

Specify all rows of the dataset that will be fitted.

By Row

Specify the range of the X column by row index.

By X

Specify the range of the X column by X value

When fitting multiple XY datasets from either worksheet or graph, you can use the Apply Row Range to All menu item to apply the same X row range to all input data. Specify a row range for the input colum for Range 1, click the

button to the right of Range 1, and then click Apply Row Range to All.

Fit Options

Specifies the fitting options.

Errors as Weight	Use error bars as value for weights. Only available when Error column is selected. No Weighting Do not use any data as weighting. Direct Weighting $w_i\,\!$ = values form the ith row of Error column and $\chi ^2=\sum_{i=1}^n w_i (y_i-\hat y_i)^2$ Instrumental $w_i=\frac 1{\sigma _i^2}$ where $\sigma _i\,\!$ = values form the ith row of Error column and $\chi ^2=\sum_{i=1}^n \frac 1{\sigma _i^2} (y_i-\hat y_i)^2$
Fix Intercept	Restrict the intercept to the value specified.
Fix Intercept at	Specify the intercept.
Fix Slope	Restrict the slope to the value specified.
Fix Slope at	Specify the slope.
Use Reduced Chi-Sqr	Available when fitting with weight. This check box only affects the error on the parameters reported from the fitting process, and does not affect the fitting process or the data in any way. By default, it is checked, and the covariance matrix is calculated by: $\sigma (x^{\prime }x)^{-1}$ , otherwise, $(x'x)^{-1}\,\!$ .
Apparent Fit	Use the apparent values for fitting, according to the current axis scales. For example, select this box to fit exponentially decaying data with a straight line fit when data are plotted on a log scale. When this check box is selected and the data has error values associated with it, Origin uses the larger of the positive/negative errors as weight.

Apparent Fit is only useful when you fit from a graph and change the plot axis type (from Linear to Log10, for example). If you check this option, the fitter will first transform raw data into new data space as specified in the graph axis type, and then fit the curve with the new data. Otherwise, Origin always fits raw data directly, regardless of the axis type. Apparent fit is equivalent to direct fit if you first transform raw data on the worksheet, and leads to completely different results from direct fit if your graph axis is non-linear.

Quantities to Compute

Use this branch to specify the quantities to be computed and displayed:

Fit Parameters	Value Parameters' value. Standard Error Standard error of parameters LCL The lower confidence limit UCL The upper confidence limit Confidence Level for Parameters (%) The confidence level for regression t-Value t-test value of parameters prob>\|t\| p-value of parameters CI Half-Width Half-width of the confidence interval
Fit Statistics	Number of Points Total number of fitting points Degrees of Freedom Model degrees of freedom Reduced Chi-Sqr The Reduced Chi-square value, equals to the residual sum of square divided by the degree of freedom. R Value The $R\,\!$ value, equals to square root of $R^2\,\!$ Residual Sum of Squares Residual sum of squares (RSS); or sum of square error. Pearson's r Pearson correlation coefficient. R-Square (COD) Coefficient of determination Adj. R-Square Adjusted coefficient of determination Root-MSE (SD) Standard deviation; or square root of mean square error. Norm of Residuals Norm of residuals; equals to square root of RSS.
Fit Summary	Check to output the fit summary table. This table organizes all the selected fit parameters in a row for each curve (dependent data).
ANOVA	Specify whether or not to output the analysis of variance table.
Covariance matrix	Specify whether or not to output the covariance matrix.
Correlation matrix	Specify whether or not to output the correlation matrix.

Residual Analysis

Select methods to calculate and output the different kind of residuals.

Regular	Output the regular residuals
Standardized	Output the standardized residuals
Studentized	Output the studentized (internally studentized ) residuals
Studentized Deleted	Output studentized deleted (externally studentized) residuals

Output Settings

Customize the output results and destination.

Graph Arrangement	Arrange Graphs into Columns Specify a number l. In any result sheet table, graphs will be arranged in rows of l graphs. Arrange Plots of Same Type in One Graph If this checkbox is selected, plots in same type will be arranged in one graph
Report Tables	Specifies the destination of report tables Book Specify the destination workbook. <none> Do not output report worksheet tables <auto> The workbook that is automatically picked by the program. <Source> The source data workbook <new> A new workbook. <existing> A specified existing workbook BookName The name of the destination workbook. Sheet The destination worksheet, always <new>. SheetName The desired name of the destination worksheet. Result Log Specify whether to output the report to Result Log Script Window Specify whether to output the report to Script Window. Notes Window Specify the destination Notes Window: <none> Do not output to any Notes window. <new> Output to a new Notes window. You can enter the desired name of the Note window here.
Fitted Curves	Specifies the destination workbooks and worksheet for the fitted value Book Specify the destination workbook. <auto> The workbook that is automatically picked by the program. <source> The source data workbook <report> The workbook containing the report tables. <new> A new workbook <existing> A specified existing workbook BookName The name of the destination workbook. Sheet Specify the destination worksheet. <source>' Source data worksheet <new> A new worksheet <existing> A specified existing worksheet SheetName The name of the destination worksheet.
Fit Residuals	Specifies the destination workbook and worksheet for residual values Book Specify the destination workbook. <fittedvalue> The workbook has the fitted values. <source> The source data workbook <new> A new workbook <existing> A specified existing workbook BookName The name of the destination workbook. Sheet Specify the destination worksheet. <fittedvalue>' The worksheet has the fitted values. <new> A new worksheet <existing> A specified existing worksheet SheetName The name of the destination worksheet.
Find Specific X/Y Tables	Specify the destination of Find Specific X/Y tables. This branch is only available when either the Find X from Y checkbox or the Find Y from X checkbox is selected. See: Find Specific X/Y, below. Book Specify the destination workbook. <fittedvalue> The workbook has the fitted values. <source> The workbook has the source data. <new> A new workbook. <existing> A specified existing workbook BookName The name of the destination workbook. Sheet Specify the destination worksheet. <fittedvalue> The worksheet that has the fitted values <new> A new worksheet. <existing> A specified existing worksheet. FindX SheetName The name of the destination Find X worksheet. FindY SheetName The name of the destination Find Y worksheet.
Optional Report Tables	Specifies what is output to report worksheet Notes Notes table Input Data Table for input data Masked Data Table for masked data Missing Data Table for missing data

Fitted Curves Plot

Settings for the output fitted curves

Plot in Report Table	When the checkbox is selected, fitted curves will be added to Report Table.
Plot on Source Graph	This option is available only when the input datasets are from a graph. It can be used to specify whether to add the fitted curve to the original graph. None The fitted curve is not added to the original graph. Fitted Curve The fitted curve is added to the original graph. Fitted Curve+Plot Type The fitted curve and the plot specified by the Plot Type drop-down list are added to the original graph. This option is available only when the input datasets are from a graph and the Concatenate Fit mode is chosen.
Update Legend on Source Graph	Specify whether to update legend on the source graph.
Multiple Plots Use Source Graph Color	Specify whether to use color settings of source graph to color multiple fitted curves.
X Data Type	Specify how to generate the X values of the fitted curve. Uniform Linear The X values of the fitted curve are plotted on an equally-spaced linear scale. Log The X values of the fitted curve are plotted on a logarithmic scale. Same as Input Data The X values of the fitted curve are the same as the input X values. Use Source Graph Scale Type The X values of the fitted curve are plotted using the scale type of the source graph. This option is available only when the input datasets are from a graph. Points This control is available only when X Data Type is either Uniform Linear or Log. It specifies the total number of data points in a fitted curve. Range This control is available only when X Data Type is either Uniform Linear or Log. It specifies the range of the X values of the fitted curve. Select one of the following options: Use Input Data Range + Range Margin Span to Full Axis Range Custom Range Margin This control is available only when X Data Type is either Uniform Linear or Log and Use Input Data Range + Range Margin is selected for Range. It specifies the range margin into which the fitted curves extend. Min/Max This control is available only when X Data Type is either Uniform Linear or Log and Custom is selected for Range. These two text boxes specify the minimum and maximum X value for fitted curves.
Confidence Bands	Specify whether or not the confidence bands are added to the output graph.
Prediction Bands	Specify whether or not the prediction bands are added to the output graph.
Confidence Level for Curves (%)	Specify the confidence level for confidence bands and prediction bands.
Ellipse	Check this check box to add the confidence ellipse to the fitted curve plot based on the chosen confidence level. Data Points Specify the number of data points of the ellipse Mean Check this check box to add the confidence ellipse for the population mean. Confidence Level (%) Specify the confidence level for the confidence ellipse. Prediction Check this check box to add the confidence ellipse for prediction. Confidence Level (%) Specify the confidence level for the confidence ellipse.

Find Specific X/Y

Use this branch to specify whether to output Find Specific X/Y tables. A Find Y from X table is used to obtain a dependent variable value that corresponds to a given independent variable value; while a Find X from Y table can be used to obtain an independent variable value for a given dependent variable value.

Find X From Y	Specify whether to generate a Find X From Y table. Number of X Columns Specify the number of X columns.
Find Y From X	Specify whether to generate a Find Y From X table. Number of Y Columns Specify the number of Y columns.

Find X From Y

Specify whether to generate a Find X From Y table.

Number of X Columns

Specify the number of X columns.

Find Y From X

Specify whether to generate a Find Y From X table.

Number of Y Columns

Specify the number of Y columns.

Note: If you use Apparent Fit, the Find X From Y and Find Y from X table will find values on the transformed scale.

Residual Plots

Use the controls in this branch to customize the residual plots.

Residual Plots	Use the controls in this branch to customize the residual plots. Residual Type Specify the residual type from the drop-down list: Regular Standardized Studentized Studentized Deleted For the selected residual type, you can opt to output up to five residual plots: Residual vs. Independents Plot Histogram of the Residual Plot Residual vs. Predicted Values Plot Residual vs. the Order of the Data Plot Residual Lag Plot

Residual Plots

Use the controls in this branch to customize the residual plots.

Residual Type

Specify the residual type from the drop-down list:

Regular
Standardized
Studentized
Studentized Deleted

For the selected residual type, you can opt to output up to five residual plots:

Residual vs. Independents Plot

Histogram of the Residual Plot

Residual vs. Predicted Values Plot

Residual vs. the Order of the Data Plot

Residual Lag Plot

Linear Regression Dialog

Contents

Recalculate

Multi-Data Fit Mode

Input Data

Fit Options

Quantities to Compute

Residual Analysis

Output Settings

Fitted Curves Plot

Find Specific X/Y

Residual Plots