How to calculate an interpolation...

205 Views

Hi Everybody,

Iu2019m struggling with the percentile calculation using simple interpolation.

I have following inputs:

Table:

Day_bucket 1| 2| 3| 4

Responses 10| 20| 50| 20

Cumul_responses 10| 30| 80| 100

Percentile 0.1| 0.3| 0.8| 1

1. Day_bucket u2013 days from 1 to 100 (dimension)

2. Percentile u2013 percentile distribution u2013 how many % of all responses have been received in a particular day from Day_bucket dimension (measure)

3.Interpolation equation: d=d1 + ((g-g1)*(d2-d1)/(g2-g1))

g - percentile you are looking for (in my case 0.9)

g1 - MAX percentile < 0.90 (in my case 0.8 )

g2 - MIN percentile > 0.90 (in my case 1)

d1 u2013 Day_bucket where percentile is equal to g1 (in my case 3)

d2 u2013 Day_bucket where percentile is equal to g1 (in my case 4)

d u2013 value Iu2019m looking for (in my case 3.5)

Now what I need to do is to get the result of above equation into one field. And my problem is that I not able to calculate g1, g2, d1, d2.

Can anybody help me? Is it actually possible to make such calculation in Business Object?

Edited by: gonosgon on Jul 20, 2010 2:46 PM