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 : 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 : Define Operational Analysis

Operational Analysis: • Analysis method based on the measurement of the operational characteristics of the system.

Q : How to solve statistics assignment in

How to solve staistics assignment, i need some help in solving stats assignment on AVOVA based problems. Could you help in solving this?

Q : Write out the null hypothesis 1.

1. (AAC/ACA c9q1). For each of the following studies, decide whether you can reject the null hypothesis that the groups come from identical populations. Use the alpha = .05 level.1a.

Q : Use the NW corner rule to find an

(a) Use the NW corner rule to find an initial BFS, then solve using the transportation simplex method. Indicate your optimal objective function value. (b) Suppose we increase s1 from 15 to 16, and d3 from 10 to 11. S

Q : Help An experiment is conducted in

An experiment is conducted in which 60 participants each fill out a personality test, but not according to the way they see themselves. Instead, 20 are randomly assigned to fill it out according to the way they think a parent sees them (i.e. how a parent would fill it out to describe the participant

Q : Cumulative Frequency and Relative

Explain differences between Cumulative Frequency and Relative Frequency?

Q : Statistics basic question This week you

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 : 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 : Explain Queuing theory Queuing theory :

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

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1930014
Asked

3,689

Active Tutors

1445232

Questions
Answered

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

Submit Assignment