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

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Write introduction to statistical process control

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

  How many students took the exam

Basic Statistics problem

  Compute the expected value of perfect information

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

  Explain the trend in the export of fish

Draw two pie charts, which allow the total yearly exports to be compared. Explain the trend in the export of fish as shown in the two pie charts.

  Evaluate the mean wait time and throughput rate

Evaluate the mean wait time and throughput rate

  Solve the equations using linear algebra

Solve the equations using linear algebra

  Foundation statistics

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

  Prepare a power curve for this decision rule

Prepare a power curve for this decision rule

  Questions based on binomial distribution

Questions based on binomial distribution, variance of the binomial distribution, discrete random variable and continuous random variables.

  Conduct an analysis of variance

Conduct an analysis of variance

  State the values of the coefficient of correlation

State the values of the coefficient of correlation and coefficient of determination correct to three decimal places

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