If sresiduals is TRUE, REGRESS includes standardized residuals in the output table. If residuals is FALSE or omitted, residuals are not included. If residuals is TRUE, REGRESS includes residuals in the output table. If FALSE, blank, or omitted, places the summary output table in a new workbook. The name, as text, of the new sheet to contain the summary output table. Is the first cell (the upper-left cell) in the output table or Is an additional confidence level to apply to the regression. Microsoft Excel will then generate the appropriate data labels for the output table. If labels is FALSE or omitted, all cells in inpyrng and inpxrng are considered data. If labels is TRUE, then the first row or column of the input ranges contain If constant is FALSE or omitted, the y-intercept is assumed to be a non-zero Is the input range for the x-values (independent variable).Īssumed to be zero (the regression line passes through the origin). Is the input range for the y-values (dependent variable). I’m reproducing it here so that I don’t have to rely on that forum post always being available. What do all these mean? I could have fussed about with trial and error but luckily I found a nice post on Google groups from 6 years ago which had all the information. Optional lplots As Variant, Optional routrng As Variant, Optional nplots As Variant,

Optional residuals As Variant, Optional sresiduals As Variant, Optional rplots As Variant, Optional labels As Variant, Optional confid As Variant, Optional soutrng As Variant, This let me open the “VBA Functions and Subs” module and find the signature for the Regress function: Sub Regress(inpyrng As Variant, Optional inpxrng As Variant, Optional constant As Variant, Thanks to this clutch StackOverflow answer, I found out the password is “Wildebeest!!”.

In the VBA editor I could see that “atpvbaen.xls” had been added as a reference to my project.

Vba excel linear regression