Words calculate the confidence intervals for the sample mean price

• The housing ID

• Region by postcode

• 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.

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

4. Calculate the confidence intervals (CI) for the sample mean of “price”, using the confidence function (normal distribution). Briefly explain your findings.

4. Create a scatterplot for the two variables price and distance from city. Do you find any outliers or extreme values? Interpret your results.