Please provide the following, by using the below screens: A) The Systematic risk of Netflix and Apple B) The Unsystematic risks of Netflix and Apple C) Which company has a higher systematic risk and why? D) If you knew that the Expected rate return for Apple using the index model is given by : Y=0.0229+ X 0.095 while the market return is 5% what is the expected rate of return for Apple.? YEWE. We NFLX US $ C 332.83 +0.80 Q332.69 /332.70Q 4 0 x 10 TOn 20 Mar d Vol 10,853, 846 0 342.31K H 350.49 K L 332.00D Val 3.696B Dep NFLX US Equity Indep SPX Index 96 Actions 97) Edit Regression Analysis Data Last Price Data Last Price Wkly | Linear Beta +/- Non-Param Reg On Percent - 03/23/2018 - 03/22/2020 - 03/24/2017 - 03/24/2019 Lago Winsorize 2 Std Dev Local OM YTD 1Y 2Y 5Y Max Weekly v >> 7 Slalislics Transformalions Y = NETFLIX INC X - S&P 500 INDEX Linear Beta Range 1 Raw BETA 0.905 Adjusted BETA 0.937 ALPHA (Intercept) 0.299 R^2 (Correlation2) 0.224 R (Correlation) 0.474 Std Dev of Error 1.679 Std Error of ALPHA 0.159 Std Error of BETA 0.167 t-Test 5.430 Significance 0.000 Last T-Value 2.301 Last P-value 0.988 Number of Points 104 Last Spread 1972.09 Last Ratio 0.144 YELAS Dep AAPL US Equity Indep SPX Index 96) Actions 97) Edit Regression Analysis Data Last Price Data Last Price Wkly Linear Beta +/- Non-Param Reg On Percent - 03/23/2018 - 03/22/2020 - 03/24/2017 - 03/24/2019 Lago Winsorize 2 Std Dev Local 6M YTD 1Y 2Y 5Y Max Weekly >> 2 Statistics Transformations Y = APPLE INC X = S&P 500 INDEX Linear Beta Range 1 Raw BETA 1.091 Adjusted BETA 1.061 ALPHA (Intercept) 0.485 R^2 (Correlation^2) 0.518 R (Correlation) 0.720 Std Dev of Error 2.923 Std Error of ALPHA 0.287 Std Error of BETA 0.104 t-Test 10.474 Significance 0.000 Last T-Value -0.502 Last P-value 0.308 Number of Points 104 Last Spread 2075.68 Last Ratio 0.099 Please provide the following, by using the below screens: A) The Systematic risk of Netflix and Apple B) The Unsystematic risks of Netflix and Apple C) Which company has a higher systematic risk and why? D) If you knew that the Expected rate return for Apple using the index model is given by : Y=0.0229+ X 0.095 while the market return is 5% what is the expected rate of return for Apple.? YEWE. We NFLX US $ C 332.83 +0.80 Q332.69 /332.70Q 4 0 x 10 TOn 20 Mar d Vol 10,853, 846 0 342.31K H 350.49 K L 332.00D Val 3.696B Dep NFLX US Equity Indep SPX Index 96 Actions 97) Edit Regression Analysis Data Last Price Data Last Price Wkly | Linear Beta +/- Non-Param Reg On Percent - 03/23/2018 - 03/22/2020 - 03/24/2017 - 03/24/2019 Lago Winsorize 2 Std Dev Local OM YTD 1Y 2Y 5Y Max Weekly v >> 7 Slalislics Transformalions Y = NETFLIX INC X - S&P 500 INDEX Linear Beta Range 1 Raw BETA 0.905 Adjusted BETA 0.937 ALPHA (Intercept) 0.299 R^2 (Correlation2) 0.224 R (Correlation) 0.474 Std Dev of Error 1.679 Std Error of ALPHA 0.159 Std Error of BETA 0.167 t-Test 5.430 Significance 0.000 Last T-Value 2.301 Last P-value 0.988 Number of Points 104 Last Spread 1972.09 Last Ratio 0.144 YELAS Dep AAPL US Equity Indep SPX Index 96) Actions 97) Edit Regression Analysis Data Last Price Data Last Price Wkly Linear Beta +/- Non-Param Reg On Percent - 03/23/2018 - 03/22/2020 - 03/24/2017 - 03/24/2019 Lago Winsorize 2 Std Dev Local 6M YTD 1Y 2Y 5Y Max Weekly >> 2 Statistics Transformations Y = APPLE INC X = S&P 500 INDEX Linear Beta Range 1 Raw BETA 1.091 Adjusted BETA 1.061 ALPHA (Intercept) 0.485 R^2 (Correlation^2) 0.518 R (Correlation) 0.720 Std Dev of Error 2.923 Std Error of ALPHA 0.287 Std Error of BETA 0.104 t-Test 10.474 Significance 0.000 Last T-Value -0.502 Last P-value 0.308 Number of Points 104 Last Spread 2075.68 Last Ratio 0.099