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 