It is a simple Excel add-in, with a simple user interface. The calculations are based on explicit algorithms. When installed, the utility has a simple menu item on the PTS Charts menu.
The PTS Deming Regression Utility provides two methods for calculating Deming Regression parameters. You can use custom worksheet formulas, or you can use a dialog-driven interface.
The Deming Regression results are returned in a three-element array formula with this syntax:
=DEMING(Y-values, X-values, Horizontal)
Y-values and X-values are required arguments which reference ranges. Each range must be one row or column only, with an even number of cells, and the two ranges must be the same size. The Horizontal argument is an optional True or False indicating the orientation of the output. The default is TRUE, and the results will be output in a row.
Don’t forget, the entire range containing the array formula is selected, the formula is typed, and it is entered by holding down CTRL+SHIFT and pressing ENTER.
Comments