It's a hard one

A.Ballantyne · Apr 11th, 2002, 09:50 AM

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 · Apr 12th, 2002, 02:00 PM

see if this helps,

http://www.mrexcel.com/board/viewtop...ic=576&forum=2

Apr 12th, 2002, 02:00 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	see if this helps, http://www.mrexcel.com/board/viewtop...ic=576&forum=2 __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 09:50 AM	#1
A.Ballantyne New Member Join Date: Apr 2002 Posts: 4	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?