Problem 12-16 Algo (The Random Walk Model) Question Check My Spreadsheet eBook The file P12_16.xlsx contains the daily closing prices of American Express stock for an eight-week period. a. Use the random walk model to forecast the closing price of this stock on the next trading day. Round your answer to the nearest cent, if necessary. b. You can be about 95% certain that the forecast made in part a will be off by no more than how many dollars? Round your answers to the nearest cent, if necessar Forecast Lower limit Upper limit S Hide Feedback Incorrect Check My Work Feedback Click here for a video walkthrough of a similar problem. PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. A1 fx Date A B C D E F G H J K M 3 100.70 99.78 100.14 100.84 100.35 100.59 O au 16 3 5-Jan-18 4 8-Jan-18 5 9-Jan-18 6 10-Jan-18 7 11-Jan-18 8 12-Jan-18 9 16-Jan-18 10 17-Jan-18 11 18-Jan-18 12 19-Jan-18 13 22-Jan-18 14 23-Jan-18 15 24-Jan-18 25-Jan-18 17 26-Jan-18 18 29-Jan-18 19 30-Jan-18 20 31-Jan-18 21 1-Feb-18 22 2-Feb-18 23 5-Feb-18 24 6-Feb-18 25 7-Feb-18 26 8-Feb-18 27 9-Feb-18 28 12-Feb-18 29 13-Feb-18 30 14-Feb-18 31 15-Feb-18 32 16-Feb-18 33 20-Feb-18 34 21-Feb-18 35 22-Feb-18 36 23-Feb-18 37 26-Feb-18 38 27-Feb-18 39 28-Feb-18 40 1-Mar-18 41 2-Mar-18 99.97 100.38 99.49 97.66 97.95 97.61 98.93 99.32 99.26 99.04 98.34 99.03 99.63 96.32 91.67 93.83 93.26 88.01 91.38 94.35 94.21 95.87 96.20 96.43 96.83 97.14 96.99 98.43 101.26 99.21 97.15 94.78 95.24 Problem 12-16 Algo (The Random Walk Model) Question Check My Spreadsheet eBook The file P12_16.xlsx contains the daily closing prices of American Express stock for an eight-week period. a. Use the random walk model to forecast the closing price of this stock on the next trading day. Round your answer to the nearest cent, if necessary. b. You can be about 95% certain that the forecast made in part a will be off by no more than how many dollars? Round your answers to the nearest cent, if necessar Forecast Lower limit Upper limit S Hide Feedback Incorrect Check My Work Feedback Click here for a video walkthrough of a similar problem. PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. A1 fx Date A B C D E F G H J K M 3 100.70 99.78 100.14 100.84 100.35 100.59 O au 16 3 5-Jan-18 4 8-Jan-18 5 9-Jan-18 6 10-Jan-18 7 11-Jan-18 8 12-Jan-18 9 16-Jan-18 10 17-Jan-18 11 18-Jan-18 12 19-Jan-18 13 22-Jan-18 14 23-Jan-18 15 24-Jan-18 25-Jan-18 17 26-Jan-18 18 29-Jan-18 19 30-Jan-18 20 31-Jan-18 21 1-Feb-18 22 2-Feb-18 23 5-Feb-18 24 6-Feb-18 25 7-Feb-18 26 8-Feb-18 27 9-Feb-18 28 12-Feb-18 29 13-Feb-18 30 14-Feb-18 31 15-Feb-18 32 16-Feb-18 33 20-Feb-18 34 21-Feb-18 35 22-Feb-18 36 23-Feb-18 37 26-Feb-18 38 27-Feb-18 39 28-Feb-18 40 1-Mar-18 41 2-Mar-18 99.97 100.38 99.49 97.66 97.95 97.61 98.93 99.32 99.26 99.04 98.34 99.03 99.63 96.32 91.67 93.83 93.26 88.01 91.38 94.35 94.21 95.87 96.20 96.43 96.83 97.14 96.99 98.43 101.26 99.21 97.15 94.78 95.24