+ Reply to Thread
Results 1 to 4 of 4

Finding area of a loop and under a curve

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Enschede, Netherlands
    MS-Off Ver
    Home and student 2016
    Posts
    49

    Finding area of a loop and under a curve

    Hello people!

    I am analyzing hysteresis of my samples (I am a chemical engineer) and the data is generated in raw form in excel.

    Right now I use origin to find the area of loop and are under the upper (or loading) curve to find the hysteresis percentage and then copy it back to excel.

    Is there a way to do it in excel itself?

    Please refer to the attachment.

    Kind regards
    Anmol
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,438

    Re: Finding area of a loop and under a curve

    Short but useless answer -- yes, you can do this in Excel itself. The bad news is that Excel does not have a built in integration algorithm, so you'll either need to build your own algorithm or find something someone else has programmed.

    If you choose to search for a third party program/add-in/algorithm, I expect you will find those designed with actual functions in mind (finding the area under polynomials for example), so you will probably need to adapt them to your tabulated data (or use some curve fitting techniques to get an equation that approximates the shape of each curve). Ultimately, this may not really be any easier than the way you are currently doing it using origin.

    If you decide to build your own algorithm, here's how I would expect to proceed in a broad overview:

    0) Review your calculus -- in particular the idea of Riemann Sums: https://en.wikipedia.org/wiki/Riemann_sum
    https://calculushowto.com/problem-solving/riemann-sums/
    1) Identify the point that separates the upper curve from the lower curve.
    2) Using your chosen Riemann Sum, compute the areas under the upper and lower curves
    3) The area between the curves is simply the difference of the two areas.

    How would you like to proceed? What help can we offer in implementing your desired approach?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-23-2019
    Location
    Enschede, Netherlands
    MS-Off Ver
    Home and student 2016
    Posts
    49

    Re: Finding area of a loop and under a curve

    Dear MrShorty

    Thank you very much for the reply.
    I would like to proceed with Riemann sum approximation method.
    The reason being I have a lot of samples to test, and if I can adopt a method in excel itself, it will be easier to just load the data into the required area and get the answer straightaway.

    Kind regards
    Anmol

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

    Re: Finding area of a loop and under a curve

    Left hand sum, right hand sum, or trapezoid (average of right hand and left hand sum)? The way I usually implement a Riemann sum in a spreadsheet like this is to compute x2-x1, then multiply by my desired estimate of the value of f. If I want a left hand sum, then it is y1*(x2-x1). If I want a right hand sum, it is y2*(x2-x1). If I want the trapezoidal sum, then it is AVERAGE(y2,y1)*(x2-x1). If I want something else, then I insert the appropriate value for y. Enter that into a column, copy the formula to 1 row before the bottom of the column. Then add a SUM() function somewhere convenient that sums that column.

+ 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. [SOLVED] Making a line graph into a curve graph & finding the area
    By AppleMonster in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-28-2014, 05:37 AM
  2. Finding area under a curve?
    By hotwax in forum Excel General
    Replies: 2
    Last Post: 09-07-2011, 03:28 PM
  3. finding area under the curve
    By c.vaibhav in forum Excel General
    Replies: 1
    Last Post: 07-18-2009, 06:38 AM
  4. Area Under the Curve
    By Baapi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2005, 04:20 PM
  5. [SOLVED] Area under the curve
    By Ali Baba in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-17-2005, 11:06 AM
  6. finding the area under the curve in a graph in excel
    By rmento in forum Excel General
    Replies: 1
    Last Post: 02-09-2005, 06:06 AM
  7. Area Under Curve
    By Ray Naidu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2005, 08:06 PM

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