gerryucd
Geotechnical
- Jul 12, 2012
- 3
Hi this is my first post on this site and would appreciate some help,
I am doing data analysis of instrumented laterally loaded pile tests, long story short, I have bending moment (y axis) depth below ground level (x axis) curves. I have fitted these data curves with a 4th order polynomial curve. I then use the LINST function to give me the equation of the line I.E. the bending moment equation y= ax4 + bx3 + cx2 +dx + e this equation is then later differentiated and integrated as part of the further analysis.
My issue is, excel appears to just fit a curve with the lowest R2 value or the mathematical best fit (am I correct??). Is it possible to use the solver function to give me alternative fitted curves? Obtaining the lowest R2 value is not priority here it’s more the shape of the line so I would like to use solver to fit a curve and specify that it will have y= + ax4 – b x3 –cx3 +d x +e??
Thanks
Gerry
I am doing data analysis of instrumented laterally loaded pile tests, long story short, I have bending moment (y axis) depth below ground level (x axis) curves. I have fitted these data curves with a 4th order polynomial curve. I then use the LINST function to give me the equation of the line I.E. the bending moment equation y= ax4 + bx3 + cx2 +dx + e this equation is then later differentiated and integrated as part of the further analysis.
My issue is, excel appears to just fit a curve with the lowest R2 value or the mathematical best fit (am I correct??). Is it possible to use the solver function to give me alternative fitted curves? Obtaining the lowest R2 value is not priority here it’s more the shape of the line so I would like to use solver to fit a curve and specify that it will have y= + ax4 – b x3 –cx3 +d x +e??
Thanks
Gerry