Please access the data in this link: SPY data Download SPY data. Complete the following tasks. Please submit your Excel file containing answers for both Question 1 and Question 2 under Question 2.\ \ Q2-1: Graph Closing Price Over Time:\ \ Graph the closing prices over the time period. Describe your observations regarding the trends, fluctuations, or any significant patterns you notice in the graph. Provide at least three descriptive sentences.\ \ Q2-2: Graph Volume Over Time:\ \ Graph the volume of SPY over the same time period. Comment on any apparent trends, spikes, or changes in trading volume observed in the graph. Include at least three descriptive sentences detailing your observations.\ \ Q2-3: Moving Average Models:\ \ Apply the Moving Average (MA) method with one month (MA (1)), two months (MA (2)), and three months (MA (3)). Identify which Moving Average model appears to be the most accurate among MA (1), MA (2), and MA (3) for the given dataset.\ \ Q2-4: Exponential Smoothing Method:\ \ Apply the Exponential Smoothing (ES) method using an alpha smoothing constant of 0.6. Determine the optimal alpha smoothing constant that minimizes the sum of squared errors for the predictions made using the Exponential Smoothing method.\ \ Q2-5: Comparison Between Models:\ \ Compare the most accurate Moving Average model identified earlier with the optimal Exponential Smoothing model. Plot the closing price, MA (3), and ES (0.6) on the same graph, with the y-axis representing the closing price and the x-axis indicating the date. Provide insights based on the comparison and describe any notable differences or similarities observed in the graph. Write at least three sentences discussing your observations. Date Close Volume\ 12/12/22 398.950012 75405800\ 12/13/22 401.970001 123782500\ 12/14/22 399.399994 108111300\ 12/15/22 389.630005 117705900\ 12/16/22 383.269989 119858000\ 12/19/22 380.019989 79878100\ 12/20/22 380.540009 74427200\ 12/21/22 386.230011 78167400\ 12/22/22 380.720001 100120900\ 12/23/22 382.910004 59857300\ 12/27/22 381.399994 51638200\ 12/28/22 376.660004 70911500\ 12/29/22 383.440002 66970900\ 12/30/22 382.429993 84022200\ 1/3/23 380.820007 74850700\ 1/4/23 383.76001 85934100\ 1/5/23 379.380005 76970500\ 1/6/23 388.079987 104189600\ 1/9/23 387.859985 73978100\ 1/10/23 390.579987 65358100\ 1/11/23 395.519989 68881100\ 1/12/23 396.959991 90157700\ 1/13/23 398.5 63903900\ 1/17/23 397.769989 62677300\ 1/18/23 391.48999 99632300\ 1/19/23 388.640015 86958900\ 1/20/23 395.880005 91806400\ 1/23/23 400.630005 84178800\ 1/24/23 400.200012 59524900\ 1/25/23 400.350006 84800300\ 1/26/23 404.75 72287400\ 1/27/23 405.679993 68346200\ 1/30/23 400.589996 74202000\ 1/31/23 406.480011 86811800\ 2/1/23 410.799988 101459200\ 2/2/23 416.779999 101654500\ 2/3/23 412.350006 94736800\ 2/6/23 409.829987 60295300\ 2/7/23 415.190002 90990700\ 2/8/23 410.649994 76227500\ 2/9/23 407.089996 78694900\ 2/10/23 408.040009 70769700\ 2/13/23 412.829987 64913500\ 2/14/23 412.640015 88389300\ 2/15/23 413.980011 61555700\ 2/16/23 408.279999 76431500\ 2/17/23 407.26001 89257800\ 2/21/23 399.089996 82655900\ 2/22/23 398.540009 83742300\ 2/23/23 400.660004 96242400\ 2/24/23 396.380005 108194400\ 2/27/23 397.730011 80444700\ 2/28/23 396.26001 96438600\ 3/1/23 394.73999 99706800\ 3/2/23 397.809998 85127800\ 3/3/23 404.190002 90120000\ 3/6/23 404.470001 72795900\ 3/7/23 398.269989 108310600\ 3/8/23 398.920013 74746600\ 3/9/23 391.559998 111945300\ 3/10/23 385.910004 189253000\ 3/13/23 385.359985 157790000\ 3/14/23 391.730011 149752400\ 3/15/23 389.279999 172996900\ 3/16/23 396.109985 143254200\ 3/17/23 389.98999 140553400\ 3/20/23 393.73999 93055800\ 3/21/23 398.910004 91524200\ 3/22/23 392.109985 111746600\ 3/23/23 393.170013 119351300\ 3/24/23 395.75 107682400\ 3/27/23 396.48999 74010400\ 3/28/23 395.600006 62871700\ 3/29/23 401.350006 77497900\ 3/30/23 403.700012 69840000\ 3/31/23 409.390015 112062600\ 4/3/23 410.950012 67391100\ 4/4/23 408.670013 66601500\ 4/5/23 407.600006 65200200\ 4/6/23 409.190002 63743300\ 4/10/23 409.609985 63681000\ 4/11/23 409.720001 59297900\ 4/12/23 408.049988 86420400\ 4/13/23 413.470001 85814800\ 4/14/23 412.459991 78161500\ 4/17/23 413.940002 66436400\ 4/18/23 414.209991 63560000\ 4/19/23 414.140015 55227300\ 4/20/23 411.880005 75840400\ 4/21/23 412.200012 73457400\ 4/24/23 412.630005 64332100\ 4/25/23 406.079987 97766700\ 4/26/23 404.359985 80447000\ 4/27/23 412.410004 92968400\ 4/28/23 415.929993 89335600\ 5/1/23 415.51001 62122300\ 5/2/23 410.839996 103998500\ 5/3/23 408.019989 91531800\ 5/4/23 405.130005 94901900\ 5/5/23 412.630005 87844000\ 5/8/23 412.73999 50046800\ 5/9/23 410.929993 49220100\ 5/10/23 412.850006 96142900\ 5/11/23 412.130005 70157100\ 5/12/23 411.589996 70439400\ 5/15/23 413.01001 54289400\ 5/16/23 410.25 57705500\ 5/17/23 415.230011 87287000\ 5/18/23 419.230011 97177200\ 5/19/23 418.619995 103679700\ 5/22/23 418.790009 60745400\ 5/23/23 414.089996 86383500\ 5/24/23 411.089996 89213700\ 5/25/23 414.64999