Over a million developers have joined DZone.

Quick Hacks: How To Calculate Growth Rate for Your Product

DZone's Guide to

Quick Hacks: How To Calculate Growth Rate for Your Product

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

· Agile Zone ·
Free Resource

Adopting a DevOps practice starts with understanding where you are in the implementation journey. Download the DevOps Transformation Roadmap. Brought to you in partnership with Techtown.

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.

Take Agile to the next level with DevOps. Learn practical tools and techniques in the three-day DevOps Implementation Boot Camp. Brought to you in partnership with Techtown.

growth hacking ,growth

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}