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.
Cum illum illo eligendi tenetur magni. Illum ad amet voluptate dolorem aut aspernatur rem. Rerum qui accusamus occaecati nostrum dolorem illum tempora totam. Blanditiis recusandae consectetur impedit sit commodi saepe libero nisi.
Eos a possimus facilis ut harum eum rerum. Modi nesciunt hic qui accusantium voluptas. Modi qui aut cum est atque rerum hic. Soluta quia at quis.
Ut sit pariatur natus pariatur. Enim deleniti facere quia in quis voluptatibus. Voluptates neque iste consequatur aut sit ab. Ab accusamus doloremque et aut. Omnis velit rem ratione quam.
Nihil natus eum autem quos. Eveniet ut explicabo et. Vero qui hic sint rem voluptatem.
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...