• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Data Analysis of American House Price

Extracts from this document...


American House Price Analysis

Table of contents


1. Introduction _________________________________________________________________

2. Executive Summary ______________________________

3. Introduction ____________________________________

4. Statistical Analysis _______________________________

4.1 - Overall Distribution of the house price  ________________________________________

4.2 - Investigation of Factors affecting the house price   ______________________________

4.3 - Investigation of Factors affecting the house price  ________________________________

5. Conclusion ____________________________________

6. Recommendations _______________________________

Notes   ____________________________________________

  1. Terms of Reference

This report is the outcome of an analysis and investigation of American house price in order to consider which factor influence the price. It is submitted as my project for Essential Data Analysis module on the Business Studies Programme.

  1. Executive Summary

The data was investigated using the software Minitab ver. 14. This program is very useful for analyzing big data set faster and easier. Through Minitab were created a graph for each requested point. In order o make the graph more understandable, it is provided a table with the more relevant statistic information. This allows a more comprehensive and understandable reading of the report and an easier and more efficient comparison among 2 or more variables in order to make a proper analysis. Correlation and Regression analysis was applied in order to establish the relationship between the price with the size and the distance to the nearest large town.

The data set given as a sample to analyse contain data collected of 100 houses in America from 5 different township numbered from 1 to 5.

...read more.


100. As a result, 45% of the houses analysed does not have a pool.


The Graph 3 shows the proportion of the houses with a pool and a garage. By looking at the table it is clear that the majority of the houses with a pool have also a garage, with 58,18% (32 out of 55 houses with a pool); while 41,82% (23 out of 55) houses with a pool do not have a garage.

However, for houses without a pool, the proportion of houses without a garage is higher than houses with a pool where 82,22% (37 out of 45 houses) do not have a pool nor a garage.



It is evident from Graph 4 that the proportion of the houses with a pool is not the same in all the 5 townships.

In township 5, all the houses (100%) have a pool; followed by township 4 with a 94,4% of the houses. On the other extreme there is township 1 with only 13,33%  (2 out of 15 houses) have a pool, followed by township 2 with 22,22% (6 out of 27 houses). As table 4 shows the proportion of houses with a pool are in ascending order with the number of township: township 1 has the lowest percentage and township 5 has the highest. This could be a coincidence.

However, on the overall distribution, township 4 has the highest percentage of houses with a pool, with 32,73% (18 out of 55 total house

...read more.


There is a slightly higher demand for houses with a pool.If the investor decides to buy a house with a pool, it is suggestible to have a garage as well. Otherwise it is more convenient to have a house without any of the two.If the house is in township 3 to 5, it is highly recommend to have a pool, especially for the last one.The pool will make a huge difference for the value of the house. The value will rise by about 75% if it has a pool.The bigger the house is, the more it values. However, houses with less than 1900sqrft are not very demanded. There is a medium demand for houses with a bigger size.Desirability scale 6 has a highest average and median price and it had a good demand.It is not relevant the distance between the house and a big city.


All the figures used to refer to the price are expressed as thousands of dollars ($ ,000).

In order to determinate the demand, it has been used the assumption that the higher frequency has a higher demand. For example: in township 5 all the houses have a pool. It implies that everybody in that area demand and is willing to buy a house with a pool. Thus there is a very high demand.

...read more.

This student written piece of work is one of many that can be found in our AS and A Level Probability & Statistics section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Probability & Statistics essays

  1. The mathematical genii apply their Statistical Wizardry to Basketball

    Lee took 269 shots and Dom accomplished 345 shots to score 80 baskets. Does this imply that Lee is more accurate? According to the expected mean values and the probabilities of scoring for each model it reinforces Lee's success where all three tests are in his favour.

  2. Forensic Examination of Drugs by Thin Layer Chromatography.

    The unknown samples in this case consist of a mixture of the three compounds provided. Since this is the case by comparing each of the unknown samples to the tested known samples it is possible to determine the composition of each of the unknowns.

  1. Anthropometric Data

    I will able to draw my line of best fit this will be drawn visually and also able to find the correlation coefficient in this case the value of r. Prediction 2 Looking at the scatter graph I can visually predict that I will get a fairly fat ellipse has the points are quite spread out has.

  2. Statistics. The purpose of this coursework is to investigate the comparative relationships between the ...

    Civic 12895 7995 1 9500 1 69 Rover Club 19530 14999 1 2000 1 70 Fiat Bravo 10810 4995 2 18500 1 71 Landrover Discovery 27855 13995 1 40500 1 72 Mercedes Elegance 26425 17500 2 22000 1 73 Porche Sport 32995 19495 6 46000 1 74 Volkswagen Beetle 14950

  1. Teenagers and Computers Data And Statistics Project

    x 12 = 96 The 3 face corners will always be 8 6. Formula Explanation The first formula that I worked out was the total no of cubes, this was simple as to measure the volume of a cube is to cube the length that you have.

  2. Design an investigation to see if there is a significant relationship between the number ...

    a grid and sample from it on the lower shore before it is covered by the tide. I have also opted to sample the lower shore before the middle shore. This is due to the fact that the tide moves in quickly, and so by starting closest to the sea

  1. house prices and sales

    My second hypothesis is: House prices in the South of the country are more expensive than those in the North of the country. I could take another random sample or use the same one. To investigate the North / South divide I will divide my sample into two tables, depending

  2. Bivariate Data Exploration

    The data collected was that of car engine size, and insurance group. The population consisted of all cars on the company's current sales list (regardless of age, mileage, fuel type etc). The population size was 106 (the maximum numbers of cars the company could fit on their land).

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work