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

    how can i calculate cumulative probabilities of survival

    		•
  • Q : Statistics for Management Assignment

    Q : Probability how can i calculate

    how can i calculate cumulative probabilities of survival

    		•
  • Q : Define Operational Analysis

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

    Q : STATISTICS Question This week you will

    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 : State Littles Law Little’s Law : • L =

    Little’s Law: • L = λR = XR • Lq = λW = XW • Steady state system • Little’s Law holds as long as customers are not destroyed or&nbs

    		•
  • 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 : Develop the most appropriate regression

    Predicting Courier Costs The law firm of Adams, Babcock, and Connors is located in the Dallas-Fort metroplex.  Randall Adams is the senior and founding partner of the firm.  John Babcock has been a partne

    		•
  • 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 : Spss in Business and Management Please

    Please tell me the cost of this current assignment. Note : I do not want the Solutions but please tell me the price as the assignment is .. Is the cost 3 euro? Do you sell those questions?

    		•