Over a million developers have joined DZone.

Quick Hacks: How To Calculate Growth Rate for Your Product

How to calculate a percentage that accurately represents your products growth rate

· Agile Zone

Learn more about how DevOps teams must adopt a more agile development process, working in parallel instead of waiting on other teams to finish their components or for resources to become available, brought to you in partnership with CA Technologies.

Say that you've got a set of numbers that represent growth for your project. Whether it's installations, signups or revenue it doesn't matter too much - you just need to provide a percentage. Although it seems like a difficult thing to work out, there are some really easy ways to do this. 

I'm going to assume that you've already plugged these numbers into a spreadsheet application. I'll show how you can do this with Excel. 

First, make sure to plot your data in a scatter plot. Image titleThen click on the series that you want to calculate growth on and choose to Add Trendline 

Image title

Choose an Exponential trendline 

Image title

And choose to display the equation on the chart through the Options  

Image title

You'll now see the formula (highlighted in the screenshot below) 

Image title

The power section of this is where you can derive the growth % from - you just need to multiple it by 100 to get the %. In the case above .0069 results in a growth rate of .6%. 

You can see other ways to calculate growth from the comfort of Excel in the igetit newsletter.

Discover the warning signs of DevOps Dysfunction and learn how to get back on the right track, brought to you in partnership with CA Technologies.

growth hacking ,growth

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}