Compute the stoke statistics

Please do the following and submit your results in the table format in a word file on canvas:

a) Go to Yahoo finance/Investing/Stocks/Research tools/Historical quotes/Historical prices and download adjusted monthly closing prices for the period 1/1/2006 to 31/12/2012 for:

Exxon (XOM)

Walmart (WMT)

S&P 500 (^GSPC)

b) Sort data from oldest to newest record.

Compute monthly returns for each stock and index:

Return at time t = (P_t-P_t-1)/P_t-1

c) Compute the following statistics for each stock and the index:

i. Average monthly return

ii. Geometric monthly return and the corresponding annual return.

iii. The monthly standard deviation and corresponding annual standard deviation

iv. Use the monthly returns and compute the correlation between each pair (Exxon-Walmart, Exxon-S&P 500, Walmart-S&P 500).

v. What is the beta for each stock? The beta for stock x is given by the following formula,

2374_Untitled 12.png

Please present your results in the following format:

Statistic	Exxon	Walmart	S&P 500 Index (mkt)
Average monthly return
Compounded monthly return
Annual return
Monthly standard deviation
Annual standard deviation
Correlation
Exxon-Walmart =
Exxon-S&P 500 =
Walmart-S&P 500 =
Beta

View Complete Question

Related Questions in Basic Statistics

Q : Regression Analysis 1. A planning

1. A planning official in the Texas Department of Community Affairs, which works in the office next to you, has a problem. He has been handed a data set from his boss that includes the costs involved in developing local land use plans for communities wi

Q : Define Service Demand Law

Service Demand Law:• Dk = SKVK, Average time spent by a typical request obtaining service from resource k• DK = (ρk/X

Q : Probability how can i calculate

how can i calculate cumulative probabilities of survival

Q : Explain Queuing theory Queuing theory :

Queuing theory: • Queuing theory deals with the analysis of lines where customers wait to receive a service:

Q : Safety and Liveness in Model Checking

Safety and Liveness in Model Checking Approach; •? Safety: Nothing bad happens •? Liveness: Something good happens •? Model checking is especially good at verifying safety and liveness properties –?Concurrency i

Q : FIN512 Entrepreneurial Finance Chapter

Chapter 6: Discussion Question: #4 p. 223 It is usually easier to forecast sales for a seasoned firm contrast to an early-stage venture because an early-stage venture has limited access to bank credit lines, sho

Q : Computing Average revenue using

Can anyone help me in the illustrated problem? The airport branch of a car rental company maintains a fleet of 50 SUVs. The inter-arrival time between the requests for an SUV is 2.4 hrs, on an average, with a standard deviation of 2.4 hrs. There is no indication of a

Q : State the hypotheses At Western

At Western University the historical mean of scholarship examination score for freshman applications is 900. Population standard deviation is assumed to be known as 180. Each year, the assistant dean uses a sample of applications to determine whether the mean ex

Q : STATISTICS Question This week you will

This week you will analyze if women drink more sodas than men. For the purposes of this Question, assume that in the past there has been no difference. However, you have seen lots of women drinking sodas the past few months. You will perform a hypothesis test to determine if women now drink more

Q : Simplified demonstration of Littles Law

Simplified demonstration of Little’s Law:

Discover Q & A

Leading Solution Library

Avail More Than 1413859 Solved problems, classrooms assignments, textbook's solutions, for quick Downloads

No hassle, Instant Access

Start Discovering

18,76,764

1961053
Asked

3,689

Active Tutors

1413859

Questions
Answered

Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!

Submit Assignment