Given the assigned stock (AMGN) to you, please upload the Excel file (Yourlastname_Ticker.xls) that shows the process of finding the beta for the stock. The file should contain only ONE sheet or tab. On Yahoo!Finance, select "Duration" and "Frequency": Most recent 5-year monthly prices. Then click "Apply" before "Download" into a .csv file. Copy data to Excel to do the Regression analysis (under "Data", then "Data Analysis").

F 1 J K L M N O P Q R S T U G H Regression Output 2 Date SUMMARY OUTPUT 14325 Regression Statistics Mutiple R Square Adjusted R Square R Standard Error Observations 135.00 ANOVA 180 df SS MS F F Significance F Regression Residual Total 194.16 Standard Error t Stat P-vale Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Intercept Retum SP500 .. A B D D E Price(AMG Price(SP500 Retum (AMC Retum(SP500) () 3 2016-11-01 124.918991 4 2016-12-01 127.630875 5 2017-01-01 136.770416 2017-02-01 154.098007 7 2017-03-01 2 144.209167 8 2017-04-01 143.549973 9 2017-05-01 136.448059 10 2017-06-01 169 ree 152.47583 11 2017-07-01 154.494247 12 2017-08-01 157.380356 af.000 13 2017-09-01 166.177994 100 Teen 14 2017-10-01 156. 169022 15 2017-11-01 166. sed 156.561188 18 2017-12-01 156.052048 130.032046 . 17 2018-01-01 2010-01-01 166.955078 O.S.BUT 18 2018-02-01 164.909042 104.903022 19 2018-03-01 154.139465 20 2018-04-01 Bt.Foco 157.756088 21 2018-05-01 162.403412 10 wita 180105106 22 2018-06-01 168.185196 100.000 23 2018-07-01 179.082306 24 2018-08-01 182.032014 182 052812 25 2018-09-01 190.15332 190 15823 28 2018-10-01 176.85202 27 2018-11-01 191.033981 28 2018-12-01 179.823547 29 2019-01-01 172.840103 30 2019-02-01 175.583588 31 2019-03-01 176.84816 3 2019-04-01 166.925018 w 39 2019-06-01 155. 177338 34 2019-06-01 173.019012 35 2019-07-01 175. 178467 38 2019-08-01 195.871658 37 2019-09-01 182.972137 39 2019-10-01 201.637192 39 2019-11-01 221.938004 an 2019-12-01 229. 456833 41 2020-01-01 206.64212 42 2020-02-01 190.108292 43 2020-03-01 194.333542 * 44 2020-04-01 229.312225 45 2020-05-01 220.186539 46 2020-06-01 227.62175 ** 47 2020-07-01 236. 124039 48 2020-08-01 244.471909 *** 49 2020-09-01 246.925583 50 2020-10-01 210.765015 51 2020-11-01 215.719849 . 52 2020-12-01 224.892914 53 2021-01-01 236.151245 54 2021-02-01 220.002228 55 2021-03-01 245. 179474 56 2021-04-01 236.14328 2. ZO 57 2021-05-01 234.468094 care 58 2021-06-01 241.00210 241.882187 59 2021-07-01 239.689117 60 2021-08-01 223.801804 61 2021-09-01 212 649994 6 2021-10-01 206.699997 AMGN + F 1 J K L M N O P Q R S T U G H Regression Output 2 Date SUMMARY OUTPUT 14325 Regression Statistics Mutiple R Square Adjusted R Square R Standard Error Observations 135.00 ANOVA 180 df SS MS F F Significance F Regression Residual Total 194.16 Standard Error t Stat P-vale Lower 95% Upper 95% Lower 95.0% Upper 95.0% Coefficients Intercept Retum SP500 .. A B D D E Price(AMG Price(SP500 Retum (AMC Retum(SP500) () 3 2016-11-01 124.918991 4 2016-12-01 127.630875 5 2017-01-01 136.770416 2017-02-01 154.098007 7 2017-03-01 2 144.209167 8 2017-04-01 143.549973 9 2017-05-01 136.448059 10 2017-06-01 169 ree 152.47583 11 2017-07-01 154.494247 12 2017-08-01 157.380356 af.000 13 2017-09-01 166.177994 100 Teen 14 2017-10-01 156. 169022 15 2017-11-01 166. sed 156.561188 18 2017-12-01 156.052048 130.032046 . 17 2018-01-01 2010-01-01 166.955078 O.S.BUT 18 2018-02-01 164.909042 104.903022 19 2018-03-01 154.139465 20 2018-04-01 Bt.Foco 157.756088 21 2018-05-01 162.403412 10 wita 180105106 22 2018-06-01 168.185196 100.000 23 2018-07-01 179.082306 24 2018-08-01 182.032014 182 052812 25 2018-09-01 190.15332 190 15823 28 2018-10-01 176.85202 27 2018-11-01 191.033981 28 2018-12-01 179.823547 29 2019-01-01 172.840103 30 2019-02-01 175.583588 31 2019-03-01 176.84816 3 2019-04-01 166.925018 w 39 2019-06-01 155. 177338 34 2019-06-01 173.019012 35 2019-07-01 175. 178467 38 2019-08-01 195.871658 37 2019-09-01 182.972137 39 2019-10-01 201.637192 39 2019-11-01 221.938004 an 2019-12-01 229. 456833 41 2020-01-01 206.64212 42 2020-02-01 190.108292 43 2020-03-01 194.333542 * 44 2020-04-01 229.312225 45 2020-05-01 220.186539 46 2020-06-01 227.62175 ** 47 2020-07-01 236. 124039 48 2020-08-01 244.471909 *** 49 2020-09-01 246.925583 50 2020-10-01 210.765015 51 2020-11-01 215.719849 . 52 2020-12-01 224.892914 53 2021-01-01 236.151245 54 2021-02-01 220.002228 55 2021-03-01 245. 179474 56 2021-04-01 236.14328 2. ZO 57 2021-05-01 234.468094 care 58 2021-06-01 241.00210 241.882187 59 2021-07-01 239.689117 60 2021-08-01 223.801804 61 2021-09-01 212 649994 6 2021-10-01 206.699997 AMGN +