| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Area chart with multiple regions | Charts and Charting in Excel | |||
| How do I draw a quadrant with coloured regions in Excel? | Excel Discussion (Misc queries) | |||
| Defining Regions with Names | Excel Discussion (Misc queries) | |||
| How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
| Locking rows or Regions in Excel worksheets | Excel Worksheet Functions | |||
Threaded Mode
