How to find beta?

P

Pat

Here is the thing, I am a student in Accounting and I am having trouble with
beta. I have the stocks history for apple and djia, for about 3.5 years, I
have gone thru the rate of returns, now I have to get the Beta for apple for
this 36 month area, and I am lost, can anyone help me thru this?
 
P

Paulw2k

Hi Pat,

Just check in your add-in (Tools>Add-ins) list that you have got the
Analysis Toolpak loaded.
If not, just click on the check box then the OK button. A lot more of
statistical functions will become available that were not previously. You
should now find what you are looking for. Also look around the Excel help
files for further assistance.

Cheers

Paul
 
P

Pat

Thank you, I had torepair that part. I know have the analysis toolpak, and I
found the regression one and of course I am lost again. it ask me for the y
and x and i assume that means the columns that I am compareing ...when i drag
the cursor it counts them...however the next quetion is the output..and than
it goes to I enter the forulma wrong any advise to where i could get the
answer..
 
Top