|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2009, 03:28 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forecast Formula
Hi,
I have a table as per the appended below table. Now I want to forecast what I am going to be doing on sales rate for the 10th of May or for a later date based on the data provided in the table. Date Eligibles Sales Sales Rate 5/1/2009 3618 222 6.14% 5/2/2009 1981 97 4.90% 5/3/2009 2396 122 5.09% 5/4/2009 4719 291 6.17% 5/5/2009 3981 258 6.48% 5/6/2009 3644 281 7.71% 5/7/2009 3081 235 7.63% 5/8/2009 2316 139 6.00% Which formula should I use and how do I go about it? Thanks, Sam. 
|
|
#2
May 12th, 2009, 05:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forecast Formula
What are you using for your forecasting modeling?
More info is required before anyone can recommend an approach to solving this. Irie "Sam" wrote: Hi, I have a table as per the appended below table. Now I want to forecast what I am going to be doing on sales rate for the 10th of May or for a later date based on the data provided in the table. Date Eligibles Sales Sales Rate 5/1/2009 3618 222 6.14% 5/2/2009 1981 97 4.90% 5/3/2009 2396 122 5.09% 5/4/2009 4719 291 6.17% 5/5/2009 3981 258 6.48% 5/6/2009 3644 281 7.71% 5/7/2009 3081 235 7.63% 5/8/2009 2316 139 6.00% Which formula should I use and how do I go about it? Thanks, Sam.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
