Results 1 to 4 of 4

Thread: Algebra, Excel, Statistics, and fan curves...Question.

  1. #1
    FLAC
    Join Date
    Oct 2006
    Location
    Las Vegas
    Posts
    1,286

    Algebra, Excel, Statistics, and fan curves...Question.

    It's been a while since I formally learned any algebra, and I've never really spent much time with statistics.

    Example PDF.

    What I want to do, is take a set of about 5 points (pressure,flow) and create a 2nd order polynomial from them, just the same way that excel does it with the trendline function on a chart. I could just cut and paste the shown equation and use it to complete more points,but..

    The application I have for this needs to use the equation as a function: ax^2+bx+c; where a, b, and c are stored as constants, after 'calibrated' by intrepreting a minimum number of points.

    How does excel 'interpret' the points for a poly? Is it a proprietary combination of LINEST and LOGEST? Where's a good place to find out?

    How many points would be a good minimum for accuracy?

    How would I do it mathematically, without using excel?

    Any points in the right direction (other sites would be fine too) would be much appreciated.

  2. #2
    Variable Bitrate
    Join Date
    Jan 2007
    Location
    East Central FLA
    Posts
    241
    For a polynomial curve fit I believe you will be looking at a least squares problem, solving matrix equations, etc. This really is a computational suited task - I think it would take a long, long time by hand. I'm sure the math methods are out there if you plug a few your words into google.

    there might be newer methods - I've been out of school for a lot of years.

  3. #3
    FLAC
    Join Date
    Oct 2006
    Location
    Las Vegas
    Posts
    1,286
    After researching a bit, it seems to me you're right about the least squares polynomial fit, thanks for the pointer
    It made an excellent search term for me.

  4. #4
    FLAC
    Join Date
    Oct 2006
    Location
    Las Vegas
    Posts
    1,286
    I found what I'm looking for, and for anyone interested:

    SPLINE
    -
    library of C++ routines, using double precision arithmetic, for constructing and evaluating spline functions.

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
  •