--%>
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 : 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 : Computers playing games How Computers

    How Computers playing games can be categorized according to different dimensions?

    		•
  • 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 : Creating Grouped Frequency Distribution

    Creating Grouped Frequency Distribution: A) At first we have to determine the biggest and smallest values. B) Then we have to Calculate the Range = Maximum - Minimum C) Choose the number of classes wished for. This is generally between 5 to 20. D) Find out the class width by dividing the range b

    		•
  • 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 : Statistics for Management Assignment

    Q : Cumulative Frequency and Relative

    Explain differences between Cumulative Frequency and Relative Frequency?

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

    		•