Resetting Regression parameters

[Ronald C. Antweiler]

When I call for a linear regression in Excel, I am required to give the
"y-range", the "x-range" and the "output range" for the data. This is fine
the first time I access the linear regression. However, on all subsequent
calls for linear regression, Excel remembers the "y-range", "x-range" and
"output range" from the previous time. Is there a way to reset these so that
Excel does NOT remember them (short of exiting from Excel and re-entering)?

 

[Rafael Ortiz]

Try using the LOGEST function - that will produce the same regression data
as does the method you are using, and it will "respond" immediately as you
change x and y values...

MRO

 

[Tushar Mehta]

OK, I must be missing something. Even though XL remembers the
previously specified parameters, one can change them. Right? So,
where's the harm with what XL does?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Ronald C. Antweiler]

The major problem (for me) is that the previous "call" for regression may
have been made for example at cells S124:S148 for the y-range and similarly
for the x-range and output range. But when I wish to invoke the regression a
second time, perhaps I am now working at cell BX4533. Since Excel does not
allow me to reset the range, when I go to request a second regression, Excel
moves me back to cell S124 and unless I wish to manually put in the new
range of, say, BX4533:BX5338, (rather than simply using the mouse to
highlight the range as I am accustomed to do) it is a major inconvenience.

Ron A.