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 : 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 : State Kendalls notation

Kendall’s notation: A/B/C/K/m/Z A, Inter-arrival distribution M exponential D constant or determ

Q : Networks of queues Networks of queues •

Networks of queues • Typically, the flow of customers/request through a system may involve a number of different processing nodes.– IP packets through a computer network– Orders through a manufactur

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 : 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 : Sample z test and Sample t test A

A random sample X1, X2, …, Xn is from a normal population with mean µ and variance σ2. If σ is unknown, give a 95% confidence interval of the population mean, and interpret it. Discuss the major diff

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 : Point of estimate standing data se to

standing data se to develop a point of estimate

Q : MANOVA and Reflection Activity

Activity 10: MANOVA and Reflection 4Comparison of Multiple Outcome Variables This activity introduces you to a very common technique - MANOVA. MANOVA is simply an extension of an ANOV

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

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1960997
Asked

3,689

Active Tutors

1446916

Questions
Answered

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

Submit Assignment