Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. (20pt) You want to check whether a single factor model explains the excess return of Apple Inc. stock using the overall market performance. (Refer
3. (20pt) You want to check whether a single factor model explains the excess return of Apple Inc. stock using the overall market performance. (Refer to the example of Amazon's single factor model in Lecture 3 - Part III.) Data source - Apple Inc, monthly price: Yahoo! Finance -QQQ ETF (monthly market performance): Yahoo Finance - Risk-free rate: Kenneth R. French's website The test period is from January 2011 to December 2020. Compute the correlation coefficient p and the R-square without using the CORREL function and data analysis in Excel. 3. (20pt) You want to check whether a single factor model explains the excess return of Apple Inc. stock using the overall market performance. (Refer to the example of Amazon's single factor model in Lecture 3 - Part III.) Data source - Apple Inc, monthly price: Yahoo! Finance -QQQ ETF (monthly market performance): Yahoo Finance - Risk-free rate: Kenneth R. French's website The test period is from January 2011 to December 2020. Compute the correlation coefficient p and the R-square without using the CORREL function and data analysis in Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started