Assignment Of Log Returns For My Three Chosen Stocks

Submitted By ctbowers1
Words: 899
Pages: 4
Open Document
QM Summative Assignment:

(Q1):

Below are the 30 observations and the log returns for my three chosen stocks: G4S, GKN and GLAXOSMITHKINE. Below is the logarithmic returns formula:
• rLOG = (Final amount of investment / Initial amount of investment) * 100
G4S - PRICE INDEX GKN - PRICE INDEX GLAXOS- PRICE INDEX
871674(PI) Log Return 900754(PI) Log Return 900479(PI) Log Return
264.5 1208 64980.3
284.6 0.073243434 964 -0.225630084 58890.7 -0.098400964
278 -0.023463572 1011 0.047603924 56365.7 -0.043822366
208.9 -0.285765445 968.3 -0.043153262 66651.1 0.167610733
211 0.010002465 1100.2 0.127705304 73557.6 0.098597222
197.4 -0.066626006 1142.4 0.037639331 70178.6 -0.047025352
224.6 0.129088915 1044.5 -0.089593011 71552.4 0.019386627
204 -0.096201048 1058.7 0.013503438 71366.8 -0.002597273
232.8 0.132059722 1108.9 0.046326793 73557.6 0.030235998
230.3 -0.010796909 835.7 -0.282854115 76045.4 0.033261758
235.3 0.021478489 978.8 0.158057635 73669 -0.031748444
227 -0.035911278 951.6 -0.028182553 76379.6 0.036133558
257.1 0.124515097 876 -0.082778687 70178.6 -0.084672224
256.6 -0.001946662 1029.6 0.161559565 66651.1 -0.051571871
273.9 0.065244624 997.4 -0.031773763 70735.6 0.059477432
252.5 -0.081351828 895.2 -0.108104736 68359.1 -0.03417429
274.7 0.084268344 934.8 0.043285446 68581.9 0.003253959
296.1 0.075017642 923.7 -0.011945259 70995.5 0.034587843
271.5 -0.086735096 845 -0.089050716 74263.1 0.044997698
286.3 0.053078073 880.9 0.041607485 75265.6 0.013408998
262.4 -0.087170155 872.8 -0.009237678 67876.5 -0.103333314
192.5 -0.309773903 776.6 -0.116781017 71292.6 0.049102658
167.8 -0.13732336 751.8 -0.032455086 68693.4 -0.03713941
171.1 0.019475387 790.7 0.050448298 65351.5 -0.049872732
193.3 0.121995205 749.7 -0.053245503 63977.7 -0.021245808
200.7 0.03756787 771.6 0.028793155 62715.2 -0.019930743
217.2 0.079007332 831.8 0.075125746 64014.8 0.020510464
200.7 -0.079007332 976 0.159870559 61415.6 -0.041450432
204.8 0.020222637 908.1 -0.072108082 61638.4 0.003621178
214.3 0.045343009 945.6 0.040465142 52132.7 -0.167492662

These log returns can then be used to calculate the descriptive statistics. Through inputting the data into Excel, the data is provided.
Descriptive Statistics:
Statistic Name:
G4S Name:
GKN
Name:
GLAXO SMITH KINE

Time Period:
Start – 31/12/1999
End – 31/05/2002
Mean -0.007257391 -0.008444887 -0.007596267
Standard Error 0.020441715 0.019323072 0.012188405
Median 0.019475387 -0.009237678 - 0.002597273
Mode #N/A #N/A #N/A
Standard deviation 0.110082005 0.104057928 0.065636568
Sample variance 0.012118048 0.010828052 0.004308159
Kurtosis 1.611338969 0.849653662 1.361266742
Skewness -1.182990353 -0.564157907 0.135248479
Range 0.441833625 0.44441368 0.335103395
Minimum -0.309773903 -0.282854115 - 0.167492662
Maximum 0.132059722 0.161559565 0.167610733
Sum -0.210464349 -0.244901732 - 0.220291756
Count 29 29 29

Analysis of statistics:
By examining the derived results, we can come to the following conclusions:
• The scale of difference between the stocks was differing. G4S’ mean return was -0.0073 whilst GKN’s was -0.0084 and GLAXOSMITHKINE’s was -0.0076. We can see that whilst G4S and GLAXOSMITHKINE were close, GKN’s differed greatly.
• The median indicates over half of
Show More

Related Documents: Assignment Of Log Returns For My Three Chosen Stocks

Research Paper On CMOS

Vahid Adamkhoshbakht Research Paper CMOS Complementary metal–oxide–semiconductor is a technology for constructing integrated circuits. CMOS technology is used in microprocessors, microcontrollers, static RAM, and other digital logic circuits. CMOS technology is also used for several analog circuits such as image sensors, data converters, and highly integrated transceivers for many types of communication. Frank Wanlass patented CMOS in 1963. CMOS is also sometimes referred to as complementary-symmetry…

Words 440 - Pages 2

Essay on Siemens MSP Case Study 2

movement towards the higher levels of organizational project management maturity, Siemens Corporate Research wanted to rethink how it could accelerate improvements, manage organizational change, and deliver business benefits. Joe Sopko is an organizational project management consultant for Siemens businesses in the Americas. He is part of the Project and Risk Management group of Siemens Corporate Research (US) and Siemens Corporate Technology (globally), which works across the organization to develop…

Words 2332 - Pages 10

Ageing Population In Singapore Case Study

The absence of natural resource in Singapore resulted in depending on the workforce to make the country’s economy strong and vibrant. However, a paper published by National Population & Talent Division of the Prime Minister’s Office (PMO) states that “Singapore will find itself in the unprecedented position of having a declining number of citizens in working ages from 2020 onwards.” The ageing population in Singapore leads to a contracting workforce resulting to lesser innovation which…

Words 1066 - Pages 5

Idealism: Jean Chrétien and Public Works Minister Essays

Minister's Office, ministers and secretaries of state. "It's time to define the role of exempt staff and impose some prescription on what they do and how they do it," said Donald Savoie, the University of Moncton professor who headed Gomery's research team. "Government has become too complex, especially with access to information. We need to get a handle on them so they aren't loose cannons flying around issuing orders without someone living with the consequences. It's not the public service's…

Words 1072 - Pages 5

Project Management Essay

|Date of Release |Owner |Summary of Changes | |Initial Draft - SIDdocs |06/30/2004 |SID - PMO |Initial Release | |OSI Admin #4306 |04/09/2008 |OSI - PMO |Incorporated Cost Management Plan tailoring guide | | | | |information into this template…

Words 7592 - Pages 31

Clothes R Us Essay

KEL304 MARK JEFFERY AND JOSEPH F. NORTON Clothes ‘R’ Us Point-of-Sale Initiative: Managing IT Programs Overview Marcus Nord, a program manager for Clothes ‘R’ Us, had an urgent update for the program management team and Nancy Orlin, the company’s chief information officer (CIO). Nord had just learned that four of the six product managers had unexpectedly quit. For Orlin, this was yet another obstacle that was making this program one of the hardest she had managed in her career. In Orlin’s…

Words 18525 - Pages 75

Project Management Proposal Essay

| Move the Pyramid Project | | MUMMYMOVERS | project proposal | | MOVE THE PYRAMID PROJECT Table of Contents Table of Contents Executive Summary 4 Management Proposal 5 Management Approach 5 Organizational Chart 6 Scope Statement: 6 Project Justification: 6 Requirements: 6 Deliverables: 6 Project Success Criteria: 7 Project Team Members: 7 Work Breakdown Structure (WBS) 8 MSP Activities, Sequencing & Dependencies 8 MSP Schedule, Network & Critical…

Words 14334 - Pages 58

Essay about Eod Team Leader Certs

(DISTRIBUTION RESTRICTION: Distribution authorized to U.S. Government agencies and their contractors only because this publication contains technical and operational information. This determination was made on 22 March 2006. Other requests will be referred to CASCOM, ATTN: EOD Training Writer/Developer, 401 1st St Suite 225, Ft Lee. VA 23801-1511. DESTRUCTION NOTICE: This Supercedes STP 9-55D14-SM-TG dated June 2002. )SOLDIER TRAINING HEADQUARTERS PUBLICATION DEPARTMENT OF THE ARMY…

Words 41723 - Pages 167