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

  Analysis of data sets assignment

Analysis of data sets assignment

  Solve the equations using linear algebra

Solve the equations using linear algebra

  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.

  Foundation statistics

Answer all of these questions using R Commander. Include all graphs, outputs from R Commander.

  Determine the standard deviation

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

  P-value to test hypotheses

P-value to test hypotheses,

  Compute descriptive statistics for each stock

Compute descriptive statistics for each stock and the S&P 500. Comment on your results. Which stocks are the most volatile? Compute the value of beta for each stock. Which of these stocks would you expect to perform best in an up market? Which..

  Write introduction to statistical process control

Write introduction to SPC (STATISTICAL PROCESS CONTROL)? Describe the use of SPC tools used at D2D?

  What is the probability

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

  Compute the variance and standard deviation

Compute the variance and standard deviation

  Prepare a power curve for this decision rule

Prepare a power curve for this decision rule

  Briefly address the data analysis process

Describe and analyze your quantitative data and Briefly address the data analysis process.

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