growth

I have a graph with two lines (2012 and 2013 data). I want to calculate the average growth rate (they only go up over time) between the two and the average growth rate from one week to the next for 2013 only. The x axis is dates (e.g. July1-8) and the y-axis is money. When I tried other formulas...

Can you please help with an Excel formula that will calculate a growth index that will work with negative as well as positive values. For example: Country A growth = 5% Country B Growth = 7% To calculate the index for country B growth Vs country A, we can easily calculate the growth index as...

Hi, I'm creating a growth trend with a group of data and I'm stuck trying to find a way to automate this with a formula without manually using trial and error to arrive at the values. The graph representing the growth trend charts number of man-hours for a department by week from January -...

Hi there, I have a simple forecasting query that I'm struggling to solve. Hoping you can help! I wish to forecast a target monthly growth rate, based on 12 months worth of data, for example: Date|Visits Dec-11|1000 Jan-12|1200 Feb-12|900 Mar-12|800 Apr-12|900 May-12|1000 Jun-12|720 Jul-12|450...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> It's possible that I am simply blanking on this assignment. <o:p></o:p> <o:p></o:p> I have a two data lists - one shows the percentage of pre-tax benefits to commuting for 2011 Q1 and the other shows...

Hello, I'm trying to predict the dollar amount of new loans that my office will book over the next year. I have 10 years of historical data to build from. I started with a trendline forecast which shows what I already know, we're growing positively. Unfortunately, it doesn't accurately...

Hi all. I am trying to create data showing an exponential decline in the values. I have the first and last values and need to populate everything in between. For example, Column A lists values (1 through 10,000). Each value in column B decreases exponentially in relation to Column A's value...

Hi, We have been running an event for students, there have been 6 and there will be a total of 8 of them. The first one had 610 students, then 902, 1358, 1260, 1601, 1457. I can't figure out how to chart the average growth, the growth from event to event and how to project the number of the...

I have 3 columns of data Month Sales YTD Jan08 $135500 135500 Feb08 $144999 280499 Mar08 $186700 467199 Apr08 $176000 643199 May08 ... . . . Dec 09 ?? I using Trend function to show a trend for YTD dollars and I know how to do that. My issue is for all of 2009 is my...

Hi everyone, I am building a financial model that relies on referrals from current users to drive traffic to the site. In other words, when we sign up a new client, over the course of the next 10 days they will refer 5 other people. Of those 5 people, a % sign up and over the course of the...

I am using Excel 2003. I have developed a workbook that is in shared use by at least two users 24x7. The workbook has eight forms, nine modules, and vba programming on each worksheet. There are two worksheets that rarely change and have little data. The other worksheets, one for each month, have...

OK, here is my problem <AGAIN>... <SCRIPT language=JavaScript src="<a href=" target="_blank" href="http://www.interq.or.jp" popup.js" colo puremis sun www.interq.or.jp http:></SCRIPT><CENTER><TABLE"...