It's a hard one

[A.Ballantyne]

Bit of a long one this. It's all to do with finance. I've got 120 monthly returns for a company and 120 returns for the market as a whole. The idea is this company has a beta or set number which reflects how this company moves in relation to the market. I know you can use the regression function in the tool pack to work out the beta for this company, but I can't. Can anyone help?

 

[Chris Davison]

see if this helps,

http://www.mrexcel.com/board/viewtopic.php?topic=576&forum=2