• 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. Forensic Examination of Drugs by Thin Layer Chromatography.

    Since these compounds have different molecular structures they interact variably with the mobile & stationary phases in thin layer chromatography. The result is that each component travels at differing rates resulting in a separation of each component, hence each individual spot on the TLC plate represents a compound within the mixture.

  1. One basic assumption of Black-Scholes model is that the stock price is log-normally distributed ...

    We chose Feb 19th as the big event date for the company, because there was a takeover bid from the management of Pizza Express on that day. The share price of Six Continents jumped more than 10% on Feb 19th and the trading volume increased more than 200%.

  2. Statistical Analysis of Facial Proportions

    Therefore can be used to estimate the parent population. Males Unbiased estimate of the Population mean = 1.606 Females Unbiased estimate of the Population mean = 1.603 However, the sample variance is a biased estimator of the population variance. To convert this to an unbiased estimator, this method was used;

  1. Anthropometric Data

    On the scatter graph the (y) versus the corresponding values of (x). On the vertical axis which is (y) is usually responding variable and the horizontal axis which is (x) which relate to the response. A scatter will be drawn to identify any outliers which mean any anomalous result that may look far out from the region.

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

  1. Used Cars - What main factor that affects the price of a second hand ...

    I will only use 50 cars in this investigation as I feel that this is enough to get a good outcome from. If the sample I take is too big it will be too had to work with and if the sample is to small then I won't get I reliable outcome.

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

    Repeat method on the middle shore, recording the data in tables, as you work. Examples of the tables are shown below: To record ACFOR coverage on each area of the shore; Quadrat number Species ACFOR coverage 1 To record length of frond and number of bladders on each area of the shore; Quadrat number Length of frond (cm)

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