Solved

Forecasting growth of product

Posted on 2013-01-02
2
250 Views
Last Modified: 2013-03-23
Hello

We have a software application that is used within our organisation named TRACKER. We recently rolled this out globally and the uptake has been good.

I have numbers on the amount of users "purchasing" this software internally over the last 6 months.

What I'd like to do is somehow forecast, based on the current growth, what number of users will be using this software in another 6 months, 12 months etc.

I'm not sure how I can do this, can anyone advise? I was thinking at the most basic level, Excel 2007 must have some feature?
0
Comment
Question by:redman20111
2 Comments
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38736238
Hi yes try the FORECAST equation first in Excel, it is a linear approach. If you want visuals then a simple scatter plot by month with a trend line (linear, binomial, polynomial etc) will work fine. If you like to send some sample data through I can send you back up a suitable chart.
Hope that helps
...Terry
0
 
LVL 13

Expert Comment

by:MrBullwinkle
ID: 38737089
You can create a line/scatter graph in excel with weekly, or monthly totals. Then create a trend line(choose linear or exponential most likely), and use the forecast on that.  6 month Data points won't give you much, but 24weeks should.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I worked at a US software company that used offshore contractors for ten years and offshore employees for three years. We had a positive experience and you can too.   When I interviewed people for positions in the US, I would tell them that we wor…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now