• 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. Statistics. The purpose of this coursework is to investigate the comparative relationships between the ...

    7 43000 2 81 Ford Mondeo 17780 7995 4 30000 1 82 Mazda Pegasus 10420 2495 7 50000 3 83 Rover 416i 14486 3685 6 64000 1 84 Vauxhall Corsa 7840 4976 4 21000 2 85 Vauxhall Corsa 7440 3495 6 55000 2 86 Ford Fiesta 6590 1664 10 37000

  1. Anthropometric Data

    In this case length is not an issue for that particular child the investigation is on the breadth, this may say the child's feet is broader than the other children in the chosen age group. The outlier will be put in and will be used when calculating the r value

  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. Design an investigation to see if there is a significant relationship between the number ...

    Limitations: Several limitations are apparent in this investigation. Most of them due to the time restrictions imposed on me by the quick moving tide. For example, the number of samples taken has to be limited due to the time available. It would be advantageous to take a larger sample, as it would be more representative, and therefore would give more reliable results.

  2. Teenagers and Computers Data And Statistics Project

    at each edge( for the corners), this would mean it had to be n -2 . Therefore I had to redo my table to show this correction. As shown below Number of red faces Formula 0 (n - 2 )

  1. Application of number: level 3 - Is House Buying a Good Idea or Not?

    The calculations for the means are seemingly correct since they are similar to mean values provided by the Internet. It can be quite simply proved that the mean for all houses is correct as: [First-time buyers' houses' mean + Other houses' mean ] / 2 = All houses' mean All

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

    The pink circled result is again an anomalous result. Stem and leaf diagrams put the data in numerical order in an easy to read table. This is a stem and leaf diagram to show Angle estimates: Year 9 ANGLE 6 Year 11 0 2 9 5,5,5,5,5,5,5,0,0,0 3

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