• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Product Launch curve or adoption curve

naina

New Member
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
 

Attachments

p45cal

Well-Known Member
The attached is a pure guess.
I don't know what I'm doing.
I played around with the factors in the fisher-pry formula (using solver) until it came out looking right.
I'm unlikely to be able to answer further questions on this because, well, I don't know what I'm doing.
76595
 

Attachments

naina

New Member
The attached is a pure guess.
I don't know what I'm doing.
I played around with the factors in the fisher-pry formula (using solver) until it came out looking right.
I'm unlikely to be able to answer further questions on this because, well, I don't know what I'm doing.
View attachment 76595
thanks a lot for taking out your time to work on this. I greatly appreciate
 
Top