Coca-Cola, Citigroup & Pfizer: Compute 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 the square root of 12 to convert to annual units. b