1) Queen City contains the following properties. Answer all of the following questions. Market Value $80,000 110,000 115,000 165,000 195,000 C-1 Parcel Assessed Value Residential Properties: R-1 $25,000 R-2 30,000 R-3 37,000 R-4 38,000 R-5 66,000 Commercial Properties: $90,000 C-2 165,000 C-3 210,000 300,000 C-5 810,000 Industrial Properties: I-1 $1,000,000 I-2 1,700,000 5,750,000 In addition, all property is currently taxed at 3% of assessed value. $200,000 400,000 400,000 1,000,000 2,000,000 C-4 $2,500,000 4,000,000 10,000,000 1-3 (a) What is the average effective tax rate on residential property? (b) Which class of property has the highest effective tax rate? (C) Which parcel has the lowest effective tax rate? (d) What is the coefficient of dispersion (C.D.) for commercial property