Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Calculate an area under graph?

1. I agreed to these rules
Join Date
30th April 2004
Location
far from heaven
Posts
3
Hi everyone, I&#039;m trying to find way to calculate area under graph, in other words integral.Does anyone know how to do it? My graph is buld of sinle poits.

2. How accurate do you need the area to be? Are the points evenly spaced? If so a simple approximation is just the sum of the y values times the interval between them.

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
Join Date
30th April 2004
Location
far from heaven
Posts
3
Thanks Derk & thomach. I took a look at the links. In general i know how ingergral works.But in my case i have function that has exponential behaviour. The values are measured not equal interval of times. Well, i don&#039;t understand by myself what i&#039;ve wrote here. I will explain you my whole issue so it will be clear what i want to do:
I building a battery for my old laptop (which consists of 10 sequently connected 1.2v rechargable batteries) I connected everything. The main problem is to check if they are charged properly . In other words i have to determine when to stop the charge in order to not overcharge them. So here what i do. I put empy batt. pack and starting to charge it, every couple of minutes i measure charge current and time and adding into excell. at the beginning current is big, and getting smaller with time with exponential behaviour. The area under graph - is battery capacity (mAh). It&#039;s a pity i cannot attack file to show you. So i than have to make some graph approximatian from those points that i entered. The only thing i found is "Add trendline" where i can choose a polynom or othe func typle (log, etc) that will be approximation to my curve. Excell does it perfectly. I.E i right-click on my ponts, choose Add trendline, choose appropriate polynom, and see a line that repeats my points very accurate (i don&#039;t need extreme precision) But i don&#039;t see a formula of this curve????. That&#039;s the problem, if i only could see a forumula i could calculate integral by myself, for example (5x^3-6x^2-x+25x^(-1)) etc.

If you got tired reading all this mess, BOttom line question:
I have some graph (curve) How can i know it&#039;s formulla f(x) ??? at least approximately?

4. I can't offer a direct answer, but you might have a look at the chart Area sheet from the "Average Line" tutorial that Andy Pope provides via this link:

http://www.andypope.info/charts/averageline.htm
Last edited by Dave Hawley; December 23rd, 2009 at 06:51.

5. If you are happy with the trend line and just want the equation, Excel will give it to you! When you are at the add trendline dialog box, click on the Options tab and select display equation. Tha&#039;s it. Then integrate the equation.

Excel Video Tutorials / Excel Dashboards Reports

6. I agreed to these rules
Join Date
30th April 2004
Location
far from heaven
Posts
3
Thanks you guys, "display equation" in trendline dialog- is exactly what i wanted. How culd i missed it??.
Thanks again.

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

#### Posting Permissions

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