Thread: optimization
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dschneiderch dschneiderch is offline
external usenet poster
 
Posts: 2
Default optimization

I will try to explain clearly.

I have a bi-linear curve and I would like to know where the breaking
point is. Looking at a graph of the ordered data (highest to lowest),
it seems to be ~30%. Basically what I need to do is figure out which
ranges of cells would give the greatest difference in average slope if
slope is computed as (Wi-Wi+1)/1. For example, it might be the
average of Wi-Wi+1 for i=1 through i=84 and the average of Wi-Wi+1 for
i=85 through i=244.
Example:
i W m
1 95
2 85 10
3 80 5
4 75 5
5 70 5
6 65 5

Here the solution is easy. The difference in m_avg is greatest
between i=1:2 (10) and i=3:6 (5)

Thanks
ds