1.(Ch. 20 - Time Series Moving Averages)Below is a table containing the closing prices ($US) for the stock of Chipotle Mexican Grill (CMG) from May 22, 2019 to June 12, 2019. ( I attached the table file below!)

Complete the table by computing the 5 day and 10 day moving averages and entering them into the designated columns, beginning after the asterisks. Notice that with those moving averages you have created new times series variables, which are something like lag variables (though slightly different). (Hint: I recommend using Minitab for the calculations.) Note: Remember that we use the first 5 day MA to predict the sixth entry in the series, etc.

CMG Daily Closes ($US) 5 Day MA 10 Day MA 737.04 * 682.12 ** 688.56 700.07 * 698.97 683 K 685.97 661.66 688.18 684.48 718.18 729.87 751.52 749.24 763.74