For the following assignment, minimal data cleansing will be required. However, some ingenuity and research may be required to find a meaningful groupings of the values in "County" into 4-6 sets.
To arrive at this grouping, rely on both researchwithinthis dataset, as well as substantive research outside of it. Describe your process for data exploration, and how you iterate between discoverieswithinthe dataset, combined with substantive research on Ireland and these geographies.
After settling on your grouping, give an overview of some of your most interesting findings.
please submit your R code, and a report with a condensed (i.e.:brief!) overview of your conclusions about the housing market in Ireland in January 2020. Use the file name conventions as stipulated earlier.
- References need to be formatted in accordance with APA standards
- Choose relevant applications of the t-test in your output, that illustrate and/or underscore your discoveries
- Justify where dependent or independent t-tests out to be used, and explain how you arrived at that choice with reference to Bluman.
Submit your report and R code, and do not worry about the exclamation mark warning you will receive.
Date of Sale (dd/mm/yyyy),Address,Postal Code,County,Price (€),Not Full Market Price,VAT Exclusive,Description of Property 01/01/2020,"APT 1 LEE HOUSE, STRAND LANE THE QUAY, CARRICK ON SUIR",,Tipperary,"€120,000.00",No,No,Second-Hand Dwelling house /Apartment 01/01/2020,"Lands at Cliffor'd Field, Treanoughtragh, Glenbeigh",,Kerry,"€248,681.00",No,Yes,New Dwelling house /Apartment 01/01/2020,"ROSSACOOSANE, TEMPLENOE, KENMARE",,Kerry,"€450,000.00",No,No,Second-Hand Dwelling house /Apartment 01/01/2020,"Site 4, Clifford's Field, Treanoughtragh",,Kerry,"€286,950.00",No,Yes,New Dwelling house /Apartment 02/01/2020,"105 DONAGHMORE, THE ANCHORAGE, BETTYSTOWN",,Meath,"€125,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"109 Cedar Walk, Castleoaks, Dublin Road",,Carlow,"€211,410.00",No,Yes,New Dwelling house /Apartment 02/01/2020,"11 OAK GLADE COURT, BLESSINGTON RD, NAAS",,Kildare,"€204,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"12 WHITECLIFF, WHITECHURCH RD, RATHFARNHAM DUBLIN 16",Dublin 16,Dublin,"€565,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"125 MILL TOWN HALL, MT ST ANNES, MILLTOWN",Dublin 6,Dublin,"€588,500.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"13 BLOCK C, THE HARBOUR, CANAL SIDE",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"15 BLOCK C, THE HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"16 BLOCK C, THE HARBOUR CANALSIDE, ATHY",,Kildare,"€52,500.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"16 CHERRY DR, GLENCAIRIN, DOORADOYLE",,Limerick,"€242,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"16 Marlmount Walk, Dundalk",,Louth,"€233,481.00",No,Yes,New Dwelling house /Apartment 02/01/2020,"16 STRATFORD HAVEN, RATHGAR, DUBLIN 6",Dublin 6,Dublin,"€232,500.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"17 BLOCK C, THE HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"18 OAKWOOD RETIREMENT VILLAGE, HAWTHORN DRIVE, ROSCOMMON",,Roscommon,"€55,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"20 ST EITHNE ROAD, CABRA, DUBLIN 7",,Dublin,"€360,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"22 Athlumney Close, Kentstown Road, Navan",,Meath,"€259,911.00",No,Yes,New Dwelling house /Apartment 02/01/2020,"26 WATERVILLE HOLIDAY HOMES, WATERVILLE, KERRY",,Kerry,"€138,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"3 The Orchard, Gleann Ull, Ballyhooly",,Cork,"€220,264.32",No,Yes,New Dwelling house /Apartment 02/01/2020,"30 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"32 THE BLOCK C, THE HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"34 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"4 Belarmine View, Belarmine Woods, Stepaside",,Dublin,"€555,066.07",No,Yes,New Dwelling house /Apartment 02/01/2020,"41 Fairhaven Avenue, Castleknock Road, Castleknock",,Dublin,"€660,000.00",No,Yes,New Dwelling house /Apartment 02/01/2020,"44 CASTLE FALLS, ROSS RD, KILLARNEY",,Kerry,"€285,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"47 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"48 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€45,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"49 BLOCK C, HARBOUR, CANALSIDE",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"5 WILLIAM BECKETT HOUSE, PEMBROKE ROW, DUBLIN",Dublin 2,Dublin,"€624,600.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"50 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€52,500.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"51 BLOCK C, HARBOUR CANALSIDE, ATHY",,Kildare,"€40,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"53 Cnoc Tiarnach, Grange End, Dunshaughlin",,Meath,"€339,207.05",No,Yes,New Dwelling house /Apartment 02/01/2020,"53 INIS CLAIR, KILDYSART RD, CLARECASTLE",,Clare,"€205,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"7 HAYDENS PARK DR, LUCAN, DUBLIN",,Dublin,"€478,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"7 MAPLEWOOD RD, SPRINGFIELD, TALLAGHT DUBLIN 24",Dublin 24,Dublin,"€208,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"99 RIVERSIDE, PORTARLINGTON, OFFALY",,Offaly,"€58,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"APARTMENT 311, SWIFTWOOD DEVELOPMENT, SAGGART",,Dublin,"€250,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"APT 2 STOCKWELL CLOSE, STOCKWELL ST, DROGHEDA",,Louth,"€100,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"CASTLEREAGH, BALLYMACARBERY, WATERFORD",,Waterford,"€160,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"GRAIGUE, NEW ROAD, MOUNTMELLICK",,Laois,"€168,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"KILADEN, DRUMCONRATH, NAVAN",,Meath,"€100,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"KILLUPPAN AHASCRAGH, BALLINASLOE, GALWAY",,Galway,"€64,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"MILL RD, KINLOUGH, LEITRIM",,Leitrim,"€180,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"NANOOK, CASTLEFARM, MONKSTOWN",,Cork,"€365,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"SHALVEY, KILCAR, DONEGAL",,Donegal,"€60,000.00",No,No,Second-Hand Dwelling house /Apartment 02/01/2020,"THE COTTAGE, BARRACK STREET, TALLOW",,Waterford,"€63,750.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"1 CHAPEL VIEW, LUCAN, DUBLIN",,Dublin,"€250,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"1 LAUREL COURT, LOUGHBOY, KILKENNY",,Kilkenny,"€193,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"1 Millquarter, Knockmullen, Gorey",,Wexford,"€309,493.00",No,Yes,New Dwelling house /Apartment 03/01/2020,"126 BALLINTEER CLOSE, BALLINTEER, DUBLIN 16",Dublin 16,Dublin,"€640,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"134 SLI GHEAL BALLYMONEEN RD, GALWAY",,Galway,"€275,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"144 WEST AVE, PARKGATE, FRANKFIELD",,Cork,"€91,104.32",Yes,No,Second-Hand Dwelling house /Apartment 03/01/2020,"15 Maydenhayes Crescent, Mornington, Co Meath",,Meath,"€300,881.06",No,Yes,New Dwelling house /Apartment 03/01/2020,"16 BRUACH NO SIONNA, O'BRIENS BRIDGE, CO CLARE",,Clare,"€102,500.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"16 FATHER FLOOD PARK, DUNDERRY, NAVAN",,Meath,"€150,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"17 INNISHMAAN RD, GAELTACHT PARK, WHITEHALL DUBLIN 9",Dublin 9,Dublin,"€266,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"17 THE WILLOWS, CLOONBALT, LONGFORD",,Longford,"€140,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"19 Proby Place Proby Square, Carysfort Avenue, Blackrock",,Dublin,"€881,057.27",No,Yes,New Dwelling house /Apartment 03/01/2020,"19 WASHINGTON COURT, CORK, CORK",,Cork,"€225,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"2 ASHE ROAD, SHANTALLA, GALWAY",,Galway,"€270,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"20 SWIFTBROOK PARK, TALLAGHT, DUBLIN 24",Dublin 24,Dublin,"€140,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"21 MERRION VIEW AVE, MERRION RD, DUBLIN 4",Dublin 4,Dublin,"€1,030,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"27 RAVENSDALE RD, EAST WALL, DUBLIN 3",Dublin 3,Dublin,"€310,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"28 LAKEVIEW, VIRGINIA, CAVAN",,Cavan,"€185,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"29 STATIONCOURT PARK, COOLMINE, DUBLIN 15",Dublin 15,Dublin,"€277,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"3 KILDERMOT LANE, BALLYMONEY, GOREY",,Wexford,"€350,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"31 The Grove, St. Marnocks Bay, Station Road",,Dublin,"€308,370.00",No,Yes,New Dwelling house /Apartment 03/01/2020,"32 CASTLEWOOD PARK, KILLERISK, TRALEE",,Kerry,"€170,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"33 CASTLEWELL, SOUTH CIRCULAR ROAD, LIMERICK",,Limerick,"€290,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"38 CARRAIG ABHAINN, BALLISODARE, CO SLIGO",,Sligo,"€210,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"38 CHESTNUT AVE, ESKER HILLS, PORTLAOISE",,Laois,"€190,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"39 WOODVIEW, ASHFORD, WICKLOW",,Wicklow,"€190,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"4 BALLYBRIT COURT, MONIVEA RD, GALWAY",,Galway,"€250,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"4 CLUAIN OIR, MONAMOLIN, GOREY",,Wexford,"€140,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"49 KINGS HILL, NEWPORT RD, WESTPORT",,Mayo,"€220,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"5 DUNMORE, THE HEADLANDS, SARSFIELD RD",,Cork,"€185,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"5 MARLAY VIEW, BALLINTEER AVE, DUBLIN 16",Dublin 16,Dublin,"€335,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"53 RAVENSWOOD, GREGG ROAD, CARRICK ON SUIR",,Tipperary,"€128,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"66 COOLMINE PARK, CLONSILLA, DUBLIN 15",Dublin 15,Dublin,"€330,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"7 Oak Park Green, Oak Park, Craddockstown",,Kildare,"€288,545.36",No,Yes,New Dwelling house /Apartment 03/01/2020,"83 MERRION PARK, BOOTERSTOWN, DUBLIN",,Dublin,"€545,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"97 BISHOPSWATER, WEXFORD, WEXFORD",,Wexford,"€120,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"APT 17, CHAPEL COURT, CLAREMORRIS",,Mayo,"€75,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"APT 2, BLOCK 22 RAILWAY RD, CLONGRIFFIN DUBLIN 13",Dublin 13,Dublin,"€137,966.87",Yes,No,Second-Hand Dwelling house /Apartment 03/01/2020,"BALLYLIBERNAGH, BALLYCOGLEY, WEXFORD",,Wexford,"€145,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"CLOUGHGLASS, BURTONPORT, CO DONEGAL",,Donegal,"€87,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"COTTAGE, SHEEPGRANGE TULLYALLEN, DROGHEDA",,Louth,"€50,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"DRUMMALLAGHT, NEW INNS, BALLYJAMESDUFF",,Cavan,"€27,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"GRAIGUES, ROBERTSTOWN, NAAS",,Kildare,"€535,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"GROVE, CUFFESGRANGE, KILKENNY",,Kilkenny,"€120,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"GUBNAHARDIA, CURRANE, ACHILL",,Mayo,"€150,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"KILLANLEY LODGE, KILLANLEY, BALLINA",,Sligo,"€330,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"MOY, KINVARA, GALWAY",,Galway,"€345,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"MULLAVALLEY, LOUTH VILLAGE, DUNDALK",,Louth,"€205,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"RATHNACREEVA, BALLYGLASS, CLAREMORRIS",,Roscommon,"€57,500.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"REEN, BALLINSKELLIGS, CO KERRY",,Kerry,"€240,000.00",No,No,Second-Hand Dwelling house /Apartment 03/01/2020,"SEACH MOR HOUSE, BELCRUIT MEENBANAD, BURTONPORT",,Donegal,"€83,000.00",No,No,Second-Hand Dwelling house /Apartment 04/01/2020,"12 The Lane, Whitefield Manor, Bettystown",,Meath,"€259,911.89",No,Yes,New Dwelling house /Apartment 06/01/2020,"1 FOYLE VIEW APTS, BATH