Preview

5257 statistics assignment

Satisfactory Essays
Open Document
Open Document
838 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
5257 statistics assignment
1.stocks.xls data set
For stock 1, the median was 0.0607, mean was 0.0286, the loss of investment can be as large as -0.5268, and the gain of the investment can be as large as 0.6015. However, the risk of loss was round 7%, while the chance to gain between 0 – 0.8 was very high, nearly 78%.
For stock 2, the median was 0.0511, mean was 0.096413, the loss of investment can be as large as -0.9963, and the gain of the investment can be as large as 1.519. The risk to loss for stock 2 was about 12%, the chance to gain between 0-0.8 was nearly 64%, and the chance to gain between 0.8 and 1.2 was relative big, round 17%.
For stock 3, the median was 0.0108, mean was 0.028598, the loss of investment can be as large as -0.577, and the gain of the investment can be as large as 0.4816. The risk to be loss was only 2%, and the chance to gain between 0-0.8 was almost 96%.
For these 3 kinds of stocks, stock 3 had the lowest risk to loss, and stock 2 can be loss large and gain large. The stock 1 and 3 had narrow range for the return of investment while the opportunities of it for stock 2 is a litter flatter than the two above.
Justify with descriptive statistics and the histogram tools:
Firstly use descriptive statistics to summarise the key features of stock1, stock2, and stock3 respectively.
All the available output options were chosen and labels in the first row were chose as in the Appendix figure 4.1 descriptive statistics.
The output are as follows:

Figure 1.1 descriptive Statistics for Stock 1, 2, and 3
Stock 1

Stock 2

Stock 3

Mean
0.028631

Mean
0.096413

Mean
0.028598
Standard Error
0.030729

Standard Error
0.049218

Standard Error
0.022666
Median
0.0607

Median
0.0511

Median
0.0108
Mode
-0.5085

Mode
-0.8652

Mode
-0.3641
Standard Deviation
0.305747

Standard Deviation
0.489717

Standard Deviation
0.22552
Sample Variance
0.093481

Sample Variance
0.239822

Sample Variance
0.050859

You May Also Find These Documents Helpful

  • Better Essays

    The rate of return and risk in return represent the dimensions of expectation and uncertainty. The tradeoffs between them are real and faced by individuals and businesses frequently. The decision to invest involves a choice among alternatives having both varying anticipated return and risk. Being averse to risk, individuals and businesses choose the least risky investment for a given level of anticipated return, or require a greater return when investments are riskier. The investor perspective with respect to risk tends to be one of concern with the degree to which returns might depart (or vary) from the expected level.…

    • 1529 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Finc5001

    • 855 Words
    • 4 Pages

    This assignment requires you to examine different approaches for determining the expected risk and return of a two stock portfolio. Each group will need to choose two companies listed on the Australian Securities Exchange (ASX) from an Excel spreadsheet (provided on Blackboard). Using data that the group collects, which must include data from March 2013, you will be required to examine the risk and return profiles of various portfolio combinations of these two stocks. Failure to use recent data that includes March 2013 will result in a mark of zero. The group will then be required to make a decision about which portfolio to invest in, and justify that decision with reference to appropriate academic literature.…

    • 855 Words
    • 4 Pages
    Good Essays
  • Best Essays

    Finc5001 group assignment

    • 5601 Words
    • 146 Pages

    Telstra Limited (TLS) is Australia's leading telecommunications and information services company, with one of the best known brands in the country. It offers a full range of services and competes in all telecommunications markets throughout Australia. (Telstra Financial Report, 2009) Ansell Limited (ANN) is a global leader in barrier protective solutions. It designs, develops and manufactures a wide range of hand and arm protection solutions, clothing and condoms (Ansell Financial Report, 2009). This report uses mean-variance method and CAPM approach, to form the portfolio combined two stocks TLS and ANN. By justifying five years (2005-2010) monthly data in using mean variance method to calculate the expected return (ANN 0.007488, TLS -0.004441), standard deviation (ANN 0.076531, TLS 0.053729), as well as beta (ANN 0.64, TLS 0.31). And then one year (2009) daily data to determine portfolio expected return in using CAPM method. With MV method, based on the justification and limitation, this report have not choose a optimize portfolio but only choose the portfolio number 29 with the smallest risk. However, under CAPM model, in evaluating the combination of its expected return and the beta, the report recommended portfolio number 29 based on 4 reasons. Firstly, the daily expected return calculated by CAPM model is much higher than daily risk free rate. Secondly, TLS is undervalued due to the SML. Thirdly, because the market is in dramatic change recently and low beta means low relation with market, so the number 29 is the most proper portfolio.…

    • 5601 Words
    • 146 Pages
    Best Essays
  • Good Essays

    F10 Final Exam

    • 5255 Words
    • 22 Pages

    The standard deviation of a portfolio of 2 stocks is A) The portfolio weighted average of the standard deviations of the individual stocks within the portfolio. B) Portfolio weighted average of the standard deviations of the individual stocks within the portfolio only if the 2 stocks are perfectly correlated. C) The portfolio weighted average of the standard deviations of the individual stocks within the portfolio if the 2 stocks are perfectly uncorrelated. D) The portfolio weighted average of the standard deviations of the individual stocks within the portfolio if the 2 stocks have a perfect negative correlation. E) None of the above. Solution B If rho is zero the whole third term under the square root disappears and what is left is not a perfect square. If rho is one, then what is left under the square root is a perfect square in the form of (a+b)2 = a2 + b2 + 2ab 46. Which of the following statements is (are) true concerning risk and return? I. To accept higher levels of risk, investors must be paid a higher risk premium. II. Smaller company stocks generally offer a higher return and less risk than larger company stocks. III. The risk free rate of return is based on the long term government bond rate. IV. The higher the standard deviation of a security, the less predictable the rate of return in any one year. A) I only B) II only C) III and IV only D) I and II only E) I and IV only Solution E 47. Which of the following are examples of systematic risk? I. An increase in the growth rate of Gross Domestic Product II. A decrease in the productivity of a company's workers III. A decrease in the rate of inflation. IV. A decrease in a firm's cost of borrowing A) B) C) D) E) I and II only I and III only II and IV only II and III only I, III, and IV…

    • 5255 Words
    • 22 Pages
    Good Essays
  • Good Essays

    1. According to the case, it shows that management of M determined that a loss would be “probable” and the estimate range would be $15 million to $20 million. However, they determined $17 million would be the “most likely” amount of loss.…

    • 836 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Compute profits and losses per share, and graph them against stock prices for the strategy of buying a share of Lotus’s common stock at $55 per share and holding it until February 19, 1994.…

    • 524 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Beta Management Company

    • 343 Words
    • 2 Pages

    How might the expected returns for each stock relate to their respective levels of riskiness?…

    • 343 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    There are a range of calculations that exist to measure the likeliness of risk associated with any potential investment. Some of the computations include formulas such as, the risk premium, beta, and standard deviation. The risk premium calculates the added return anticipated for taking on extra risk (Petty, 2012, p. 279). The formula beta, also known as financial elasticity, uses regression and measures the volatility of the relationship between an investment and the rest of the market (Petty, 2012, p. 297). Additionally, the standard deviation (the spread of the values from the average) calculates an investment 's volatility by being applied to the annual rate of return, the higher the outcome the more unstable the investment is considered to be. All of these calculations, and others, are used with the aim of measuring the riskiness of potential…

    • 527 Words
    • 2 Pages
    Good Essays
  • Good Essays

    4.7 By investing in a particular stock, a person can make a profit in one year of $4000 with probability 0.3 or take a loss of $1000 with probability 0.7. What is this person’s expected gain?…

    • 868 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Answer: Since Peter Metarko is extremely optimistic he should choose the common stock, alternative this investment ( $ 30,000) would increase by a factor of 8 which is a maximum value. Thus, Peter is to select the CS alternative which is an optimistic decision approach.…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Occidental Petroleum Corporation (OXY) engages in the exploration and production of oil and gas properties in the United States and internationally. The company operates in three segments: Oil and Gas; Chemical; and Midstream, Marketing, and Other. The Oil and Gas segment explores for, develops, produces, and markets oil and condensate, natural gas liquids (NGLs), and natural gas. Its domestic oil and gas operations are located in California, Colorado, Kansas, Montana, New Mexico, North Dakota, Oklahoma, Texas, Utah, and West Virginia; and international oil and gas operations are located in Bahrain, Bolivia, Colombia, Iraq, Libya, Oman, Qatar, the United Arab Emirates, and Yemen.…

    • 2503 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    Beta Management Company

    • 380 Words
    • 2 Pages

    The Grown Group stock should have a higher expected return because it is riskier. It is matched with the result in question 1. However, in the market, the riskiness of the…

    • 380 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Short and Margin

    • 499 Words
    • 2 Pages

    2. You purchase 100 shares at $60 per share and margin = 50%. Suppose stock rises to $80/sh (increase of 33%). What is your return? Suppose stock drops to $40/sh (decrease of 33%). What is your return?…

    • 499 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Growth and value are styles of investing in stocks (Emerald, 2013). Analysts commonly classify companies with low market-to-book ratios as value stocks, and firms with high market-to-book ratios as growth stocks (Berk & DeMarzo, 2011). Neither approach is certain to give appreciation in stock market value; both carry the possibility of risk. The return and primary worth of stocks vary with changes in the stock market conditions. Shares, when sold, may possibly be value more or less than the original rate. In addition, investments looking to attain higher rates of return also entail an increased level of risk (Emerald, 2013).…

    • 729 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    analysis

    • 356 Words
    • 2 Pages

    The EV/EBITDA ratio is a relevant ratio for financial analysis. Karambunai Corp Bhd shows a EV/EBITDA ratio of [#EVEBITDA_COMP#] for the next 12 months.…

    • 356 Words
    • 2 Pages
    Powerful Essays