I am trying to fit a curve to four points in 3 dimensional with X1,Y1,Z1 ....X4, Y4, Z4 coordinates. Is there any Excel functions that can use to fit some kind of equation to and calculate intermediate points between the four points?
I am trying to fit a curve to four points in 3 dimensional with X1,Y1,Z1 ....X4, Y4, Z4 coordinates. Is there any Excel functions that can use to fit some kind of equation to and calculate intermediate points between the four points?
If your desired equation (z=f(x,y)) is a linear function, then you can use the LINEST() function to obtain the parameters of the function. (Note that "linear" here is more of a linear algebra sense, so that it can be used for much more than straight lines and planes.) https://support.office.com/en-us/art...a-fa7abf772b6d
If your desired equation is not linear and cannot be transformed to something linear, then you can use non-linear regression techniques that involve the Solver utility to optimize your desired objective function. https://support.office.com/en-us/art...b-f63e45925040
What kind of regression are you trying to do?
Originally Posted by shg
Not sure. I used to use a Spline DLL but it won't run on Windows 7 or later. I have no idea what type of regression the program uses.
With name like "Spline", I would guess it is using some kind of cubic spline algorithm. How important is it to your algorithm that you exactly match what this previous "spline.dll" did?
If it is necessary to exactly match what spline.dll did, then it will likely be necessary to know what spline.dll was doing.
With four points, I am not sure what difference there would be between a simple cubic polynomial regression and a cubic spline. If you are not terribly concerned with exactly matching spline.dll, then a first guess might be to try a simple cubic polynomial regression using LINEST() (see help file linked above).
Beyond that, I'm not sure what to recommend without knowing something more about the desired regression equation.
I believe the Spline.dll does generate a polynomial representation of a curve through 4 points (can use more than 4 points if desired). I'll look at LINEST().
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks