+ Reply to Thread
Results 1 to 8 of 8

max value of curve

  1. #1
    Registered User
    Join Date
    05-02-2021
    Location
    pakistan
    MS-Off Ver
    ms office 13
    Posts
    6

    max value of curve

    Hi there,
    I want to find the max value of curve which is max between two given values of y .

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: max value of curve

    Please do not post duplicate threads - I have closed the other 1.

    Do you know the formula for this?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-02-2021
    Location
    pakistan
    MS-Off Ver
    ms office 13
    Posts
    6

    Re: max value of curve

    No just the data points

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

    Re: max value of curve

    I think there are generally two approaches to this kind of problem. Either you start with a regression where you fit your data to a curve, then use strategies from calculus to find the maximum value of the regression equation. Or you use an interpolation approach using some kind of cubic or other spline function. Without knowing more about the data you have and the approach you want to take, I'm not sure we can be very specific.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    05-02-2021
    Location
    pakistan
    MS-Off Ver
    ms office 13
    Posts
    6

    Re: max value of curve

    The equation of my data is dependent on more than one variable. So I can't directly use the given equation to find maxima using calculus. And when I tried to curve fit using polynomial trend curve the equation of trend line curve doesn't follow the given data curve. I have attached the file as u can see the max value of y lie between the value of x 30 and 40. Which I want to calculate.
    Attached Files Attached Files

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

    Re: max value of curve

    Is a polynomial the only regression equation you have tried? I know that polynomials are often a default first equation type to try, but they are far from the only possibility. A quick look at the sample data set suggests that a hyperbola might be a good fitting equation (though it will require implementing a non-linear regression technique): https://tutorial.math.lamar.edu/Clas...yperbolas.aspx

    Another strategy I see is to select 3 or 4 points that encompass the maximum, fit those points to a quadratic or cubic polynomial, then solve that equation for the maximum. The first step is to select the desired points, then perform the regression, then solve for the maximum.

    Extend this far enough, and it essentially becomes a spline interpolation problem. The main obstacle to this in Excel is that Excel does not have a built in spline interpolation (or any interpolation function). If you can use a spreadsheet other than Excel, Gnumeric has a built in spline interpolation function that can work. If you must use Excel, you will need to make your own spline function or find someone else's (see discussion here: https://www.excelforum.com/excel-gen...ta-points.html ).

    You indicated that your real problem has multiple input variables, but your sample shows only one input variable (x). Have you over-simplified your example?

    Ultimately, this kind of problem usually reduces down to some kind of A) choose a regression equation B) perform the regression C) solve the result for the maximum algorithm. Of course, there are multiple possibilities within that framework, but I'm not sure we are in a position to choose the final strategy for you. Does any of this suggest a strategy you would like to use for this? If you help us understand the strategy you want to use, then we should be able to help you program that into the spreadsheet.

  7. #7
    Registered User
    Join Date
    05-02-2021
    Location
    pakistan
    MS-Off Ver
    ms office 13
    Posts
    6

    Re: max value of curve

    Thanks for the suggestion Mr Shorty. Using quadratic interpolation , i have been able to calculate the maximum of curve for the given data points.

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

    Re: max value of curve

    Glad to help.

+ 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. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  2. Find exact formula of a curve and fix the bumps in the curve
    By twobox in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-16-2015, 12:25 PM
  3. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  4. Need to derive curve from values, then apply curve to another data set
    By Telperion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2014, 09:57 PM
  5. Graph a curve, then enter data to generate new similar curve
    By denphi03 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-03-2013, 05:33 PM
  6. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  7. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM

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