--%>
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 : Problem on queuing diagram Draw a 

    Draw a queuing diagram for the systems below and describe them using Kendall’s notation: A) Single CPU system <

    		•
  • Q : Computers playing games How Computers

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

    		•
  • Q : Average think time Software monitor

    Software monitor data for an interactive system shows a CPU utilization of 75%, a 3 second CPU service demand, a response time of 15 seconds, and 10 active users. Determine the average think time of these users?

    		•
  • Q : Data Description 1. If the mean number

    1. If the mean number of hours of television watched by teenagers per week is 12 with a standard deviation of 2 hours, what proportion of teenagers watch 16 to 18 hours of TV a week? (Assume a normal distribution.) A. 2.1% B. 4.5% C. 0.3% D. 4.2% 2. The probability of an offender having a s

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

    standing data se to develop a point of estimate

    		•
  • Q : Stats The College Board SAT college

    The College Board SAT college entrance exam consists of three parts: math, writing and critical reading (The World Almanac 2012). Sample data showing the math and writing scores for a sample of twelve students who took the SAT follow. http://west.cengagenow.com/ilrn/books/assb12h/images/webfiles/

    		•
  • Q : Simplified demonstration of Littles Law

    Simplified demonstration of Little’s Law:

    Q : Sample Questions in Graphical Solution

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