Calculate descriptive statistics for each stock

Assignment Help Basic Statistics
Reference no: EM134992

One measure of the risk or volatility of an individual stock is the standard deviation of the total return (capital appreciation plus dividends) over some periods of time. Though the standard deviation is simple to calculate, it doesn't take into account the extent to which the price of a given stock varies as a function of a standard market index, like the S&P 500.

As an outcome, most of the financial analysts prefer to use the other measure of risk referred to as beta. Betas for individual stocks are determined by simple linear regression. The dependent variable is the total return for the stock and the independent variable is the total return for the stock market. For this case problem we will utilize the S&P 500 index as the measure of the total return for the stock market, and an estimated regression equation will be developed by using monthly data. The beta for the stock is the slope of the estimated regression equation (b1). The data contained in the file named Beta provides the total return (capital appreciation plus dividends) over 36 months for eight broadly traded common stocks and the S&P 500.

The value of beta for stock market will always be 1; therefore, stocks which tend to increase and drop with the stock market will as well have a beta close to 1. Betas greater than 1 point out that the stock is more volatile than the market and betas less than 1 point out that the stock is less volatile than the market. For example, if a stock has a beta of 1.4, it is 40% more volatile than the market, and if a stock has a beta of .4, it is 60% less volatile than the market.

Managerial Report:

You have been assigned to examine the risk characteristics of these stocks. Prepare a report that includes however is not limited to the given items.

A) Calculate descriptive statistics for each stock and the S&P 500. Comment on your results. Which stocks are the most volatile?

B) Calculate the value of beta for each stock. Which of such stocks would you expect to perform best in an up market? Which would you expect to hold their value best in a down market?

C) Comment on how much of the return for the individual stocks is described by the market.

Reference no: EM134992

Questions Cloud

Law of hearsay : Outline and show the way in which the law of hearsay might affect the admissibility in court of computer-generated evidence and/or computer stored evidence.
Electronic discovery in civil actions : Explain and discuss the problems presented by electronic discovery in civil actions and how the law has responded.
What legal issues are shown by large scale data breaches : What legal issues are shown by large scale data breaches, and how should the law respond? Answers should crucially analyse the issues raised in each case.
Applying om techniques to your organization : Find out in your organization an aspect of the operational process which could benefit from use of one or more of the given techniques: business or predictive analytics, dashboards, decision support systems and supply chain management.
Calculate descriptive statistics for each stock : Calculate descriptive statistics for each stock and the S&P 500. Comment on your results. Which stocks are the most volatile? Calculate the value of beta for each stock.
Matlab code to solve for temperature and pressure variation : Write down the MATLAB code to solve for temperature and pressure variation throughout the expansion process and to evaluate work and heat produced in processes for variable values of n.
Financial statement analysis : Prepare income statements and vertical common-size balance sheets for both companies - Prepare ratio analyses
What would you do differently from ge : Suppose that you were the Chief Quality Officer in charge of developing an empowerment programme. What would you do differently from GE?
Examine the operations of each company : Examine the operations of each company.  How is the company doing in this present economic environment?  Is the world economy affecting the company?  How?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd