+ Reply to Thread
Results 1 to 5 of 5

3D Curve Fitting

  1. #1
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    3D Curve Fitting

    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?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: 3D Curve Fitting

    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?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    Re: 3D Curve Fitting

    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.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: 3D Curve Fitting

    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.

  5. #5
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    Re: 3D Curve Fitting

    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().

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. fitting curve equation 4PL and 5PL
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-13-2016, 01:18 PM
  2. Curve fitting questions
    By Joe Miller in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-22-2014, 02:45 AM
  3. Curve Fitting and interpolation
    By salmanisn in forum Excel General
    Replies: 3
    Last Post: 01-24-2011, 04:18 AM
  4. curve fitting
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2006, 02:10 PM
  5. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM
  6. [SOLVED] Best fitting curve
    By ladee_bird in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2005, 09:05 AM
  7. best curve fitting
    By ladee_bird in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2005, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1