Pattern between Copper Prices and Construction spending
Hello Guys,
Please advice on this:
How do i find a historic pattern between and construction spending... I am trying to forecast prices for copper prices.
and if I come up with the number how do i adjust in to my sales and balance sheet (inventory) since copper is part of raw materials?
Thanks a bunch!!!
-Research yearly housing data (cost, growth..) -Research yearly copper prices (if not find another commodity with strong correlation and substitute appropriately) -Plot your findings -come up with an estimate of the relation between the housing data and copper data - recognize current trends in both housing and copper prices -use that estimate in you calculation of future trend for copper prices
hope this helps
just put a few years worth of date for copper pricing and industrial spending into excel. run a regression and find the correlation.
I am sorry im weak at this but how do u run a regression and a correlation... I know the funtion in excel but... an example would be great..
does an y body have an example of similar case.. sorry for being a pain.. just trying to learn..
minitab is a good software :)
Use Linest function.
google it dude, its not that hard, dont feel like explaining it.
Tempora rerum accusamus vel reiciendis dicta. Ut sint id sint sit. Et aut qui ex nihil hic.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...