Linear Fit with X Error Dialog (OriginPro Only)

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

Recalculate

This drop-down list controls the recalculation of analysis results.

Multi-Data Fit Mode

The same as the Multi-Data Fit Mode control in the Linear Fit dialog.

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. X Error The X error column. Rows Specify the 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 text boxes to specify the range to be fitted. All All rows of the dataset 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, use Apply Row Range to All 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.

X Error

The X error column.

Rows

Specify the 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 text boxes to specify the range to be fitted.

All

All rows of the dataset 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, use Apply Row Range to All 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

Computation Method	If the error is treated as weight, the chi-square minimizing equation can be written as: $\chi ^2=\sum_{i=1}^n w_{x_i} (x_i-\hat x_i)^2+\sum_{i=1}^n w_{y_i}(y_i-\hat y_i)^2$ York Use the computation method described in Least-squares fitting of a straight line. Please see Reference 1 (below). FV Use the computation method described in Fitting straight lines with errors on both coordinates. Please see Reference 2 (below).
Correlation Between X and Y Errors	Specify the correlation between X and Y errors with a value range from 0 to 1. If no relationship between Xerr and Yerr, we can set it as 0. This option is only available when the Computation Method is set as York.

Computation Method

If the error is treated as weight, the chi-square minimizing equation can be written as:

$\chi ^2=\sum_{i=1}^n w_{x_i} (x_i-\hat x_i)^2+\sum_{i=1}^n w_{y_i}(y_i-\hat y_i)^2$

York
Use the computation method described in Least-squares fitting of a straight line. Please see Reference 1 (below).
FV
Use the computation method described in Fitting straight lines with errors on both coordinates. Please see Reference 2 (below).

Correlation Between X and Y Errors

Specify the correlation between X and Y errors with a value range from 0 to 1. If no relationship between Xerr and Yerr, we can set it as 0. This option is only available when the Computation Method is set as York.

Quantities to Compute

Fit Parameters	Specify the quantities to output. Value Specify whether to output the values of the parameters. Standard Error Specify whether to output the standard errors of the parameters.

Fit Parameters

Specify the quantities to output.

Value

Specify whether to output the values of the parameters.

Standard Error

Specify whether to output the standard errors of the parameters.

Output Settings

Graph Arrangement	Specify how to arrange the output graphs. Arrange Graphs into Columns Specify the number of columns used to arrange the graphs. Arrange Plots of Same Type in One Graph Specify whether to merge graphs of the same type into one.
Linear Fit Tables	Book Specify the workbook used to output the linear fit tables. <none> Do not output the linear fit tables to any workbooks. <auto> Let Origin automatically decide a workbook for outputting the linear fit tables. <source> Output the linear fit tables to the workbook where the source data is from. <new> Create a new workbook and use it to output the linear fit tables. <existing> Open the Workbook Organizer, which allows you to pick an existing workbook for outputting the linear fit tables. BookName This is editable only when <new> is selected for Book. You can use it to specify the name of the workbook which will be used to output the linear fit tables. In other cases, this will be used to display the name of the book which will be used to output the linear fit tables. Sheet This is not editable. The tool always creates a new worksheet in the destination workbook to output the linear fit tables. So the Sheet box always displays <new>. SheetName Specify the name for the sheet that will be used to output the linear fit tables. Results Log Specify whether to output the results to the Results Log. Script Window Specify whether to output the results to the Script window. Notes Window Specify the name of the notes window, which will be used to output the results. If <none> is entered here, the results will not be output to any notes window.
Fitted Curves	Specify the destination to output the data of the fitted curves Book Specifies the destination workbook. <auto> Let Origin automatically decides the destination workbook. <source> Use the source data workbook. <report> Use the workbook which has the fitting report. <new> Use a new workbook. <existing> Pick an existing workbook and use it as the destination workbook. BookName The name of the destination workbook. Sheet Specifies the destination worksheet. <source> Use the worksheet where the source data comes from as the destination worksheet. <new> Create a new worksheet and use it as the destination worksheet. <existing> Pick an existing worksheet as the destination worksheet. SheetName The name of the destination worksheet.
Fit Residuals	Specifies the destination workbook and worksheet for residual values Book Specifies the destination workbook. <fittedvalue> The workbook that has the fitted values. <source> Use the source data workbook. <new> Use a new workbook. <existing> Use an existing workbook. BookName The name of the destination workbook. Sheet Specifies the destination worksheet. <fittedvalue> The worksheet that has the fitted values. <new> A new worksheet. <existing> An existing worksheet that is specified by you. SheetName The name of the destination worksheet.
Find Specific X/Y Tables	Specifies 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 Specifies the destination workbook. <fittedvalue> The workbook that has the fitted values. <source> The workbook that has the source data. <new> A new workbook. <existing> An existing workbook that is specified by you. Sheet Specifies the destination worksheet. <fittedvalue> The worksheet that has the fitted values <new> A new worksheet. FindX SheetName This is only available when New is selected for Sheet. You can use this edit box to specify the name of the worksheet which will be used as the Find X table. FindY SheetName This is only available when New is selected for Sheet. You can use this edit box to specify the name of the worksheet which will be used as the Find Y table.
Optional Report Tables	Use the check boxes before each item to specify whether to include it in the fitting report. Notes Input Data Masked Data Missing Data

Fitted Curves Plot

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	Check this check box to specify whether to update legend on the source graph.
Multiple Plots Use Source Graph Color	Check this check box to 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.

Find Specific X/Y

This option is the same as its counterpart in the Linear Fit dialog.

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. 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. 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

Reference

York D, Unified equations for the slope, intercept, and standard error of the best straight line, American Journal of Physics, Volume 72, Issue 3, pp. 367-375 (2004).
G. Fasano and R. Vio, "Fitting straight lines with errors on both coordinates", Newsletter of Working Group for Modern Astronomical Methodology, No. 7, 2-7, Sept. 1988.

Linear Fit with X Error Dialog (OriginPro Only)

Contents

Recalculate

Multi-Data Fit Mode

Input Data

Fit Options

Quantities to Compute

Output Settings

Fitted Curves Plot

Find Specific X/Y

Residual Plots

Reference