1. Draw the time series (time is on the x-axis) of the price of your stock. What is its long-term trend? How does your stock fare during the pandemic? 2. Repeat the analysis for SPY price and SHY price in separate diagrams. 3. Draw the time series of your stock return, SPY return, and SHY return together. - Do your stock return and SPY return move together? Calculate and report the correlation coefficient (hint: you may use the CORREL function to find the correlation coefficient) to support your claim. - Do your stock return and SHY return move together? Calculate and report the correlation coefficient to support your claim. 1. Draw the time series (time is on the x-axis) of the price of your stock. What is its long-term trend? How does your stock fare during the pandemic? 2. Repeat the analysis for SPY price and SHY price in separate diagrams. 3. Draw the time series of your stock return, SPY return, and SHY return together. - Do your stock return and SPY return move together? Calculate and report the correlation coefficient (hint: you may use the CORREL function to find the correlation coefficient) to support your claim. - Do your stock return and SHY return move together? Calculate and report the correlation coefficient to support your claim