Compute the correlation coefficient

Assignment Help Other Subject

Reference no: EM1377606

You have been given an excel spreadsheet called "Eviews Assessment Dataset- FNM221". This consists of monthly observations on financial and macroeconomic data. The sample starts in March 1986 until April 2007.

Microsoft		Stock Prices of Microsoft
SANDP		Value of Standards and Poor
CPI		Consumer Price Index
Industrial production		Industrial production in billions of US $
USTB3M		Rate on 3 months Treasury Bill
USTB6M		Rate on 6 months Treasury Bill
USTB1Y		Rate on 12 months Treasury Bill
USTB3Y		Rate on 3 year Treasury Bill
USTB5Y		Rate on 3 year Treasury Bill
USTB10Y		Rate on 3 year Treasury Bill
M1MONEY SUPPLY		Money Supply (M1)
CONSUMER CREDIT		Consumer Credit
BAA-AAA SPREAD		Corporate Default Spread

Answer ALL questions; marks for each section are noted in brackets.

Input the data in Eviews.

(1) Plot log returns (log (P_t/P_t-1) of Microsoft and Standard and Poors over the sample size. Give a brief explanation of how the stock performed over time. Compute the correlation coefficient between the market and the stock and comment.

(2) Tabulate the summary Statistics (Mean, Median, Standard Deviation, Skewness and Kurtosis) table for Microsoft and comment.

(3) One of the earlier tests of the CAPM (the Market Model) simply assumes the following relationship:

R_i = α + βR_m + u_i

Estimate this relationship, and comment on the goodness of fit.

(4) Test the hypothesis that α = 0 against the alternative that α ≠ 0

(5) Test the hypothesis that β = 0 against the alternative that β ≠ 0

(6) The Arbitrage Pricing Theory is another competitor for the CAPM. This pricing theory states that certain "factors" can influence returns. The factors which are considered include the following: Difference in log Industrial Production (also, known as change in GDP), Difference in log of Consumer Credit, BAA-AAA Spread.

First create the log of change in Industrial Production and Consumer Credit. (similar to how you computed returns in step 1)

Estimate the APT:

R_i = α + β₁R_m + β₂X₂+ β₃X₃+ β₄X₄+ u_i

Where : X₂, X₃, X₄ are respectively the log change in industrial production, log change in consumer credit and BAA-AAA spread. Comment on the new model, paying special attention to the goodness of fit, and the parameters.

Does the APT improve on the CAPM as a measure of predicting returns? (Hint test the joint hypothesis that β₂= β₃= β₄= 0. )

Reference no: EM1377606

Questions Cloud

Sources of synergy among the diversified companies : Recognize the sources of synergy or core competencies among the diversified companies.First, list at least 3-items or services; second, indicate possible sources of synergy, and third, give the actual firm being described in your discussion.

Describe the production process : Assume you had to visit two fast food restaurants that produce hamburgers. Being that you do not eat fast food this is kind of hard for you to do and was wondering if you could get some help.

Describe the roles and mechanisms of these rna : Most of the genome does not code for protein, therefore 99% of the human genome is junk that serves no purpose?. With specific reference to examples long and short non-coding RNAs discuss whether you agree with this statement. In your answer you shou..

Designing a training web site : Suppose that you require to design the Web site of a call center, Conations, with offices across in Tennessee, Washington, India, Illinois, China, and Germany. The Web site will be used to provide Website based training to existing workers and orien..

Compute the correlation coefficient : Give a brief explanation of how the stock performed over time. Compute the correlation coefficient between the market and the stock and comment.

Communist kerala landmark agreement : SmartCity and Government of Kerala sign landmark contract Dubai, May 13, 2007(WAM): Opening another horizon of business partnership in India and UAE, SmartCity, a joint venture in TECOM Investments and Sama Dubai,

Approaches to overcoming resistance in hospitals : Create a description of how you would implement each of three best approaches at the hospital. Make a distinct, one hundred to 200 word plan for each approach.

Question about delegation : Discuss why do many managers have a difficult time delegating effectively and explain why is effective communication a direct link to successful delegation?

Data collection strategy and sampling, measurement : Discuss and explain three important things about data collection strategy and sampling, measurement, information collection instruments, and data preparation and display.

User Account

All Pages