Standard Deviation, correlation coefficient
Please see attached documents. Use the attached spreadsheets for Coca-Cola, Citigroup, and Pfizer. a) Calculate the annual standard deviation of returns for each company, using the most recent three years of monthly returns. Use the Excel function STDEV. Multiply by…
