The monthly returns for Visa (V) and Pfizer (PFE) for 2018–2020 are provided in the chart below. In addition, the monthly return for the SPDR S&P 500 ETF Trust (SPY) is provided; SPY is often used as a proxy for the returns of the S&P 500, or a broad market index. Using Excel, calculate the arithmetic average monthly returns for V, PFE, and SPY. Also, calculate the standard deviation of returns for each of V, PFE, and SPY. 

Transcribed Image Text:

Monthly Returns for SPY, V, and PFE for 2018-2020 Date SPY PFE Jan-18 0.0618 0.0895 0.0895 0.0226 Feb-18 -0.0364 -0.0104 -0.0197 Mar-18 -0.0313 -0.0253 -0.0135 Apr-18 0.0092 0.0607 0.0316 May-18 0.0243 0.0303 -0.0186 0.0013 0.0149 0.0196 Jun-18 Jul-18 0.0417 0.0324 0.1006 Table 15.8