Exploring & Visualising Data: Descriptive Statistics & Plots- Statistical Analysis Assignment

Internal Code: MAS7294

Statistical Analysis Assignment:

Task: The spreadsheets provide information for 338 houses. Variables in the dataset include:

• The housing ID
• Region by postcode
• Distance from city in kilometres
• Number of rooms
• Type: Detached (1) Semi-detached (0)
• Age in Years
• Price in Euros

Your task is to “get a feel” for what is going on in this particular housing market. In particular, we want to use simple descriptive statistical techniques as well as plots and graphs to get a first understanding of which variables are likely to influence house prices. You will, therefore, replicate some of the basic techniques that every marketer needs to know:

1. Create one or more pivot table that shows (a) the average house price by type of house; (b) the average price of house by number of rooms; (c) the average house price by postcode. What do you find?
2. Visualise the pivot table using appropriate plots