View Single Post
  #1  
Old June 2nd, 2010, 05:49 PM posted to microsoft.public.excel.misc
lex
external usenet poster
 
Posts: 19
Default Regions of Constant Slope

I have a set of data x, y and want to find regions (or ranges) of "constant"
slope and I want the value of the slope and range x of that "constant" slope.
I'm not exactly sure what I mean by "constant" (note the quotes) but believe
I *may* be able to use RSQ (R-Squared) to define it.

I *believe* I may have to do it in VBA as I want to automate it - but again
- I'm not sure.

Your help is greatly appreciated.

Thank you!