Prev: How can I set a "page end" point on a large worksheet?
Next: VLOOKUP use column name not number
From: Abby on 11 May 2010 13:03
I'm attempting to forecast the amount of money spent on the purchase of
company cars for the remaining of the fiscal year. (Column 1: Costs of cars
and Column 2: Volume of cars) I've done a simple regression but the Adjusted
Square value was 80%. I dont think this would be the best way to forecast. I
created an XY scatter chart to view the relationship and it is a direct
relationship. I'm not sure which formula to use to obtain a very accurate
forecast. Any help is appreciated.


From: Abby on 11 May 2010 13:06
I also forgot to mention that I have about three fiscal years worth of
historical data to assist with my forecasts.

"Abby" wrote:

> I'm attempting to forecast the amount of money spent on the purchase of
> company cars for the remaining of the fiscal year. (Column 1: Costs of cars
> and Column 2: Volume of cars) I've done a simple regression but the Adjusted
> Square value was 80%. I dont think this would be the best way to forecast. I
> created an XY scatter chart to view the relationship and it is a direct
> relationship. I'm not sure which formula to use to obtain a very accurate
> forecast. Any help is appreciated.
>
>
 | 
Pages: 1
Prev: How can I set a "page end" point on a large worksheet?
Next: VLOOKUP use column name not number