Purchase Solution

Calculating average and standard deviation of the returns

Not what you're looking for?

Ask Custom Question

Below is recent monthly stock return data for Exxon Mobil (XOM) and Microsoft (MSFT). Using a spreadsheet and its functions, compute the average, variance, standard deviation, and correlation between the returns for these stocks. What does the correlation between the returns imply for a portfolio containing both stocks?

MONTH XOM RETURN MSFT RETURN
November -4.6% 10.4%
October 0.1% 13.6%
September -1.9% -10.3%
August -3.3% -13.8%
July -4.4% - 9.3%
June -1.6% 5.5%
May 0.7% 2.1%
April 9.4% 23.9%
March -0.1% -7.3%
February -3.2% -3.4%

Purchase this Solution
Solution Summary

EXCEL Spreadsheets have built-in functions which are useful for computing statistics like averages, standard deviation, variance, and correlation. Solution to given problem demonstrate the working of formulas to calculate average, standard deviation, variance and correlation coefficient of the returns.

Solution Preview

Please see excel spreadsheet for better understanding of formulas.

Average Return
XOM=-0.89% ...

Solution provided by:
Lokesh Jain, MSc
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Operations Management

This quiz tests a student's knowledge about Operations Management

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • Treasury Bills Returns and Inflation

    175625 Calculating Returns: Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. Calculate the standard deviation of Treasury bill returns and inflation over this period.

  • Finance:Expected returns and portfolio calculations.

    Calculating Returns and Standard Deviations Based on the following information, calculate the expected return and standard deviation for the two stocks: Discuss an overview of the measures of returns on various financial assets, and the various measures

  • Average returns, the variances and the standard deviations

    105520 Average returns, the variances and the standard deviations Calculating returns and Variability: Using the following returns, calculate the average returns, the variances and the standard deviations for X and Y.

  • Returns and Variability

    What was the arithmetic average return on Mary Ann's stock over this five-year period? b. What was the variance of Mary Ann's returns over this period? and The standard deviation? c.

  • Total return

    a. what was the arithmetic average return on Mary Ann's stock over this five-years period? b-What was the variance of Mary Ann's returns over this period? The standard deviation?

  • Return on tresury Bills, Bond Valuation

    212636 Average Return, Standard Deviation of Return, Average Real Return for Treasury bills; Bond Valuation Calculating Returns Refer to the following table: Year T-bills Inflation 1973

  • risk premium on common stock in each year

    I have now taken -38.83% which has changed answer for b and c. Please see the excel file again and eliminate the rating 2. Please check the revised file. I have used excel file for calculating average and standard deviation.

  • Standard Deviation, correlation coefficient

    There are two methods to calculate the standard deviation of the portfolio Method 1: First calculate the monthly standard deviation of the portfolio for 36 months by calculating the weighted average (each weight equal to 1/3) of the monthly returns

  • Calculating mean, variance and standard deviation of returns

    557759 Calculating mean, variance and standard deviation of returns 1. Suppose a stock had an initial price of $86 per share, paid a dividend of $1.80 per share during the year, and had an ending share price of $94. 2.

  • Calculating the Coefficient of Variation and Standard Deviation

    38351 Calculating the Coefficient of Variation and Standard Deviation Please help with the following problems. Provide step by step calculations for each.

View More Related Solutions