DateBAC

9/30/2019-27.09,10/7/2019-27.61,10/14/2019-28.98,10/21/2019-30.29,10/28/2019-30.36,11/4/2019-31.76,11/11/2019-31.44

11/18/2019-31.68,11/25/2019-31.82,12/2/2019-32.15,12/9/2019-33.07,12/16/2019-33.56,12/23/2019-33.94,

12/30/2019-33.51,1/6/2020-33.35,1/13/2020-33.32,1/20/2020-32.20,1/27/2020-31.52,2/3/2020-33.23

2/10/2020-33.46,2/17/2020-32.99,2/24/2020-27.36,3/2/2020-24.68,3/9/2020-23.34,3/16/2020-19.01

3/23/2020-20.87,3/30/2020-19.35,4/6/2020-24.02,4/13/2020-22.49,4/20/2020-21.43,4/27/2020-22.30

5/4/2020-22.77,5/11/2020-20.72,5/18/2020-21.89,5/25/2020-23.31,6/1/2020-27.16,6/8/2020-24.11

6/15/2020-24.57,6/22/2020-22.52,6/29/2020-22.66,7/6/2020-23.37,7/13/2020-22.59,7/20/2020-23.69

7/27/2020-24.21,8/3/2020-25.40,8/10/20--25.75,8/17/2020-24.30,8/24/2020-25.59,8/31/2020-25.82

9/7/2020-24.98,9/14/2020-24.70,9/21/2020-23.01,9/28/2020-23.72,10/5/2020-24.85,10/12/2020-23.75

10/19/2020-24.40,10/26/2020-23.22,11/2/2020-23.82,11/9/2020-26.45,11/16/2020-26.27,11/23/2020-28.40

11/30/2020-28.70,12/7/2020-28.17,12/14/2020-28.26,12/21/2020-29.54,12/28/2020-29.88,1/4/2021-32.07

1/11/2021-32.54,1/18/2021-31.10,1/25/2021-29.23,,2/1/2021-31.91

2/8/2021-32.90

2/15/2021-34.05

2/22/2021-34.22

3/1/2021-36.41

3/8/2021-37.59

3/15/2021-38.17

3/22/2021-38.32

3/29/2021-39.12

4/5/2021-39.62

4/12/2021-38.79

4/19/2021-38.82

4/26/2021-40.15

5/3/2021-41.79

5/10/2021-41.97

5/17/2021-42.01

5/24/2021-42.00

5/31/2021-42.87

6/7/2021-41.65

6/14/2021-38.58

6/21/2021-41.41

6/28/2021-40.94

7/5/2021-39.84

7/12/2021-37.73

7/19/2021-37.51

7/26/2021-38.16

8/2/2021-39.95

8/9/2021-41.42

8/16/2021-40.16

8/23/2021-42.27

8/30/2021-40.84

9/6/2021-40.27

9/13/2021-40.50

9/20/2021-42.14

9/27/2021-43.08

10/4/2021-44.34

10/11/2021-46.37

10/18/2021-47.57

10/25/2021-47.78

The attached file BAC.XLSX contains weekly adjusted closing price data for Bank of America between 9/30/2019 and 10/25/2021. This represents 109 weeks of data. Denote the stock price at time t as Yt . Answer the following questions based on the data. 1. Compute the 2-week, 3-week, 4-week, 5-week, and 6-week Simple Moving Averages (SMA). Compute the MAD (Mean Absolute Deviation) for each of these SMAs to find out which one is the best among them.