Preview

Statistics Project

Satisfactory Essays
Open Document
Open Document
5908 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Statistics Project
Statistics Project | September 26
2011
| The project statistically studies and compares the daily closing price movement of two investment options – real estate and gold represented by DLF stock and SBI Gold ETF respectively – over the past 3 years. | Comparative study of DLF Stock and Gold ETF price movement |

Contents Stage 1 3 Overview 3 Problem Statement 3 Inferences 5 Stage 2 6 Hypothesis Testing 6 Stage 3 7 Linear Regression Analysis 7 Manual Calculations 7 Regression Analysis: DLF Closing versus Gold Closing using Minitab 7 Appendix A 10 Appendix B 23 Appendix C 38 Appendix D 53

Stage 1
Overview
In this stage, the daily closing values of DLF stock price and SBI Gold ETF are analyzed. These two
…show more content…

One measure of return is the % appreciation in value of the investment over a period of time. In case of our subjects, the % appreciation/depreciation of daily closing prices is an effective measure of return.
The frequency distribution plot of the % change of closing price is a visual representation of the volatility – which is an important measure of
…show more content…

A box plot of the % change in daily closing prices is another visual representation of the risk (volatility). The graph below is the box plot of the % change in daily closing price of both DLF stock and Gold ETF

Inferences 1. From the frequency plot, it’s clear that the % change in daily closing price of DLF stock is more dispersed while that of Gold ETF is concentrated around the centre. This means that the volatility (risk) is more in case of DLF stock (real estate investment). 2. From the descriptive statistics table, DLF has a negative (-0.08) mean for %change of daily closing price, which means that, on an average the stock depreciated over the 3 year period per day. While the same measure of Gold ETF is positive (0.12) – which means the ETF appreciated by 0.12% per day on an average over the 3 year period. 3. From the descriptive statistics table, the standard deviation of DLF stock closing price change is almost 3 times that of the Gold ETF, which means it’s a riskier


You May Also Find These Documents Helpful

  • Good Essays

    Statistics Project

    • 599 Words
    • 3 Pages

    Purpose: Analyze and compare sugar content of popular cereals with the same serving size. Cereal is a staple in my home, but chosen for different reasons. Cereals that are popular with kids are starting to advertise more fiber and grains, which capture a parent’s eye. Is eating a blander colored cereal really more healthy than a vibrant colored one?…

    • 599 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    16 Day Coursebook BOWS

    • 27912 Words
    • 91 Pages

    Recognizing Overbought/Oversold Areas in the Market The Causes of Market Gaps and How to Trade Them Chapter 10 - Market Breadth Advances vs. declines Reading Indices 4% breakouts vs. 4% breakdowns New highs vs. New lows Breadth Thrust Chapter 11 - ETF Trading and Sector Analysis Advantages of Trading ETFs Our Favorite ETFs to trade…

    • 27912 Words
    • 91 Pages
    Powerful Essays
  • Good Essays

    Statistics Project

    • 1019 Words
    • 5 Pages

    There is a fairly strong positive correlation, as can be seen from the scatterplot. The correlation coefficient, or R, should be examined to confirm what the eye test tells us.…

    • 1019 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    covering over 3,000 securities in more than 51 countries. We will be looking at their three main…

    • 1506 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    The stock indices that were studied showed a Hurst exponent close to .5, this showing random behavior of market return. The R/S ratio in the 30 day- period window was to vary dynamically overtime. Whenever the R/S values were high, the average returns were also high.…

    • 337 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Alex Sharpe

    • 601 Words
    • 4 Pages

    By comparing both the stocks, the riskiest stock in this case is Reynolds. It has the highest return as well as higher standard deviation and the higher variance. If we compare both stocks, Reynolds is riskier than Hasbro in this case. The higher variance indicates higher chance that the actual return on Reynolds will deviate from the expected return.…

    • 601 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Thompson Asset Management

    • 2102 Words
    • 14 Pages

    returns that an investor can use in order to manage its portfolio. Some focus of the…

    • 2102 Words
    • 14 Pages
    Powerful Essays
  • Good Essays

    Silver Etfs

    • 2250 Words
    • 9 Pages

    Before we focus on specific sliver ETF, we should first analyze price of silver and the silver’s market in the past, because there was a very strong relationship between the silver price and the ETF of sliver investment.…

    • 2250 Words
    • 9 Pages
    Good Essays
  • Good Essays

    Why ETF are dangerous

    • 501 Words
    • 3 Pages

    To make sure that ETFs were the culprit in this underperformance, rather than some other factor, the researchers next compared the returns of each investor's portfolio before and after the purchase of the first ETF. They found that, on average, these investors' performance was lower after than before. And, to pound the nail in ETFs' coffin,…

    • 501 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    5% significance. The result suggests that the price of the fund and exchange rates do not…

    • 14195 Words
    • 57 Pages
    Powerful Essays
  • Good Essays

    In the days of technology advancement and increasing use of computers for trading and investing, Algorithm trading has become the present trend in the markets. There is much software present in the markets that will enable the trader to buy, sell and implement the strategies that he has designed to be profitable. The prime goal of a trader in a Future and Options segment is to be profitable and sue to the increasing efficiency of the markets he has to be quick to identify opportunities and utilize them. One can do it using technical analysis and fundamental analysis. If the trader is short and medium term or an arbitrageur then his own skills are not enough to identify and trade on various derivatives in various markets. This is where algorithmic trading comes into picture, but while using algorithm trading the system must be able to identify its entry points and exit points. This is done using technical analysis. When the entry and exit is done through technical conditions it is very important to understand which technical indicators work the best in the markets and how efficient are they in making the profits. This study is done to understand what extent the technical analysis is working in the markets and what type of indicators should be used for ranging markets and trending markets. The technical indicators such as Relative Strength Index, Moving Average Convergence Divergence, Slow Stochastic, Fast Stochastic, Average Directional Index, Bollinger Bands and Average True Range are tested on the market for a period of 5 years time from 2008 to 2013 on CNX NIFTY. Their efficiency, profits losses and profit factor were understood in this report by using tradestation software. In short we are buying and selling NIFTY itself.…

    • 5878 Words
    • 24 Pages
    Good Essays
  • Satisfactory Essays

    Gold Etfs in India

    • 591 Words
    • 3 Pages

    The aim is to study Gold ETF as an investment option with a focus on Indian market using the skills, knowledge and tools learnt during KSOU UBS Executive MBA curriculum.…

    • 591 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The_Role_of_Volatility

    • 1397 Words
    • 23 Pages

    The Key Role of the Volatility for Financial Engineering Dr. Zbigniew Krysiak zbigniew.krysiak@poczta.onet.pl Associate Professor of Finance - Warsaw School of Economics Visiting Professor at Northeastern Illinois University, Chicago Financial Mathematics Mathematics Department at Northeastern Illinois University, Chicago Wednesday, October 3rd, 2012 1 Agenda • Approaches to Modeling Volatilities • Volatility Models in Capital Allocation - VaR • Application of GARCH to Modeling Volatility • Volatility Impacts Option Value • Portfolio Hedging Against Volatility Change 2 Standard Approach to Estimating Volatility • Define sn as the volatility per day between day n-1 and day n, as estimated at end of day n-1 • Define Si as the value of market variable at end of day i 1 m • Define ui= ln(Si/Si-1)…

    • 1397 Words
    • 23 Pages
    Good Essays
  • Powerful Essays

    Godl Etf Project

    • 1070 Words
    • 5 Pages

    Three gold ETFs, Birla Sunlife Gold ETF (BSLGOLDETF), Canara Bank Robeco Gold ETF (CRMFGETF) and Motilal Oswal Most Share Gold ETF (MGOLD) was not traded fully during 2011-2012 period and hence not comparable with the other major ETFs. Birla Sunlife Gold ETF has provided a return of 25.87% since 23 May 2011 till date, CRMFGETF 7.23% since 27 March 2012 till date and MGold 2.92% since March 27 2012.…

    • 1070 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Pv2003 Model Essay

    • 968 Words
    • 4 Pages

    According to the numerical analysis presented in PV2003, the volatility is al- most constant when there is no uncertainty about mean profitability, while de- creases in presence of learning. However, close to maturity, the volatility declines to 0, due to the assumptions made. Moreover, the authors show that, in case of no learning, the volatility of dividend payers is slightly lower than the volatility of non-payers because dividends are riskless; however, the effect of dividends on volatility is negligible…

    • 968 Words
    • 4 Pages
    Satisfactory Essays