Hello- Can anyone please help me on how I can create an adoption curve in excel.
If I have the following information available
1.Product Launch Share : 12% ( i.e Y1 12%)
2. Product peak share: 25% (i.e this is the highest share of the product and when we reach at this stage we remain at this stage)
3. years to peak: 5 years
S0, Y1: 12%, Y2: ? , Y3:? Y4: ? Y5: 25%, y6: 25%., Y7: 25%
I tried using the fisher-pry method but there the formula is only calculating the 50% adoption share.
Can anyone please assist? Excel example attached
Thanks
Naina
If I have the following information available
1.Product Launch Share : 12% ( i.e Y1 12%)
2. Product peak share: 25% (i.e this is the highest share of the product and when we reach at this stage we remain at this stage)
3. years to peak: 5 years
S0, Y1: 12%, Y2: ? , Y3:? Y4: ? Y5: 25%, y6: 25%., Y7: 25%
I tried using the fisher-pry method but there the formula is only calculating the 50% adoption share.
Can anyone please assist? Excel example attached
Thanks
Naina