A car dealer wishes to learn whether they can predict customers preferred car make type based on suburb so that they could distribute their mail advertising more effectively. The table below shows the number of people in a random sample of 245 and their current cars.

Suburb

Nedlands Como Bentley Car

Benz 20 15 5

BMW 30 20 15

Toyota 10 15 20

Hyundai 5 8 40

Kia 7 5 30

Conduct an appropriate test to see if there is sufficient evidence to establish a connection between suburb and car preference at the 1% level of significance. Please use spreadsheet 2007 for any formula to be used.