Regression for Demand vs Prices

BankingAnalyst · April 4th, 2014, 5:37 pm

Hi,I would like to do a regression for demand numbers vs the prices. Obviously if demand goes up so does the prices for certain commodities. However I will need to forecast the prices very accurately. Do you know how to do it quickly and accurately? I tried to do it on Excel with those forecast functions but the result looks random. I know that regression for prices is difficult but I am wondering if there is anyone who can give me a hand on that?Thanks,

daveangel · April 4th, 2014, 5:41 pm

have you tried regressing the changes in demand and change in price ? that may be more helpful.