I have a very simple problem as you can see below (file attached too.) I'd like to fit a line to measured data. There's something fundamental about minimize (and solving in general) that I don't understand and can't seem to find by searching through the literature. Changing TOL and CTOL have no effect. Help?
1 ACCEPTED SOLUTION
Accepted Solutions
To use "minimize" you have to make "Residual" a function depending on the two arguments "Slope" and "Offset".
But the result you achieve when you use "stdev" is not what you are looking for!
Actually the slope is OK , but the Offset is zero.
Here is a better way to get the line
For other ways to do a linear regression you may lookup the examples in the help files: Example: Linear Regression
To use "minimize" you have to make "Residual" a function depending on the two arguments "Slope" and "Offset".
But the result you achieve when you use "stdev" is not what you are looking for!
Actually the slope is OK , but the Offset is zero.
Here is a better way to get the line
For other ways to do a linear regression you may lookup the examples in the help files: Example: Linear Regression
Thanks! I appreciate the dual methods. What I wasn't getting was how to make "functions" believe it or not. I'll be attempting things much more complicated than linear fitting so I'll need more general approaches.
This worked:
