--%>
Assignment Help - homework help

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 = (Pt-Pt-1)/Pt-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

 

 

 

 

 

 

 

 

   Related Questions in Basic Statistics

  • 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 : Probability how can i calculate

    how can i calculate cumulative probabilities of survival

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

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

    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 : 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 : 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 : 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 : 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?

    		•