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 : Report on Simple Random Sampling with

One of my friend has a problem on simple random sampling. Can someone provide a complete Report on Simple Random Sampling with or without replacement?

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 : Problem on Model Checking Part (a).

Part (a). Draw a state diagram for a car with the following state variables: D indicating whether the car is in drive; B indicating the brake pedal is depressed; G indicating the gas pedal is depressed; and M indicating whether the car is moving. (For example, the sta

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 : Sample Questions in Graphical Solution

Solved problems in Graphical Solution Procedure, sample assignments and homework Questions: Minimize Z = 10x1 + 4x2 Subject to

Q : OIL I need to product when oil will

I need to product when oil will finish time (by years) for 6 countries if the keep their production (per day) in the same level. So, the 6 countries have fixed reserves and production 1. statistics for Bahrain Crude oil reserves (million barrels) = 124.6 be careful in million Crude oil producti

Q : Homework help on Human memory & SPSS

Effect of Scopolamine on Human Memory: A Completely Randomized Three Treamtent Design (N = 28) Scopolamine is a sedative used to induce sle

Q : Compute the stoke statistics Please do

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

Q : Compute two sample standard deviations

Consider the following data for two independent random samples taken from two normal populations. Sample 1 14 26 20 16 14 18 Sample 2 18 16 8 12 16 14 a) Com

Q : Statistics for Management Assignment

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1945377
Asked

3,689

Active Tutors

1439821

Questions
Answered

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

Submit Assignment