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

  Compute the variance and standard deviation

Compute the variance and standard deviation

  What is the probability of the given problem

Using the Census data, the OH Registry of Motor Vehicles reveal the subsequent about the Autos owned by the 10 families residing in Smallville.

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

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

  How many students took the exam

Basic Statistics problem

  Conduct an analysis of variance

Conduct an analysis of variance

  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.

  Conduct a marketing experiment

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

  Solve the equations using linear algebra

Solve the equations using linear algebra

  Compute the expected value of perfect information

Suppose the probability of the worst-case scenario increases Compute the expected value of perfect information

  Evaluate the mean wait time and throughput rate

Evaluate the mean wait time and throughput rate

  Estimate the population mean

Estimate the population mean

  Determine the standard deviation

What is the possibility that for a arbitrarily selected customer the service time could exceed 3 minutes?

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