Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use integration to work out the area under a curve?
I'm trying to use Excel to work out some targets and I know I want a 4%
reduction over the year- i.e. I had 100 last year and want 96 this year, so how do I work out how many I need to record in each financial quarter to make that happen? It wouldn't be one per quarter because that would give me a 'flat-line' target and not a decreasing trajectory. Apparently there's a formula, possibly something to do with integration and working out the area under a curve? Can anyone help??! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the area under a curve (integration) in Excel? | Charts and Charting in Excel | |||
Integration/area under a curve VBA code? | Excel Worksheet Functions | |||
Integration/area under a curve VBA code? | Excel Discussion (Misc queries) | |||
how do I caculate the area of a chart (integration)? | Charts and Charting in Excel | |||
How to I do integration in Excel XP (calcuating area under a curv. | Excel Discussion (Misc queries) |