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

Introduction

American House Price Analysis

Table of contents

image00.png

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.

Middle

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

image26.pngimage03.pngimage25.pngimage02.png

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.

image04.pngimage05.png

image27.pngimage06.png

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.

Conclusion

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.

NOTES:

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. Investigating the Relationship Between the Amount of Money a Football Club Receives and its ...

    This is a problem because it makes the results of plotting a scatter graph misleading. If a scatter graph is plotted of money Vs. league position, problems could arise. For example, a team finishing 20th in Division 1 (24 teams)

  1. I am investigating how well people estimate the length of a line and the ...

    0.4 26 2 0.5 33 1 0.5 33 1 0.5 33 2 0.5 33 0.2 1.3 86 Table leading onto box plot for hypothesis 2 (Girls will be better at guessing the size of a short line than boys) Year 7 and 10 Males 1.5 0 0 1.5 0 0

  2. Anthropometric Data

    The outlier may be defined as data point that emanates from a different model than do the rest of the data. This outlier may be there due to the fact of data input error or may also explain that there is a medical problem with the child's foot growth.

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

    Peugot 406LX 13975 5795 3 53000 1 63 Volkswagen Golf GTi 16139 6995 5 35000 2 64 Ford Focus 14505 8800 2 7200 1 65 Ford Puma 13230 8250 3 34000 1 66 Peugot 206 9125 7500 1 18000 1 67 Peugot 406 17490 7500 1 17500 1 68 Honda

  2. "The lengths of lines are easier to guess than angles. Also, that year 11's ...

    Next, I drew some histograms, and from these you can see that even though the most densely populated groups were not the groups of 4.5 - 5 for the line, or 30 - 35 for the angle, you can see that in the year 11 estimates for line 2, the most densely populated group was 4 - 4.5cm group.

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

  2. Teenagers and Computers Data And Statistics Project

    3 1 6 [ (n - 2) 2] 2 12( n-2) 3 8 Total n 3 7. The 10 x 10 x 10 table Number of red faces Number of cubes 0 512 1 384 2 96 3 8 4 0 5 0 6 1000 Total 8.

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