Thank you very much for taking the time to look at my question, attached below is the details

Hanna has been offered a position by one of WAs mining companies. She is required to relocate from Brisbane (where she currently resides) to Perth. Hanna has been actively looking for a house to rent. She has managed to acquire a list of 111 houses that are currently listed for rent in six suburbs contained in file named Residential_Real_Estate. Her friend has told her that, her two preferred suburbs are among the most expensive suburbs to rent. However, Hanna is not convinced. Your Tasks: Use contingency tables to conduct an appropriate test to settle an argument between Hanna and her friend regarding a relationship between suburbs and rental prices at the 1% level of significance.

Case Study 3: Hanna has been offered a position by one of WAs mining companies. She is required to relocate from Brisbane (where she currently resides) to Perth. Hanna has been actively looking for a house to rent. She has managed to acquire a list of 111 houses that are currently listed for rent in six suburbs contained in file named Residential_Real_Estate. Her friend has told her that, her two preferred suburbs are among the most expensive suburbs to rent. However, Hanna is not convinced. Your Tasks: Use contingency tables to conduct an appropriate test to settle an argument between Hanna and her friend regarding a relationship between suburbs and rental prices at the 1% level of significance. 15 1 Four Bedroom House Rental prices 2 Property Address Suburb 3 1 Chapman Road Bentley 4 2 Marquis Street Bentley 5 3 Pollock Street Bentley 6 4 Whiby Court Bentley 7 5 Queen Street Bentley 8 6 Sill Street Bentley 9 7 Ashburton Street Bentley 10 8 Pusey Street Bentley 11 9 Marquis Street Bentley 12 10 Farnham Street Bentley 13 11 Waterway Court Churchlands 14 12 Selby Street Churchlands 13 Falcon Avenue Churchlands 16 14 Coneflower Corner Churchlands 17 15 Waterway Court Churchlands 18 16 Whelan Road Kardinya 17 The Mews Kardinya 20 18 Ochiltree Way Kardinya 21 19 Bersica Court Kardinya 22 20 Kardinya Road Kardinya 23 21 South Street Kardinya 24 22 Pinewood Avenue Kardinya 25 23 Munns Place Kardinya 26 24 Railway Avenue Kelmscott 27 25 Third Avenue Kelmscott 28 26 Ryland Road Kelmscott 29 27 Steve Street Kelmscott 30 28 Canning Mills Road Kelmscott 31 29 Arbour Place Kelmscott 32 30 Gell Court Kelmscott 33 31 Possum Place Kelmscott Rental price ($ 480 420 480 450 600 460 450 550 400 480 360 480 850 900 360 1,025 580 360 470 500 350 365 895 395 350 370 380 560 325 450 490 00 19 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 32 Clifton Street Nedlands 33 The Avenue Nedlands 34 Monash Avenue Nedlands 35 Tyrell Street Nedlands 36 Waroonga Road Nedlands 37 Megalong Street Nedlands 38 Dalkeith Road Nedlands 39 Mountjoy Road Nedlands 40 Williams Road Nedlands 41 Harrison Street Rockingham 42 Apus Close Rockingham 43 Emma Street Rockingham 44 Epsilon Street Rockingham 45 Ritchie Drive Rockingham 46 Rockingham Beach Road Rockingham 47 Smythe Street Rockingham 48 Roscoe Turn Rockingham 49 Epsilon Drive Rockingham 50 Jecks Street Rockingham 51 Parkin Street Rockingham 52 Merope Close Rockingham 53 Orizaba Place Rockingham 54 Chapman Road Bentley 55 Marquis Street Bentley 56 Pollock Street Bentley 57 Whiby Court Bentley 58 Queen Street Bentley 59 Sill Street Bentley 60 Ashburton Street Bentley 61 Pusey Street Bentley 750 1,200 700 1,550 750 580 780 1,500 850 300 330 600 420 550 690 450 400 400 360 490 290 400 480 420 480 450 600 460 450 550 64 65 66 67 68 69 ZO 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 62 Marquis Street 63 Farnham Street 64 Waterway Court 65 Selby Street 66 Falcon Avenue 67 Coneflower Corner 68 Waterway Court 69 Whelan Road 70 The Mews 71 Ochiltree Way 72 Bersica Court 73 Kardinya Road 74 South Street 75 Pinewood Avenue 76 Munns Place 77 Railway Avenue 78 Third Avenue 79 Ryland Road 80 Steve Street 81 Canning Mills Road 82 Arbour Place 83 Gell Court 84 Possum Place 85 Clifton Street 86 The Avenue 87 Monash Avenue 88 Tyrell Street 89 Waroonga Road 90 Megalong Street 91 Dalkeith Road Bentley Bentley Churchlands Churchlands Churchlands Churchlands Churchlands Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Nedlands Nedlands Nedlands Nedlands Nedlands Nedlands Nedlands 400 480 360 480 850 900 360 1,025 580 360 470 500 350 365 895 395 350 370 380 560 325 450 490 750 1,200 700 1,550 750 580 780 1,500 850 300 330 600 420 550 690 450 400 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109) 110 111 112 113 92 Mountjoy Road Nedlands 93 Williams Road Nedlands 94 Harrison Street Rockingham 95 Apus Close Rockingham 96 Emma Street Rockingham 97 Epsilon Street Rockingham 98 Ritchie Drive Rockingham 99 Rockingham Beach Road Rockingham 100 Smythe Street Rockingham 101 Roscoe Turn Rockingham 102 Epsilon Drive Rockingham 103 Jecks Street Rockingham 104 Parkin Street Rockingham 105 Merope Close Rockingham 106 Orizaba Place Rockingham 107 Orizaba Place Rockingham 108 Waterway Court Churchlands 109 Selby Street Churchlands 110 Falcon Avenue Churchlands 111 Coneflower Corner Churchlands 400 360 490 290 400 400 650 600 590 660 Case Study 3: Hanna has been offered a position by one of WAs mining companies. She is required to relocate from Brisbane (where she currently resides) to Perth. Hanna has been actively looking for a house to rent. She has managed to acquire a list of 111 houses that are currently listed for rent in six suburbs contained in file named Residential_Real_Estate. Her friend has told her that, her two preferred suburbs are among the most expensive suburbs to rent. However, Hanna is not convinced. Your Tasks: Use contingency tables to conduct an appropriate test to settle an argument between Hanna and her friend regarding a relationship between suburbs and rental prices at the 1% level of significance. 15 1 Four Bedroom House Rental prices 2 Property Address Suburb 3 1 Chapman Road Bentley 4 2 Marquis Street Bentley 5 3 Pollock Street Bentley 6 4 Whiby Court Bentley 7 5 Queen Street Bentley 8 6 Sill Street Bentley 9 7 Ashburton Street Bentley 10 8 Pusey Street Bentley 11 9 Marquis Street Bentley 12 10 Farnham Street Bentley 13 11 Waterway Court Churchlands 14 12 Selby Street Churchlands 13 Falcon Avenue Churchlands 16 14 Coneflower Corner Churchlands 17 15 Waterway Court Churchlands 18 16 Whelan Road Kardinya 17 The Mews Kardinya 20 18 Ochiltree Way Kardinya 21 19 Bersica Court Kardinya 22 20 Kardinya Road Kardinya 23 21 South Street Kardinya 24 22 Pinewood Avenue Kardinya 25 23 Munns Place Kardinya 26 24 Railway Avenue Kelmscott 27 25 Third Avenue Kelmscott 28 26 Ryland Road Kelmscott 29 27 Steve Street Kelmscott 30 28 Canning Mills Road Kelmscott 31 29 Arbour Place Kelmscott 32 30 Gell Court Kelmscott 33 31 Possum Place Kelmscott Rental price ($ 480 420 480 450 600 460 450 550 400 480 360 480 850 900 360 1,025 580 360 470 500 350 365 895 395 350 370 380 560 325 450 490 00 19 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 32 Clifton Street Nedlands 33 The Avenue Nedlands 34 Monash Avenue Nedlands 35 Tyrell Street Nedlands 36 Waroonga Road Nedlands 37 Megalong Street Nedlands 38 Dalkeith Road Nedlands 39 Mountjoy Road Nedlands 40 Williams Road Nedlands 41 Harrison Street Rockingham 42 Apus Close Rockingham 43 Emma Street Rockingham 44 Epsilon Street Rockingham 45 Ritchie Drive Rockingham 46 Rockingham Beach Road Rockingham 47 Smythe Street Rockingham 48 Roscoe Turn Rockingham 49 Epsilon Drive Rockingham 50 Jecks Street Rockingham 51 Parkin Street Rockingham 52 Merope Close Rockingham 53 Orizaba Place Rockingham 54 Chapman Road Bentley 55 Marquis Street Bentley 56 Pollock Street Bentley 57 Whiby Court Bentley 58 Queen Street Bentley 59 Sill Street Bentley 60 Ashburton Street Bentley 61 Pusey Street Bentley 750 1,200 700 1,550 750 580 780 1,500 850 300 330 600 420 550 690 450 400 400 360 490 290 400 480 420 480 450 600 460 450 550 64 65 66 67 68 69 ZO 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 62 Marquis Street 63 Farnham Street 64 Waterway Court 65 Selby Street 66 Falcon Avenue 67 Coneflower Corner 68 Waterway Court 69 Whelan Road 70 The Mews 71 Ochiltree Way 72 Bersica Court 73 Kardinya Road 74 South Street 75 Pinewood Avenue 76 Munns Place 77 Railway Avenue 78 Third Avenue 79 Ryland Road 80 Steve Street 81 Canning Mills Road 82 Arbour Place 83 Gell Court 84 Possum Place 85 Clifton Street 86 The Avenue 87 Monash Avenue 88 Tyrell Street 89 Waroonga Road 90 Megalong Street 91 Dalkeith Road Bentley Bentley Churchlands Churchlands Churchlands Churchlands Churchlands Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kardinya Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Kelmscott Nedlands Nedlands Nedlands Nedlands Nedlands Nedlands Nedlands 400 480 360 480 850 900 360 1,025 580 360 470 500 350 365 895 395 350 370 380 560 325 450 490 750 1,200 700 1,550 750 580 780 1,500 850 300 330 600 420 550 690 450 400 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109) 110 111 112 113 92 Mountjoy Road Nedlands 93 Williams Road Nedlands 94 Harrison Street Rockingham 95 Apus Close Rockingham 96 Emma Street Rockingham 97 Epsilon Street Rockingham 98 Ritchie Drive Rockingham 99 Rockingham Beach Road Rockingham 100 Smythe Street Rockingham 101 Roscoe Turn Rockingham 102 Epsilon Drive Rockingham 103 Jecks Street Rockingham 104 Parkin Street Rockingham 105 Merope Close Rockingham 106 Orizaba Place Rockingham 107 Orizaba Place Rockingham 108 Waterway Court Churchlands 109 Selby Street Churchlands 110 Falcon Avenue Churchlands 111 Coneflower Corner Churchlands 400 360 490 290 400 400 650 600 590 660