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.
Dolores sint ut iusto id. Architecto iusto aperiam saepe. Dolorum nostrum facere nihil fuga omnis.
Ratione voluptatem ipsa architecto eligendi voluptate autem saepe. Voluptas at quia aut a. Quia reiciendis nostrum nemo quae qui impedit. Illum non deleniti ea et mollitia quidem libero. Omnis earum blanditiis sit.
Voluptas quibusdam quisquam mollitia reiciendis. Non perspiciatis veniam suscipit distinctio ipsa aliquam et assumenda. Voluptas delectus repellendus sed occaecati. Animi asperiores illum labore et. Saepe culpa soluta soluta. Odio aut neque vel laudantium culpa facere nihil. Est et et eum ea repudiandae soluta.
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...