The attached spreadsheet fm3_chapter08.xls includes price data for the Dow-Jones 30 Industrials from July 1997 through July
Question:
The attached spreadsheet fm3_chapter08.xls includes price data for the Dow-Jones 30 Industrials from July 1997 through July 2007. Isolating the data for Alcoa (AA)
and Johnson & Johnson (JNJ), confi rm the following statistics about the returns of these two stocks:
Transcribed Image Text:
AA 0.68% 4 Sigma 5 Covariance 6 10.12% 1 A B DEF ALCOA (AA) AND JOHNSON & JOHNSON (JNJ) Return statistics, 1997-2007 2 Monthly statistics 3 Average JNJ 0.72% AVERAGE(F16:F135) 5.84%
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (QA)
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.