Report on Kingfisher Bay’s House and Rental Data

Report 1
Report on Kingfisher Bay’s House and Rental Data
Objective: Data Analysis of Kingfisher Bay’s House and Rental Data.
Summary:
This is an attempt to know how the Kingfisher bay’s (Melbourne’s) house price are
increasing and how more suburb hove have a median house price. So, in the first part of the
Project Question, we cover the general exploratory analysis of renal data. In which we found
that major proportion of house based on house price is coming closer to Median, we found
that there is no correlation between different kind of suburb, and housing price is increasing
with increase in quality of house and housing price is depend on weekly rent.
In the second part of report question, contain the specialized data analysis of Melbourne City
of Kingfisher bay. In this analysis we found that 55 houses are going for subdivision and we
are accepting the claim of senior manager regarding the section of the properties rented which
were not occupied at the time (reduced to less than 25%) and we are rejecting the claim of the
mean price of bay side house which are exceeding $825K.
Again, we found that there is relation between Pair of Results (Passed In, Sold before the
Auction), (Passed in - Vendor Bid, Sold before the Auction) and (Sold during the Auction,
Sold Prior To Auction) Result so we can reduce our survey time.
Please find the answers of the given questions.
Part 1
Answer 1:
Summary of Housing Price
 According to Data Set (1). Average Price of House is 886.575.

Report 2
 The spread of house price from the mean is 324.9466.
 Median housing price is 852.
 The tail or we can say that flatness of Housing price distribution is -0.1477 or Plato-
type.
 Frequency distribution is slightly positive skewed.
 Range of the House price is 1569.
 Minimum housing price is 192.
 Maximum house price is 1761.
 Total sum of housing price is 106389 in Thousand.
According to frequency distribution of house prices from Data Set (1), we found that House
price is not following the symmetry nature. Distribution of house prices is slightly positive
skewed and mean of positively skewed data will be greater than the median. Therefore, the
focus of the media articles is on the median prices of the houses and not particularly in the
average.
Answer 2:
According to Data Set (1) we do the exploratory analysis of variation between 1, 2 and 3
Suburb and found that there is significant difference between In Suburb. It Means Housing
mean of these three suburbs is not equal.
Answer 3:
According to Data Set (1), House prices are increasing with increase in Condition of House.
If the Condition or Quality of House is Excellent then price of the house will be very high
and if condition of house is very poor then price will be very low.
The hierarchy of Housing price is like this.