Topic: summarizing and visualizing data
Use the HP_LONDON_JAN19.xlsx file to generate Table 1.
Table 1
Summary statistics properties sold in London in January
2019
TYPE | COUNT | AVERAGE | MEDIAN | SD | PERC_ABOVE_1mln |
|---|---|---|---|---|---|
FLAT | 782 | 592,700 | 445,000 | 612,700 | 9.1 |
DETACHED | 37 | 1,498,800 | 1,250,000 | 873,100 | 62.2 |
SEMI-DETACHED | 125 | 982,200 | 805,000 | 642,400 | 32.8 |
TERRACED | 442 | 876,100 | 630,000 | 919,700 | 23.5 |
Note. Average, median and standard deviation (SD) are in GB Pounds. The last column gives the percentages of properties sold with a selling price above 1 mln GPB. Underlying data are retrieved from http://landregistry.data.gov.uk/app/ppd/.