Excel data mining skills.

Brief summary: There are 15(?) errors/anomalies in the attached worksheet - one is major, the rest relatively minor.

Spark: How many errors/anomalies can you find in the postcode data?

Individual contribution: Apply your data mining skills (sort and other functions) to find the errors/anomalies.

Uploadyour response(includingapproach)

Submission format:Word document

To learn more about Excel functions please goto:https://support.office.com/en-us/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

Suburb Throssell Desert Springs University of Melbourne University of Wollongong Embleton Hawkwood Curban Suntop Orrivale Fitzgibbon Kulwin Zetland Hackett Palmerston Nowie Broadmere Kaarimba Verona Sands Jilpanger Ebenezer Lyndob Flowerdale Broke Pine Creek Seabrook Sinclair Spearwood Warrong Acacia Hills Glenfern Surveyors Bay Dee Cossack Sargood Samson Gritjurk Dulcot Tingledale Chichester Jardine Kaltukatjara Wattle Flat Desailly Smithtown Wagstaffe Wareemba Tannymorel State WA NT Vic NSW WA Qld NSW NSW Vic Qld NSW NSW ACT NT Vic Qld Vic Tas Vic Qld WA Tas WA NT Vic WA WA Vic Tas Tas Tas Tas WA Vic WA Vic Tas WA NSW Qld NT NSW Qld NSW NSW NSW Qld Postcode 6401 0870 3010 2522 6062 4626 2827 2820 3631 4018 2835 2017 2602 0830 3585 4420 3635 7112 3409 4340 6701 7325 6398 0847 3028 6450 6163 3283 7306 7140 7116 7140 6720 3858 6163 3315 7025 6333 2420 4702 0872 2795 4871 2440 2257 2046 4372 White Gums Lake Muir Woodbridge Mole Creek Sorell Girvan Warrane Duchess Bream Creek Clandulla Oatlands Dunkeld Tregeagle Stewarts Brook Bermagui Drysdale Cadgee Ouse Westbury Simmie Coolalinga Irlpme Exmouth Kalbarri Wellcamp Mingenew Wellard Miles Molesworth Fannie Bay Koonya Trebonne Woodlands Darley Harston Breakfast Creek Kilkivan Goulburn Island Yarck Rosella Nooroo Brassall Wonbah Latham Punchbowl Longlea Keera Dundee Beach NY WA Tas Tas Tas NSW Tas Qld Tas NSW Tas Vic NSW NSW NSW Vic NSW Tas Tas Qld NT NT WA WA Qld WA WA Qld Vic NT Tas Qld WA Vic Vic NSW Qld NT Vic Qld NSW Qld Qld ACT Tas Vic NSW NT 0870 6258 7162 7304 7172 2425 7018 4825 7175 2848 7120 3294 2480 2337 2546 3222 2545 7140 7303 4454 0839 0874 6707 6536 4650 6522 6170 4415 3718 0820 7187 4850 6018 3340 3616 2849 4600 0822 3719 4740 2415 4305 4671 2615 7249 3551 2404 0840 Kensignton Woolooma Stuart Higgins Kambah Marybrook Zillmere Two Rocks Seal Rocks Tolmans Hill Florey Edgeroi Black Snake Kirup Saxby Exford Copping Timor Mataranka Wee Jasper Binduli Wattle Hill Septimus Casuarina Joyner Chigwell Jeir Woodpark Kimbolton Wattle Camp Kippenduff Neika Virginia Rhyll Smoko Dysart Barton Larapinta Aberdeen Cragie Fisher Bowenvale Orallo Kamona Stanhope Brit Brit Lota Paynedale WA NSW NT ACT ACT WA Qld WA NSW Tas ACT NSW Qld WA Qld Vic Tas Vic NT NSW WA Tas Qld NSW Qld Tas NSW NSW WA Qld NSW Tas NT Vic Vic Tas ACT NT Tas Vic ACT Vic Qld Tas NSW Vic Qld WA 6151 2337 0780 2615 2902 6280 4034 6037 2423 7007 2615 2390 4600 6251 4822 3338 7174 3465 0852 2582 6430 7172 4754 2487 4500 7011 2582 2164 6728 4615 2469 7054 0834 3923 3471 7030 2600 0875 7310 3465 2611 3465 4455 7260 2335 3315 4179 6238 Cleveland Buckenderra Kinleymore Yambacoona Two Mile Sandfly Vernor Blackwall Tyers Palgarup Wagin Hilldale Duffy Boobyalla Wakerley Wingaroo Milabena Tivoli Harvey Hazeldean Villeneuve Pomona Kettering Jiggi Clifton Wallup Wog Wog Kowden Cooree Whitebridge Tranmere Calvert Lockridge Dundas Youndegin Nullamanna Marrickville Burswood Bruce Officer Whitebridge Broadway Stewarton Kalang Alice Springs Swan View Bassendean Nirimba Tas NSW Qld Tas Qld Tas Qld Tas Vic WA WA NSW ACT Tas Qld Tas Tas Qld WA Qld Qld NSW Tas NSW WA Vic NSW ACT ACT NSW Tas Qld WA WA WA NSW NSW WA ACT Vic NSW NSW Qld NSW NT WA NSW WA 7211 2630 4613 7256 4570 7150 4306 7275 3844 6258 6315 2420 2611 7264 4154 7255 7325 4305 6220 4741 4514 2648 7155 2480 6211 3401 2622 2620 2611 2290 7018 4340 6054 6443 6407 2360 2204 6100 2617 3809 2290 2581 4702 2454 0870 6056 2365 6208 Taranna Rothsay Gordon Hindmarsh Ryansbrook Puckapunyal Grantville Chittering Bushfield Blessington Dumaresq Solus Lake Boga Cherokee Tittybong Towan Mayberry Popanyinning Umbakumba Paradise Point Wildash Waratah Waddamana Royston Nakara Buxton Lowlands Lyons Nungarin Greenup Westby Samsonvale Rosetta Tamboon Chorregon Budgeree Borroloola Grogan Gunyidi Tatyoon Moondarra Ali Curung Lake Proserpine Cooma Stafford Henrietta Tucki Tucki Mole River Tas WA ACT WA WA Vic Vic WA Vic Tas NSW WA Vic Vic Vic Vic Tas WA NT Qld Qld Tas Tas Qld NT Qld WA NT WA Qld Vic Qld Tas Vic Qld Vic NT NSW WA Vic Vic NT Qld NSW Qld Tas NSW NSW 7180 6620 2906 6462 6395 3662 3984 6084 3281 7212 2350 6207 3584 3434 3542 3596 7304 6309 0822 4216 4370 7321 7030 4515 0810 4660 6330 0810 6490 4387 3579 4520 7010 3890 4730 3870 0854 2666 6513 3378 3825 0872 4800 2630 4053 7325 2480 2372 Bicheno Copley Shannonvale Edith Creek Gray Branditt Cowa Cashmore Mila White Peak Bonython Beckom Flynn Santa Teresa Stirling Promisedland Fumina Queentown Humpty Doo Action Park Yundool Repton Tallandoon Fyshwick Kithbrook Deepwater Pleystowe Terara Woolooga Ultima Lucknow Forcett Rushy Lagoon Kaniva Kemmis Sunny Nook Brentwood Swan Reach Sheffield Nicholson Baynton Quirindi Indi Taabinga Corinella Jackitup Warenda Cook Tas WA Vic Tas NT Vic Vic Vic NSW WA ACT NSW Vic NT WA Qld Vic Qld NT WA Vic NSW Vic ACT Vic NSW Qld NSW Qld Vic Vic Tas Tas Vic Qld Qld WA Vic Tas Vic WA NSW NSW Qld NSW WA Qld ACT 7215 6562 3898 7330 0830 3630 3862 3305 2632 6532 2905 2665 3844 0872 6021 4660 3825 4820 0836 6280 3727 2454 3701 2609 3666 2371 4741 2540 4570 3544 3875 7173 7264 3419 4742 4605 6153 2903 7305 3882 6714 2343 2642 4610 2871 6335 4829 2614 Stromlo Fairndale Illowa Rangeview Plenty Gregory Sidmouth Macksville Wattle Bank Kamona Whitebridge Koongal Cremorne Hedley Yambulla Useless Loop Darkan Chifley Batesford Ramingining Tharwa White Hills Possum Brush Garbutt Berrimah Belconnen White Rock Lewisham Helen Springs Station Nook Uduc Ellendale Weegena Chapman Rassmussen Quedjinup Federal Casuarina Waterbank Sharon Thirlstane Farnham Quamby Bend Crace Denmark Wongoondy Koonya Viveash ACT Qld Vic Vic Tas WA Tas NSW Vic Tas NSW Qld Qld Vic NSW WA WA ACT Vic NT ACT Tas NSW Qld NT ACT NSW Tas NT Tas WA Tas Tas ACT Qld WA Qld NT WA Qld Tas NSW Tas ACT WA WA Tas WA 2611 4606 3282 3132 7140 6535 7270 2447 3995 7260 2290 4701 4740 3967 2550 6537 6392 2606 3213 0822 2620 7258 2430 4814 0828 2617 2795 7173 0852 7302 6220 7140 7304 2611 4815 6281 4568 0810 6725 4670 7308 2820 7292 2911 6333 6630 7187 6056 Smithton Sulky Trigwell Calwell Blackbutt South Hawker Xantippe Yalboroo Shalvey Oaklands Wattle Grove Churchable Yaapeet Pawtella Kurraca Glenlynn Bushy Park Murrah Spence Watalgan Kerang Tullah Edgewater Rivett Lake Hiawatha Aarons Pass Tiwi Bronte Park Cairns Bay Tannabar Kahibah Runnymede Paddy's River Vasey Ningi Talisker York Plains Tolland Yathella Lake Leake Waterhouse Woodend Mollerin Ranford Kempton Benwerrin Ebenezer University of Queensland Tas Vic WA ACT Qld ACT WA Qld NSW NSW WA Qld Vic Tas Vic WA Tas NSW ACT Qld Vic Tas WA ACT NSW NSW NT Tss Tas NSW NSW Vic ACT Vic Qld WA Tas NSW NSW Tas Tas Qld WA WA Tas Vic NSW Qld 7330 3352 6244 2905 4306 2614 6609 4741 2770 2646 6107 4311 3424 7120 3518 6256 7140 2546 2615 4670 3579 7321 6027 2611 2462 2850 0810 7140 7116 2357 2290 3558 2620 3407 4511 6701 7120 2650 2650 7210 7262 4305 6475 6390 7030 3235 2756 4072 Dumbarton Burnie Whitsundays Wild Dog Valley Muldu Eddystone Boulia Echuca Grove Applecross Chisolm Wyening Jilpanger Bellamack Ulverstone Sprent Cable Beach Woodford Forbes Booral Gulliver Queenscliff Judbury Waroona Scaddan Steiglitz Bobalong Jericho Elmhurst Ranelagh Mincha Pinjarra Farrar Wareek Kurrenkutten Oxley Vinifera Summerland Point Wishart Tewantin Burwood Heights Inglewood Jurian Bay Moondah Winnellie Abbotsford Raby Isaacs WA Tas Qld Vic Qld Tas Qld Vic Tas WA ACT WA Vic NT Tas Tas WA Vic NSW Qld Qld Vic Tas WA WA Vic WA Tas Vic Tas Vic WA NT Vic WA ATC Vic NSW Vic Qld NSW WA AW WA NT Qld NSW ACT 6566 7320 4802 3953 4401 7264 4829 3564 7109 6153 2905 6568 3409 0832 7315 7315 6726 3281 2871 4655 4812 3225 7109 6215 6447 3331 6320 7030 3469 7109 3575 6208 0830 3465 6375 2903 3591 2259 3189 4565 2136 6052 6516 6503 0820 4670 2566 2607 Pioneer Tyenna Kyoomba Talbingo Aberfeldie O'Connor Turner Molendinar Knockwood Boonanarring Evatt Numbulwar Berrico Ridgelands Pastoria Wonthaggi Cygnet Linthorpe Amaroo Longford Taunton Red Hill Pimlico Scopus Shoreham Tammin Jabiru Blackwall Ulogie Kilgariff Lindenow Petrie Wynyard Jimboola Hammondville Kanya Gretna Wilson Wedgefield Oroton Park Calrossie Uriarra Village Tardun Downer Braddon Lyons Innisfail Serpentine Tas Tas Qld NSW Vic ACT ACT Qld Vic WA ACT NT NSW Qld Vic Vic Tas Qld ACT Tas Qld ACT NSW Tas Vic WA NT NSW Qld NT Vic Qld Tas Qld NSW Vic Tas WA WA NSW Vic ACT WA ACT ACT ACT Qld Vic 7264 7140 4380 2720 3040 2602 2612 4214 3723 6503 2617 0822 2422 4702 3444 3995 7112 4356 2914 7301 4674 2603 3478 7330 3916 6409 0886 2256 4702 0873 3865 4502 7325 4280 2170 3387 7140 6107 6721 2795 3971 2611 6628 2602 2612 2606 4860 3517 Coorada Greenthorpe Lorne Bellbowrie Valentine Oakhurst Benarkin Jericho Williamsdale Whitaker Fentonbury Uki Karama Rowan Uxbridge Eagleton Dundee Kitoba Blanchview Twelve Mile Symonston Boodarockin Marthavale Purnululu Taroona Beverley Rostron Tully Beacon Hill Nabawa Jacka Percydale Leichhardt Glendonald Connellan Yulara Boorolite Pan Ban Gabbin Eidsvold Johnston Neerdie Blackheath Fairy Dell Winfield Whoorel Boyer Bucca Qld NSW NSW Qld NSW Qld Qld Tas ACT WA Tas NSW NT NSW Tas NSW NSW WA Qld NSW ACT WA Vic WA Tas WA Vic Qld NSW WA ACT Vic NSW Vic NT NT Vic NSW WA Qld NT Qld Vic Vic Qld Vic Tas Qld 4420 2809 2439 4070 2280 4650 4306 7030 2620 6207 7140 2484 0812 2650 7140 2324 2370 4605 4352 2850 2609 6423 3875 6770 7053 6304 3477 4854 2100 6532 2914 3478 2040 3364 0873 0872 3723 2648 6476 4627 0832 4570 3401 3875 4670 3243 7140 4670 Seppings Werrimull Talawa Kingsford Vasse Casuarina Joondanna Cawdor Clarendon Elanora Picola Remlap Warroo Leeka Cranbrook Berry Jerry Musk Ferguson Callwell Nowhere Else Lackrana Saratoga Myalla Birchs Bay Sulphur Creek Roseberry Oakajee Zuytdorp Sadeen Acton Moonbah Flint Summerholm Milner Treeton Hastings Moondooner Takalarup Fullerton Wycheproof Rosemeadow Ridgley Brinkin Lucinda Bullfinch Meadowbrook Abbotsford Condor WA Vic Tas NSW WA WA WA Qld Vic Qld Vic WA NSW Tas Tas NSW Vic WA ACT Tas Tas NSW Tas Tas Tas NT WA WA NT AT NSW WA Qld NT WA Tas Qld WA NSW Vic NSW Tas NT Qld WA Qld Vic ACT 6330 3496 7263 2032 6280 6167 6060 4352 3352 4221 3639 6472 2871 7255 7190 2701 3461 6236 2905 7305 7255 2251 7325 7162 7316 0832 6532 6536 0870 2601 2627 6302 4341 0810 6284 7109 4605 6324 2583 3527 2560 7321 0810 4850 6484 4131 3067 2906 Wiltshire Singleton Villawood Wyena Telarah Kareela Cooma Currimundi Nyirripi Kabra Tuerong Glenorchy White Mountain Torrens Caveside Baynton Tas NSW NSW Tas NSW NSW Vic Qld NT Qld Vic Qld Qld ACT Tas Vic 7321 2330 2163 7254 2320 2232 3616 4551 0872 4702 3915 4650 4352 2607 7304 3444