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 : Hypothesis homework A sample of 9 days

A sample of 9 days over the past six months showed that a clinic treated the following numbers of patients: 24, 26, 21, 17, 16, 23, 27, 18, and 25. If the number of patients seen per day is normally distributed, would an analysis of these sample data provide evidence that the variance in the numbe

Q : What is Inter-arrival times

Inter-arrival times:A) Requests arrive randomly, often separated by small time intervals with few long separations among themB) The time until the next arrival is independent of when the last arrival occurredC) Coro

Q : Principles of data analysis For the

For the data analysis project, you will address some questions that interest you with the statistical methodology we are learning in class. You choose the questions; you decide how to collect data; you do the analyses. The questions can address almost any topic,

Q : Develop the most appropriate regression

Predicting Courier Costs The law firm of Adams, Babcock, and Connors is located in the Dallas-Fort metroplex. Randall Adams is the senior and founding partner of the firm. John Babcock has been a partne

Q : Explain Service times Service times: A)

Service times:A) In most cases, servicing a request takes a “short” time, but in a few occasions requests take much longer.B) The probability of completing a service request by time t, is independent of how much tim

Q : What is Forced Flow Law Forced Flow Law

Forced Flow Law: • The forced flow law captures the relationship between the various components in the system. It states that the throughputs or flows, in all parts of a system must be proportional t

Q : Building Models Building Models • What

Building Models • What do we need to know to build a model?– For model checking we need to specify behavior • Consider a simple vending machine – A custome rinserts coins, selects a beverage and receives a can of soda &bul

Q : Problems on ANOVA We are going to

We are going to simulate an experiment where we are trying to see whether any of the four automated systems (labeled A, B, C, and D) that we use to produce our root beer result in a different specific gravity than any of the other systems. For this example, we would l

Q : Calculate the p- value Medical tests

Medical tests were conducted to learn about drug-resistant tuberculosis. Of 284 cases tested in New Jersey, 18 were found to be drug- resistant. Of 536 cases tested in Texas, 10 were found to be drugresistant. Do these data indicate that New Jersey has a statisti

Q : Statistics for Management Assignment

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1934919
Asked

3,689

Active Tutors

1419709

Questions
Answered

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

Submit Assignment