I sent you a work from last year, it was the same questions but now is only for 3 locations. As well, in the previous work, he talked too much, what I want from you is to do a small introduction and directly answer to the questions.
All the calculation has to be on excel, you do the calculation on excel, you do a screenshot of the result and the table and you interpret the result.
You are to write:
o A professional report in a MS-Word document.
o At the end of the report, in an appendix, you are to add in your do-file(s) that you used to (i) generate the data used in your analysis, and that you used to (b) analyse the data. The do file(s) should also show how you created any figures that are used in the report.
You need to do three different documents:
1. A WORD file that contains your report; Do not
submit a PDF file, submit only a Word document.
2. A data file in Microsoft excel format that you used to write your report. This
excel file should contain dataset and calcula3on on separate files.
3. A WORD file that contains List of website that data is collected
Check your spelling before submission using the spellchecker in Microsoft Word. This is meant to be a professional report you are wri3ng. Write in paragraphs.
The coursework should be a maximum of 3,000 (+- 200) words long excluding references and appendices.
Subject:
The United Kingdom’s exit from the European Union (Brexit) is causing implications on home ownership, the letting market, and the real estate sales market in the UK. The repercussions are expected to be significant and major and would influence nearly all spheres of life in Europe, as well as overseas. The key focus of the current coursework is to examine the factors expected to prompt an economic or social change in the housing market.
Required:
Using Office for Na3onal Sta3s3cs (ONS), The World Bank, h]p://landregistry.data.gov.uk, Bloomberg and other sources, download Quarterly/Monthly data for house price of
all property types for three different Loca3on in United Kingdom (London, Birmingham, Wales, Northern Island and Scotland) and other relevant datasets onto the sta3s3cal
software package as requested. Please note: each student is assigned different dates for the data set. Date: November 2015 to September 2018.
Access and download the dataset.
Answer to the following questions:
1. Compute full descrip3ve sta3s3cs including mean, Standard deviation, Skewness,
kurtosis and draw histogram. Interpret the results ( why the variation is higher or lower between the locations etc) (10 marks)
2. Draw the scatter plot between London and 2 other different loca3ons. Check for
normality (perform Chi square test). (20 marks)
3. Using mul3ple regression analysis taking house prices as dependent variable for all loca3ons, determine the impact factors (e.g. Interest rate, Economic growth, Mortgage availability, employment, Infla3on etc.) as explanatory (independent) variables for both regression models. (20 marks)
4. Test the significance of each independent variable (for all loca3ons). Interpret the results. (10 marks)
5. Perform F-test to test the significance of each regression model. Interpret the results.
(10 marks)
6. Write a report discussing the house prices fluctua3on and poten3al impact of Brexit.
(30 marks) ( around 1250 words)
[Plagiarism is strictly forbidden and any case found will be treated according to university regulations.]
The report should be referenced using the Harvard Referencing style.
To collect independent variable:
https://www.ons.gov.uk/
https://www.gov.uk/search/research-and-statistics https://www.bsa.org.uk/statistics
Collect housing prices (Y variable):
https://landregistry.data.gov.uk/app/ukhpi/browse? from=2019-02-01&location=http%3A%2F%2Flandregistry.data.gov.uk%2Fid%2Fregion%2Funite d-kingdom&to=2020-02-01