We're Open
+44 7340 9595 39
+44 20 3239 6980

Conduct the OLS regression analysis and comment on the results. Do the estimates give any direct or indirect support to the APT?

  100% Pass and No Plagiarism Guaranteed

Conduct the OLS regression analysis and comment on the results. Do the estimates give any direct or indirect support to the APT?

The model below is for an APT (arbitrage pricing theory)-type multiple regressionanalysis and it investigates what influences the rate of return on a company’s shares. 
ERCOMPANYt = α+β1ERSFTSEt+ β2TERMt + β3EXCHANGEt+ β4INFLATIONt + β5DMONEYt+ β6OILt +εt                                                                                                                                     (1)The dependent variable (ERCOMPANY) is the company’s excess return based on its
share price {labelled as COMPANY in the Excel data spreadsheet}. Note that you areexpected to construct this variable yourself, knowing that excess return means theadditional return on top of risk-free rate proxy, i.e., TBILLSHORT as explained below.
The explanatory variables are:I. ERSFTSE: excess rate of return based on the FTSE ALL SHARE index in
London Stock Exchange {labelled as FTSE in the Excel data spreadsheet}.II. TERM: The difference between annual returns on 20-year government bondsand 3-month treasury bills {labelled as TBILLLONG and TBILLSHORT,

respectively, in the Excel data spreadsheet}.
III. EXCHANGE: exchange rate between US dollar and UK sterling {labelled as
EXCHANGE in the Excel data spreadsheet}.IV. INFLATION: inflation rate based on producer price index {labelled as PPI in the

Excel data spreadsheet}.V. MONEY: narrow definition of money supply, i.e., M1, in billion £ {labelled asMONEY in the Excel data spreadsheet}.VI. OIL: crude oil price in $US (labelled as OILPRICE in the Excel data

spreadsheet}.


In order to employ a set of regression analyses, the dataset is provided in Canvas (filename: Data for Assignment 2016.xlsx). The dataset is real data, with monthlyfrequency for the period September 1986 to August 2013. The explanatory variableson the right hand side are the same for all students. However, each student is allocateda different company; hence, the dependent variable of each assignment will bedifferent. Check your student number to find out which company is allocated to you inthe ‘company share price’ spreadsheet. Then, copy/paste the share price of thecompany allocated to you in column B of the spreadsheet named ‘Macroeconomicdata’ in the same file.

APT assumes that it is the unexpected changes in financial and macroeconomicfactors that exert influence on company returns. Therefore, before analysing data withregressions, you are advised to read the core textbook and module notes to identifyhow to use the raw data to transform series into variables that will eventually beincluded in the regression model.

Required:
1. Conduct the OLS regression analysis and comment on the results. Do the

estimates give any direct or indirect support to the APT?

(25 marks)

2. Refer to the OLS assumptions and conduct the diagnostic tests with respect toheteroscedasticity, normality, and autocorrelation. If there is any violation of theOLS assumptions, what can be done as remedies to these misspecifications?Namely, explain how to address regression models that fail these diagnostictests in your analysis.(35 marks)3. Is the functional form of the model actually linear as suggested by equation (1)and does it suffer from the multicollinearity problem? Provide the necessarytests.
(15 marks)
4. Test for the parameters’ stability by considering two or more sub-samples, e.g.,the time between September 1986 and December 1999; and the time betweenJanuary 2000 and August 2013. You can think of other periods such as the2007-08 financial crisis.(15 marks)5. Are there any other diagnostic tests that you might have considered? Providethem if the answer is ‘yes’.(10 marks)


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: Conduct the OLS regression analysis and comment on the results. Do the estimates give any direct or indirect support to the APT?
  • Price: £ 79
  • Post Date: 2018-11-09T09:43:25+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Conduct the OLS regression analysis and comment on the results. Do the estimates give any direct or indirect support to the APT? Conduct the OLS regression analysis and comment on the results. Do the estimates give any direct or indirect support to the APT?
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I have tried other sites for assignment help but the result that Insta Research has produced outweighs others. Since I am weak at writing and shaping the data logically, I am glad I took help from this site. Thanks to my writer for such a great quality of the assignment in Business.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I am not good at designing PowerPoint presentations so I took help from Insta Research. The format is cool and attractive. All the information is nicely placed and used. I am looking forward to presenting so that I could demonstrate my presentation and receive good comments. Thank you for help.