How to find beta?
 

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?

Hi Pat,

Just check in your add-in (ToolsAdd-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




"Pat" <Pat @discussions.microsoft.com wrote in message
...
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?

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..

"Paulw2k" wrote:

Hi Pat,

Just check in your add-in (ToolsAdd-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




"Pat" <Pat @discussions.microsoft.com wrote in message
...
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?