The Housing Market Case Study

The Housing Market Case Study
Introduction to Business Analytics

Aim: For this coursework you will act as a junior business analytics consultant working for one of your hometown’s (i.e. the town/city you grew up) estate agency with the aim of carryingout a study for the housing market in your hometown. The manager of the real estate agency wants to obtain a general view of the housing market focusing on the housing prices, type and size of houses for sale.

Data set: You will collect your data from a reliable source (i.e. www.rightmove.co.uk) using the first part of your hometown’s postcode. (e.g. if your postcode is B17 8GH, you should use B17 only to collect the data). All EU and overseasstudentsplease access the file “postcode.xlsx” available on blackboard, which contains the postcode you need to do the research for.

Select information for at least 100 houses making sure that you have a representative sample of different type of houses (flat, terraced, detached, semi-detached), and sizes (i.e. number of bedrooms). For each house collect a maximum of four characteristics such as: price, house type, number of bedrooms, and distance from nearest railway station.

Once you have completed your statistical analysis write a report thatprovidethe manager of the estate agency with the information that he/she needs.But remember that the manager is not a statistician. You should therefore write a report of about 3-4 pages, which will avoid the use of statistical formulas but will explain to the manager what the statistical terms used are.

Statistical Analysis:The report should contain amongst other things the followinginformation

1. A description of the study, the source of your data, thelimitations and any problems encountered in using the data
2. Produce evidence of any modification or re-coding ofthe data if needed
3. At least three visualization techniques to describe the data. One of them should definitely include more than one variables.. If you think that more graphs are needed, please do but they should not exceed more than 1.5 pages. A clear summary of the information obtained from the graphs and the explain their choice of type
4. A clear summary and table of the descriptive statistics and the information which can be obtained from thesestatistics
5. Assuming that the housing prices are normally distributed present your manager with the 95% and 99% confidence interval of the average house price per house type and explain their meaning.

You can obtain the average house prices from the link:
http://news.bbc.co.uk/1/shared/spl/hi/in_depth/uk_house_prices/html/houses.stm)
6. Undertakethe necessary analysis to produce your manager with a summary on whether the average price of the different type of houses in your data sample is in line with the average price in the UK
7. Any other analysis that might be useful

Writing the report: The Manager is numerate but has no knowledge of statistics so any use ofstatistics should be explained within the report.However, the report should containonly brief explanation of the technical terms, e.g. “the standard deviation is a measure of the spread of variability of the data about the sample mean”. Avoid the use of technical terns that are not explained clearly.

Marking:Marks will be awarded for both the style of the report (20%) but also the technical analysis ((80%). A breakdown of the mark is shown below:

 

 

ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!

 

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.

 

[order_calculator]