Variable Name Gender Age_Driver State Area Lic_Type Lic_Held NCBR EstKmsYear Car_Val Val_Method Age_Car Veh_Type Eng_Type Alarm Exist_Dam Park_Onight Broker Insurer Excess Exclusions Ins_Type Customer_Sat (Ratings) Prev_Ins_Cost Quote_Val Savings Description Gender of the respondent {Male;Female;Other} Age of the Driver State where customer resides {NSW;VIC;QLD;SA;WA;TAS;NT;ACT} Area classification {Urban;Rural} License Type {Learner;Probationary;Full} Licence held in years No claim bonus rating {Silver;Gold;Platinum;Ruby;Sapphire;Diamond} Estimated KM per year {1- Less than 10,000km; 2-Less than 20,000km; 3-less than 30,000km; 4-More than or equal to 30,000 Value of the car in dollars Valuation Method (Agreed Value;Market Value} Age of the car in years Vehicle Type{4WD;Family;Luxury;Sports} Engine Type {Diesel;Electric; Hybrid;LPG;Petrol) Car Alarm {No;Yes} Existing Damage {None;Hail;Rust;Unrepaired Damage} Location where vehicle is parked overnight{Street;Driveway;Secure Public; Garage} Car Insurance Broker {1,AChoose;2,BChoose;3,CChoose;4,DChoose} Insurance Policy Provider {1,Iprovider A;2,Iprovider B;3,Iprovider C;4,Iprovider D;5,Iprovider E;6,Iprovider E;7,Iprovider F;8,Ip Opted Excess in dollars Opted exclusion {None;Flood;Hail;Inexperience Driver;Drivers under 30} Insurance policy {3rd Party;Comprehensive} Level of satisfaction with Insurance Broker {Very Satisfied;Satisfied;Neutral;Dissatisfied;Very Dissatisfied} Previous annual car insurance premium in dollars Current annual car insurance premiums in dollars as quoted by insurance broker Annual saving on car insurance premium in dollars than or equal to 30,000km} der E;7,Iprovider F;8,Iprovider G} Cust_No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Gender Female Male Female Female Male Female Male Male Female Female Male Female Male Male Female Female Male Female Female Female Male Male Other Female Female Male Female Female Male Male Male Male Female Other Male Female Male Female Female Female Female Male Female Male Male Male Male Male Female Age_Driver 35 64 33 23 33 60 37 25 39 35 35 49 34 50 49 39 61 59 25 18 37 24 33 30 43 56 58 35 42 34 50 34 41 44 27 40 33 38 41 32 58 28 19 33 59 48 21 26 39 State QLD TAS NSW VIC NSW NSW NSW VIC NSW VIC QLD NSW NSW QLD VIC QLD NSW NSW WA NSW VIC TAS NSW NSW NSW NT NT VIC QLD VIC VIC VIC VIC QLD SA NSW NSW VIC VIC QLD QLD QLD NSW SA NSW WA VIC NSW SA Area Lic_Type Urban Probationary Rural Full Urban Full Urban Full Rural Full Rural Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Probationary Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Learner Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Lic_Held 2 46 15 5 15 42 19 7 21 17 17 31 16 32 31 21 43 41 7 0 19 6 15 12 4 5 17 17 24 16 32 16 23 26 9 22 15 20 23 14 40 10 0 15 16 30 3 5 21 NCBR EstKmsYear Silver 3 Gold 1 Diamond 1 Platinum 4 Sapphire 1 Diamond 3 Diamond 2 Diamond 2 Diamond 3 Diamond 2 Diamond 3 Diamond 3 Diamond 1 Diamond 3 Diamond 3 Diamond 3 Diamond 3 Diamond 3 Diamond 3 None 2 Diamond 3 Silver 3 Diamond 3 Diamond 3 Silver 3 Silver 3 Diamond 3 Diamond 1 Silver 2 Diamond 3 Diamond 3 Platinum 3 Diamond 3 Diamond 3 Diamond 3 Diamond 3 Diamond 4 Diamond 3 Diamond 3 Diamond 3 Gold 1 Diamond 3 None 1 Diamond 1 Diamond 1 Diamond 3 Platinum 2 Sapphire 4 Diamond 3 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Male Female Female Female Female Male Female Male Other Female Male Female Male Female Male Male Female Female Female Female Female Female Male Female Female Male Male Male Male Female Female Female Female Female Male Female Female Female Female Other Female Male Male Male Male Male Female Male Male Female 29 31 33 36 28 40 25 39 27 40 27 53 39 47 27 40 27 60 25 53 35 43 33 48 29 26 23 30 53 53 43 30 27 59 36 52 40 29 40 36 38 64 43 28 52 48 52 43 39 29 NSW NSW NSW NSW NSW NSW SA QLD NSW TAS NSW VIC WA QLD NSW NSW VIC WA SA VIC VIC QLD VIC SA NSW SA NSW SA QLD NSW QLD WA QLD QLD NSW VIC NSW QLD VIC VIC VIC QLD NSW QLD QLD NSW NSW NSW QLD NT Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Urban Full Rural Full Rural Full Rural Probationary Rural Full Rural Full Rural Full 11 13 15 18 7 22 7 21 6 22 9 35 21 29 9 22 9 17 7 35 17 25 15 30 11 8 5 12 35 35 25 12 9 41 18 34 22 11 22 18 20 46 25 10 34 30 1 25 21 11 Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Sapphire Platinum Diamond Diamond Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Silver Diamond Diamond Diamond 2 4 3 2 2 3 2 2 3 1 2 1 2 3 3 1 3 2 2 2 1 3 3 1 1 3 3 3 3 3 3 3 3 3 2 1 2 3 1 4 3 3 3 2 3 2 3 3 3 3 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 Female Female Other Male Male Female Female Female Male Female Male Female Male Male Male Female Female Female Male Male Female Female Male Male Other Female Female Male Female Male Female Male Female Female Female Female Female Other Female Female Male Female Female Female Female Male Female Male Female Male 34 25 32 49 40 39 32 25 42 37 28 23 37 35 63 29 62 26 50 49 44 25 44 42 36 41 26 42 27 48 65 65 44 48 37 52 38 35 34 34 27 23 62 41 26 36 37 39 62 61 SA SA VIC ACT NT NSW WA QLD QLD VIC VIC NSW VIC NSW NSW QLD VIC VIC NSW VIC NSW VIC VIC VIC NSW NSW NSW QLD VIC QLD VIC WA WA QLD QLD VIC QLD VIC NSW SA ACT NSW NSW NSW SA QLD VIC VIC QLD WA Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Probationary Rural Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Probationary Urban Full Urban Full Urban Full Urban Full Rural Full Rural Full 16 7 14 31 22 21 14 3 24 19 10 3 19 17 45 11 15 8 32 31 26 7 26 24 18 23 8 24 9 2 10 20 26 30 19 34 20 17 3 16 9 5 44 2 8 18 19 21 15 43 Diamond Diamond Diamond Ruby Diamond Diamond Diamond Platinum Silver Diamond Diamond Platinum Ruby Gold Diamond Diamond Diamond Platinum Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Platinum Diamond Diamond Gold Diamond Gold Diamond Diamond Diamond Diamond Diamond Diamond 3 2 2 2 3 3 4 1 3 3 1 3 4 3 3 4 1 2 1 3 3 3 1 1 1 3 3 3 1 1 2 1 1 2 1 3 1 3 1 3 3 2 2 1 1 1 2 4 3 3 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 Female Female Female Female Female Male Male Female Female Male Male Male Female Male Female Female Male Female Female Female Male Female Female Female Female Female Female Male Female Female Female Female Female Female Male Male Female Male Male Female Female Female Female Male Female Female Male Male Male Female 20 31 28 22 36 48 47 51 48 30 40 29 35 61 38 40 32 32 68 39 58 47 50 24 30 31 37 44 41 46 57 61 58 49 30 55 32 29 47 32 44 34 38 42 30 29 38 32 55 47 VIC WA NSW WA NSW NSW NSW VIC NSW VIC WA VIC QLD VIC NT NSW ACT NSW QLD VIC QLD ACT SA QLD VIC VIC NSW VIC VIC NSW VIC SA SA VIC NSW NSW SA WA QLD NSW SA TAS WA NSW VIC QLD ACT WA QLD VIC Rural Urban Rural Rural Rural Rural Rural Rural Urban Urban Rural Rural Urban Rural Rural Rural Rural Rural Rural Urban Rural Urban Urban Rural Rural Urban Rural Urban Rural Rural Urban Rural Rural Urban Rural Rural Rural Rural Rural Urban Urban Rural Urban Rural Rural Urban Rural Rural Rural Rural Probationary Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Probationary Full Full Probationary Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Probationary Full Full Full Full Probationary Full Full Full Full Full 2 13 10 4 10 30 29 33 30 12 22 11 17 43 20 22 14 14 15 2 6 29 2 6 12 13 19 26 5 28 39 43 40 31 12 37 14 11 29 1 26 16 20 24 1 11 20 14 37 29 Silver Diamond Diamond Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Ruby Silver Gold Platinum Platinum Gold Diamond Silver Diamond Diamond Diamond Sapphire Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Silver Diamond Diamond Diamond Diamond Silver Diamond Diamond Diamond Diamond Diamond 3 4 3 1 3 1 1 3 3 1 1 3 3 1 3 3 1 4 3 3 1 3 1 1 3 3 3 1 3 2 3 1 2 2 2 1 4 3 3 1 3 1 3 3 2 3 2 3 1 1 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 Female Female Male Male Male Female Female Female Female Female Female Female Male Male Female Female Female Female Male Male Male Other Female Male Female Female Female Female Male Female Female Female Male Female Male Male Male Male Female Female Female Female Male Female Male Male Male Male Male Female 40 37 43 32 31 44 39 41 30 58 55 60 29 42 41 35 24 39 38 37 47 38 41 41 38 29 38 61 26 25 62 42 31 33 21 50 36 41 27 42 28 46 32 40 39 30 33 27 37 56 SA NSW NSW NSW VIC WA VIC NSW QLD NSW NSW VIC ACT NSW VIC VIC NSW NSW NSW QLD WA QLD TAS NSW NSW WA TAS NSW QLD ACT SA NSW ACT VIC NT VIC WA QLD NSW NSW WA VIC WA VIC NT QLD SA NSW NSW WA Urban Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Urban Probationary Rural Full Rural Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Urban Full 22 9 25 14 13 26 21 23 12 40 37 42 8 24 23 17 6 6 20 19 29 20 23 23 20 11 20 15 8 1 44 24 9 15 3 32 18 23 9 24 8 28 14 22 21 12 15 9 19 38 Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Platinum Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Gold Diamond Gold Silver Diamond Diamond Diamond Silver Silver Diamond Platinum Diamond Diamond Ruby Ruby Diamond Diamond Diamond Sapphire Diamond Diamond Diamond Diamond Silver 2 3 3 3 3 3 2 3 3 1 1 3 3 3 3 3 1 1 3 3 3 3 2 2 4 3 3 3 3 2 2 1 3 1 3 3 3 3 3 1 1 1 1 2 2 1 3 2 1 2 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 Female Male Male Female Female Female Male Female Female Female Female Female Female Female Male Female Female Female Female Male Female Male Female Male Male Female Male Female Male Female Male Female Male Male Female Female Male Female Male Female Female Male Female Other Male Male Male Female Female Other 30 36 32 44 48 39 31 39 62 21 62 34 35 41 45 54 51 52 29 44 40 41 31 38 43 40 41 64 40 52 41 38 69 26 26 45 26 33 38 36 36 45 45 34 51 38 58 54 57 43 WA SA ACT NSW TAS QLD SA VIC NSW WA VIC NSW SA VIC QLD NSW NSW NSW NSW SA NSW QLD QLD NSW VIC NSW NSW SA SA WA VIC NSW VIC NSW VIC QLD NT NT QLD SA VIC WA SA QLD QLD NSW ACT VIC TAS VIC Urban Rural Rural Rural Rural Rural Urban Rural Urban Rural Rural Rural Rural Rural Rural Rural Rural Urban Rural Rural Rural Rural Rural Rural Urban Urban Rural Rural Rural Rural Rural Rural Rural Rural Urban Urban Rural Rural Rural Rural Rural Urban Rural Urban Rural Rural Rural Rural Urban Rural Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full Full 12 18 14 3 30 21 13 21 44 3 44 16 6 23 27 36 33 34 11 26 22 23 13 20 25 22 23 46 22 34 23 20 51 8 8 27 8 15 8 18 18 27 27 10 33 7 40 5 39 25 Diamond Diamond Diamond Platinum Diamond Diamond Diamond Diamond Diamond Platinum Diamond Diamond Diamond Diamond Diamond Diamond Diamond Sapphire Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Platinum Diamond Platinum Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Sapphire Diamond Diamond 1 3 2 3 2 2 3 2 2 3 3 3 1 3 3 3 1 1 2 3 3 3 1 3 3 3 3 2 2 3 4 3 2 1 4 2 2 3 2 1 3 2 3 1 1 4 3 2 3 3 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 Male Male Female Female Male Female Male Male Male Female Female Female Male Female Male Female Female Male Other Male Female Male Male Female Female Male Female Female Other Female Female Female Female Female Male Female Male Female Female Male Male Male Female Female Female Male Female Male Female Female 40 45 54 43 48 44 57 20 49 39 41 37 65 50 57 48 53 52 38 33 63 51 43 44 30 42 62 38 54 52 38 55 43 25 36 53 28 32 40 57 27 38 28 52 39 36 38 41 27 32 NSW VIC ACT NSW WA SA QLD NSW NSW TAS SA NT NSW NSW SA NSW NSW NSW WA NSW ACT NSW NSW VIC SA SA QLD TAS NSW SA VIC NT VIC VIC TAS VIC SA NSW VIC SA VIC VIC VIC QLD NSW NSW NSW SA NSW SA Rural Full Urban Full Urban Full Urban Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Probationary Urban Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Probationary Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full 22 27 36 25 30 26 39 3 31 21 23 4 47 32 39 30 35 34 2 9 45 33 25 26 12 24 44 20 36 34 20 37 25 7 18 35 10 14 22 39 9 20 1 34 21 18 20 23 9 14 Diamond Diamond Silver Diamond Diamond Diamond Diamond Gold Diamond Diamond Gold Ruby Diamond Diamond Diamond Diamond Diamond Diamond Gold Diamond Diamond Diamond Diamond Diamond Diamond Diamond Silver Diamond Sapphire Diamond Diamond Diamond Diamond Diamond Diamond Diamond Gold Diamond Diamond Diamond Silver Diamond Silver Diamond Diamond Platinum Diamond Diamond Sapphire Diamond 2 3 4 3 3 3 3 1 1 2 3 1 3 3 3 2 2 3 4 3 2 1 3 2 3 1 3 3 3 1 1 1 3 1 4 3 1 1 1 1 3 1 3 1 3 3 2 3 3 1 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 Male Female Female Female Male Male Male Male Female Male Male Female Female Male Female Female Other Female Male Female Female Female Female Female Female Other Male Female Male Male Female Male Male Female Female Female Male Male Female Other Male Male Female Female Male Male Male Female Female Female 39 51 42 30 24 33 61 37 39 23 55 43 43 50 43 49 63 33 35 21 63 36 28 43 44 25 27 22 33 25 47 44 26 47 41 35 41 32 34 31 31 57 32 44 29 56 28 42 22 35 NSW VIC SA NSW WA QLD WA WA TAS ACT QLD QLD WA QLD NSW NSW SA TAS WA NSW NSW QLD SA VIC WA WA SA NSW NSW VIC NT SA SA SA ACT VIC ACT VIC VIC QLD NSW NSW VIC NSW NSW NSW WA VIC NSW SA Rural Full Rural Full Rural Full Urban Full Urban Probationary Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Urban Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Rural Full Urban Full Rural Full Urban Full Rural Full Rural Full 21 33 24 9 2 15 43 19 21 5 37 25 25 32 25 31 7 15 17 3 45 18 10 25 26 7 9 4 15 4 29 7 8 29 23 17 23 14 16 13 13 39 14 26 11 38 10 24 4 17 Diamond Diamond Diamond Diamond Gold Diamond Diamond Diamond Diamond Sapphire Diamond Diamond Diamond Diamond Diamond Diamond Silver Diamond Diamond Platinum Diamond Diamond Diamond Diamond Diamond Diamond Diamond Ruby Diamond Ruby Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Diamond Ruby Diamond 3 1 2 1 4 3 1 3 1 3 3 3 3 3 3 1 3 2 3 3 2 3 3 3 3 3 3 2 1 1 3 3 3 3 3 2 1 3 1 1 1 2 1 3 2 3 1 2 2 3 400 Female 52 SA Rural Full 17 Diamond 3 Car_Val $75,000.00 $20,600.00 $21,100.00 $85,000.00 $46,200.00 $30,100.00 $18,700.00 $94,000.00 $57,000.00 $16,800.00 $253,000.00 $63,800.00 $16,800.00 $24,300.00 $76,000.00 $28,900.00 $24,600.00 $40,600.00 $18,100.00 $19,700.00 $57,000.00 $83,000.00 $30,700.00 $56,200.00 $28,000.00 $13,400.00 $68,000.00 $24,200.00 $70,000.00 $18,500.00 $26,000.00 $33,400.00 $18,700.00 $33,200.00 $30,100.00 $210,000.00 $208,200.00 $14,300.00 $23,800.00 $60,000.00 $55,000.00 $37,900.00 $12,300.00 $32,000.00 $72,000.00 $18,500.00 $85,000.00 $134,000.00 $34,000.00 Val_Method Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Agreed Value Market Value Age_Car Veh_Type Eng_Type 3 4WD Petrol 3 Family Petrol 3 Family Petrol 3 4WD Petrol 7 Family Petrol 1 Family Petrol 10 Family Petrol 1 4WD Diesel 1 Luxury Diesel 3 Family Petrol 3 Luxury Petrol 3 Luxury Petrol 10 Family Petrol 1 Family Petrol 1 4WD LPG 10 Family Petrol 10 Family Petrol 1 Family Hybrid 5 Family Petrol 3 Family Diesel 1 Luxury Petrol 5 Luxury Diesel 5 Family Diesel 10 Sports Petrol 3 Family Diesel 10 Family Petrol 3 4WD Diesel 1 Family Diesel 10 Luxury Petrol 1 Family Petrol 1 Family Petrol 1 Family Electric 10 Family Petrol 1 Family Petrol 3 Family Petrol 1 Sports Petrol 8 Sports Petrol 10 Family Petrol 10 Family Petrol 1 Sports Petrol 1 4WD Petrol 1 Family Hybrid 10 Family Petrol 5 Family Petrol 1 Luxury Petrol 10 Family Petrol 1 4WD Diesel 1 Sports Petrol 10 Family Petrol Alarm Exist_Dam Yes None Yes None Yes None Yes None Yes None Yes None No None Yes None Yes None Yes Unrepaired Damage Yes None Yes None No None Yes None Yes None No Rust No None Yes None No None Yes None Yes None No None No None No None Yes None No None Yes None Yes None No None Yes None Yes None Yes None No None Yes None Yes None Yes None Yes Hail No None No None Yes None Yes Hail Yes None No Hail No None Yes None No None Yes None Yes None No None $30,100.00 $23,200.00 $213,000.00 $105,000.00 $68,000.00 $42,300.00 $20,600.00 $28,300.00 $24,700.00 $16,800.00 $21,300.00 $63,700.00 $19,100.00 $92,000.00 $79,500.00 $16,900.00 $81,990.00 $72,000.00 $52,800.00 $63,800.00 $13,600.00 $12,100.00 $175,000.00 $20,000.00 $16,600.00 $22,400.00 $23,500.00 $45,500.00 $55,000.00 $110,000.00 $22,300.00 $27,500.00 $61,000.00 $31,000.00 $38,100.00 $7,000.00 $26,300.00 $39,700.00 $10,000.00 $23,400.00 $59,000.00 $21,100.00 $34,300.00 $16,200.00 $22,500.00 $29,200.00 $90,000.00 $22,000.00 $59,200.00 $22,800.00 Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Agreed Value Market Value Market Value 5 1 3 11 1 3 11 1 17 11 11 3 11 1 11 11 1 3 11 3 11 7 3 11 5 11 11 7 8 8 8 3 3 18 3 18 8 1 15 1 15 1 1 16 16 1 1 16 8 3 Family Family Sports Luxury 4WD Family Family Family 4WD Family Family Luxury Family Sports 4WD Family 4WD 4WD Sports Luxury Family Family Luxury Family Family Family Family Family Luxury Luxury Family Family Luxury 4WD Family Family Family Family Family Family Luxury Family Family Family Family Family Luxury 4WD Luxury Family Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol LPG Petrol Petrol Petrol Hybrid Petrol Petrol Petrol Petrol Electric LPG Petrol Petrol Petrol LPG Petrol Petrol No None Yes None Yes None No None Yes Unrepaired Damage Yes None No None Yes None No Rust No None No None Yes None No None Yes Hail No None No None Yes None Yes None No None Yes None No None Yes None Yes None No None No None No None No None Yes None Yes None Yes None Yes Rust Yes None Yes Hail No Rust Yes None No None Yes None Yes None No None Yes None No Hail Yes Hail Yes None No None No None Yes None Yes None No Rust Yes None Yes None $19,600.00 $65,000.00 $49,300.00 $18,700.00 $18,000.00 $16,800.00 $24,300.00 $18,700.00 $60,000.00 $70,000.00 $20,200.00 $120,000.00 $65,000.00 $13,600.00 $20,000.00 $22,000.00 $26,400.00 $335,900.00 $22,500.00 $27,600.00 $86,400.00 $67,000.00 $16,800.00 $58,000.00 $47,600.00 $31,000.00 $20,300.00 $13,600.00 $367,800.00 $83,000.00 $42,600.00 $22,500.00 $21,100.00 $95,000.00 $8,600.00 $76,300.00 $28,200.00 $21,900.00 $7,200.00 $9,100.00 $15,800.00 $24,400.00 $14,300.00 $49,000.00 $28,900.00 $24,400.00 $65,000.00 $40,000.00 $110,000.00 $28,200.00 Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value 3 3 11 3 11 4 4 11 4 4 11 4 8 18 18 18 1 1 4 1 4 1 18 1 8 9 9 12 1 1 12 4 4 1 12 6 1 1 12 8 12 4 9 4 4 4 1 1 1 2 Family Luxury Sports Family Family Family Family Family Sports Luxury Family Sports Luxury Family Family 4WD Family Sports Family Family Sports 4WD Family Luxury Family 4WD Family Family Sports Luxury Sports Family Family Luxury Family Sports Family Family Family Family Family Family Family 4WD Family Family 4WD 4WD Sports Family Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol LPG Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol Petrol Yes None Yes None No Hail Yes None No None Yes None Yes None No Rust Yes None Yes None No None Yes None Yes None No Rust No None No Rust Yes None Yes None Yes None Yes None Yes None Yes None No Hail Yes None Yes None No None Yes Unrepaired Damage No Rust No None Yes None No None Yes None Yes None Yes None No Rust Yes None No None Yes None No None Yes None No None Yes None Yes None Yes None Yes None Yes None No None No None No None No None $29,400.00 $33,900.00 $103,200.00 $32,000.00 $35,800.00 $240,200.00 $58,000.00 $35,200.00 $95,000.00 $48,300.00 $18,700.00 $14,700.00 $26,300.00 $16,800.00 $19,600.00 $160,000.00 $13,600.00 $46,000.00 $6,500.00 $31,000.00 $22,800.00 $27,600.00 $5,100.00 $70,000.00 $29,800.00 $15,500.00 $7,900.00 $40,000.00 $33,400.00 $9,300.00 $19,600.00 $83,000.00 $90,000.00 $26,000.00 $42,700.00 $22,500.00 $26,300.00 $33,900.00 $49,000.00 $4,000.00 $19,000.00 $63,700.00 $21,100.00 $26,300.00 $17,000.00 $13,200.00 $42,000.00 $40,600.00 $11,100.00 $18,700.00 Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value 2 2 4 2 2 9 2 1 2 9 2 12 1 12 4 1 2 12 12 1 1 2 12 2 4 1 12 5 1 12 4 9 2 2 4 2 4 3 9 16 9 4 4 4 9 12 6 6 13 6 Family Family Sports Family Family Sports Luxury Family 4WD Family Family Family Family Family Family Sports Family Sports Family 4WD Family Family Family 4WD Family Family Family 4WD Family Family Family Luxury Sports Family Family Family Family Family Family 4WD 4WD Luxury Family Family 4WD Family Family Family Family Family Diesel Petrol Petrol Petrol Petrol Petrol Petrol Electric Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol LPG Petrol Petrol Petrol Petrol Diesel Diesel Petrol Diesel Diesel Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol LPG LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol LPG LPG No None No None Yes None No None No None Yes None No None Yes None No None No None No None No None Yes None No None Yes None Yes None No None No None No None Yes None Yes None No None No None No None Yes None Yes None No None Yes None Yes None No None Yes Unrepaired Damage Yes None No None No None Yes None No None Yes None No None Yes None No Rust Yes None Yes None Yes None Yes None Yes None No None Yes None Yes None No None Yes None $26,000.00 $59,000.00 $18,700.00 $140,000.00 $63,300.00 $7,900.00 $59,200.00 $6,500.00 $32,500.00 $125,000.00 $248,000.00 $36,100.00 $55,000.00 $67,000.00 $76,300.00 $29,600.00 $304,000.00 $16,300.00 $31,000.00 $152,000.00 $56,000.00 $72,000.00 $13,600.00 $402,000.00 $76,000.00 $57,800.00 $22,800.00 $62,000.00 $16,800.00 $25,000.00 $16,800.00 $40,000.00 $76,000.00 $5,800.00 $28,000.00 $13,000.00 $33,900.00 $39,900.00 $10,300.00 $7,200.00 $24,300.00 $95,000.00 $74,200.00 $19,000.00 $42,700.00 $143,000.00 $28,900.00 $49,000.00 $74,200.00 $69,000.00 Market Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value 5 1 13 1 4 13 1 13 13 1 1 1 3 3 4 1 1 9 2 3 4 2 3 3 2 3 4 3 2 9 5 9 5 13 5 13 5 5 10 13 3 14 5 10 6 2 6 2 6 2 Family Luxury Family Sports Sports Family 4WD Family Family Luxury Luxury Family Luxury Luxury Luxury Family Sports Family 4WD Sports 4WD 4WD Family Luxury 4WD Family Family Sports Family 4WD Family 4WD Luxury Family Family 4WD Family Family Family Family Family Sports Luxury 4WD Family Sports Family 4WD 4WD Luxury Petrol Diesel Petrol Diesel Petrol Petrol Petrol Petrol Diesel Petrol Petrol Electric Diesel Petrol Petrol Petrol Petrol Petrol Diesel Petrol LPG Diesel Petrol Petrol Diesel Diesel Petrol Petrol Petrol Petrol LPG LPG Petrol Petrol Diesel LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Yes None Yes None No None Yes None Yes None No None Yes None No None No None Yes Unrepaired Damage Yes None Yes None No None No None Yes None Yes None Yes None Yes None Yes None No None Yes None Yes Hail No None No None Yes None No None Yes None No None Yes Hail Yes None Yes None Yes None Yes None No Hail Yes None No None Yes None Yes Unrepaired Damage Yes None No None No None No Unrepaired Damage Yes None Yes None No None Yes Hail No None Yes None No None Yes None $15,300.00 $41,300.00 $81,990.00 $63,300.00 $322,300.00 $13,700.00 $75,900.00 $33,000.00 $22,000.00 $63,200.00 $248,000.00 $59,600.00 $15,100.00 $185,000.00 $59,000.00 $153,000.00 $60,000.00 $90,000.00 $18,300.00 $79,500.00 $71,000.00 $344,300.00 $125,000.00 $40,200.00 $67,000.00 $65,000.00 $22,100.00 $22,500.00 $37,700.00 $110,000.00 $55,000.00 $12,100.00 $29,500.00 $19,600.00 $80,000.00 $92,000.00 $28,200.00 $57,000.00 $71,000.00 $63,700.00 $13,600.00 $20,600.00 $69,600.00 $13,600.00 $28,200.00 $13,600.00 $26,300.00 $13,600.00 $23,900.00 $90,000.00 Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value 6 6 6 7 6 2 7 7 7 8 2 8 5 2 2 8 8 2 9 5 10 3 3 3 2 3 2 3 5 2 2 5 2 2 3 2 5 4 2 4 5 2 4 10 9 10 2 10 5 5 Family Family Luxury Luxury Sports Family 4WD 4WD 4WD Sports Sports Sports Family Luxury Luxury Luxury Luxury 4WD Family Luxury Luxury Luxury Sports Family 4WD 4WD Family Family Family Luxury Luxury Family Family Family 4WD 4WD Family 4WD Luxury Luxury Family Family Sports Family Family Family Family Family Family Sports Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Diesel Petrol Diesel Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol LPG Petrol No None No None Yes None No None Yes None Yes None No None No None No None No None Yes None No None Yes None Yes None Yes None No None No None Yes None No None Yes None Yes Unrepaired Damage No None No None No None Yes None No None Yes None No None Yes None Yes None Yes None Yes Hail Yes None Yes None No None Yes None Yes None No None Yes None No None Yes None Yes None No None Yes None No None No None Yes None Yes None Yes None Yes None $43,400.00 $44,000.00 $58,000.00 $42,400.00 $68,000.00 $29,200.00 $44,800.00 $125,000.00 $18,700.00 $63,200.00 $213,000.00 $8,600.00 $38,800.00 $90,000.00 $48,000.00 $10,600.00 $21,300.00 $71,000.00 $41,000.00 $13,200.00 $18,300.00 $83,000.00 $75,900.00 $265,100.00 $16,800.00 $46,900.00 $16,800.00 $13,800.00 $24,400.00 $70,000.00 $16,600.00 $40,000.00 $24,300.00 $13,600.00 $16,800.00 $13,000.00 $18,700.00 $8,500.00 $15,100.00 $24,400.00 $26,300.00 $58,000.00 $26,600.00 $37,000.00 $39,100.00 $92,000.00 $62,000.00 $176,300.00 $95,000.00 $9,300.00 Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value 6 10 5 2 6 2 6 2 17 5 2 14 2 14 5 7 5 2 5 14 5 2 5 6 6 7 10 6 16 6 7 7 8 16 2 17 2 17 7 2 17 2 17 2 10 14 2 6 2 15 Family 4WD 4WD Family Luxury Family Family Sports Family Luxury Luxury Family Family Sports 4WD Family Family Luxury 4WD Family Family Luxury Luxury Sports Family Family Family Family Family Sports Family 4WD Family Family Family 4WD Family Family Family Family Family 4WD 4WD Family Family Luxury Luxury Sports Sports Family Petrol LPG LPG Hybrid Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol Hybrid Petrol LPG Petrol Petrol Petrol Petrol LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol LPG Petrol LPG Petrol LPG Petrol Petrol Petrol Petrol Petrol Petrol Petrol Electric Petrol Petrol Petrol Petrol Petrol Petrol Yes Yes No Yes No Yes No Yes No Yes Yes No Yes No Yes Yes Yes Yes Yes No Yes Yes Yes No No Yes Yes Yes No Yes Yes Yes Yes No Yes No Yes No Yes Yes No Yes No Yes Yes No Yes Yes Yes No None None None None None None Unrepaired Damage None None None None None None None None None None Unrepaired Damage None Rust None None None None None None None None None None None None None Unrepaired Damage None Hail None Unrepaired Damage None None Rust None Rust None None None None None None None $43,300.00 $95,000.00 $18,700.00 $8,300.00 $49,000.00 $18,700.00 $13,600.00 $35,800.00 $10,600.00 $24,400.00 $52,000.00 $13,600.00 $16,800.00 $110,000.00 $64,000.00 $55,800.00 $19,800.00 $31,600.00 $76,000.00 $63,300.00 $20,600.00 $70,000.00 $33,300.00 $24,300.00 $22,800.00 $63,000.00 $153,000.00 $60,000.00 $28,200.00 $26,300.00 $18,700.00 $16,800.00 $71,000.00 $12,300.00 $18,700.00 $63,200.00 $39,200.00 $77,000.00 $122,000.00 $36,000.00 $58,000.00 $44,100.00 $10,800.00 $248,000.00 $60,000.00 $20,600.00 $32,000.00 $5,000.00 $41,500.00 $6,300.00 Market Value Market Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Agreed Value Agreed Value Market Value Market Value Agreed Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value Market Value 3 4 4 10 6 10 5 5 5 5 5 7 3 4 4 4 5 7 5 6 3 3 5 5 5 8 5 3 17 5 3 3 5 6 3 5 5 3 15 3 15 6 7 5 3 15 3 15 3 10 Family Sports Family Family 4WD Family Family Family Family Family 4WD Family Family Sports 4WD Sports Family Family 4WD Luxury Family 4WD Family Family Family Sports Sports Luxury Family Family Family Family Luxury Family Family Luxury Family Luxury Luxury Family 4WD Family Family Sports 4WD Family Family Family Family Family Diesel Petrol Petrol Petrol Diesel Petrol LPG Petrol Petrol Petrol LPG Petrol Petrol Petrol Diesel Petrol Petrol Diesel Petrol Petrol Petrol Petrol Hybrid Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol Petrol Petrol Petrol Petrol Diesel Petrol Petrol Petrol LPG Petrol Petrol Petrol Hybrid Petrol Yes No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No Yes No Yes Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No Yes Yes No Yes No Yes No Yes Yes None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None Rust Hail None Hail None None None None None None $272,000.00 Market Value 17 Sports Petrol No None Park_Onight Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Broker 2 1 3 4 2 4 2 2 1 2 1 2 2 1 2 1 2 4 2 3 1 4 2 2 2 1 4 1 2 1 3 2 1 3 1 4 2 1 3 2 4 2 2 2 2 3 2 2 2 Insurer 5 8 4 7 2 7 5 2 1 2 7 6 5 1 2 2 4 4 2 1 7 8 6 6 7 2 8 5 8 4 7 4 4 1 1 8 1 7 4 5 4 2 4 7 2 7 4 1 7 Excess $1,500.00 $750.00 $500.00 $1,000.00 $500.00 $250.00 $500.00 $750.00 $500.00 $1,000.00 $500.00 $250.00 $500.00 $250.00 $250.00 $500.00 $250.00 $250.00 $750.00 $1,500.00 $500.00 $750.00 $500.00 $500.00 $1,500.00 $1,500.00 $500.00 $500.00 $750.00 $500.00 $250.00 $500.00 $250.00 $250.00 $500.00 $1,500.00 $1,500.00 $500.00 $250.00 $500.00 $750.00 $500.00 $1,500.00 $500.00 $500.00 $250.00 $1,500.00 $750.00 $500.00 Exclusions Hail Drivers under 30 Inexperience Driver None None None None None Inexperience Driver None None None None None None None Drivers under 30 None Inexperience Driver None Flood Inexperience Driver None Inexperience Driver None Hail Drivers under 30 None None Inexperience Driver Flood None Drivers under 30 None None None None None Inexperience Driver None None None None Inexperience Driver None None None None None Ins_Type Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive 3rd Party Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Comprehensive Customer_Sat Very Satisfied Very Satisfied Dissatisfied Very Dissatisfied Very Satisfied Neutral Very Dissatisfied Satisfied Very Satisfied Satisfied Very Satisfied Satisfied Very Satisfied Dissatisfied Satisfied Neutral Dissatisfied Very Satisfied Very Satisfied Neutral Very Satisfied Satisfied Satisfied Satisfied Satisfied Neutral Very Dissatisfied Satisfied Very Satisfied Very Satisfied Satisfied Very Dissatisfied Satisfied Dissatisfied Very Satisfied Dissatisfied Satisfied Satisfied Neutral Neutral Dissatisfied Very Satisfied Neutral Satisfied Very Dissatisfied Dissatisfied Satisfied Neutral Satisfied Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Street Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Driveway Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage 1 3 2 2 2 4 2 1 2 1 2 4 2 2 1 1 2 4 3 1 1 2 2 2 2 2 3 2 3 1 3 4 3 2 2 3 2 2 2 4 2 4 2 1 3 2 4 1 1 3 1 8 6 6 1 4 5 2 4 1 5 7 1 1 6 1 4 8 2 4 7 1 7 2 6 4 6 1 7 8 7 4 6 4 2 7 1 2 7 4 5 4 2 1 1 2 4 4 5 6 $500.00 $1,000.00 $500.00 $500.00 $1,500.00 $250.00 $750.00 $500.00 $500.00 $250.00 $500.00 $250.00 $500.00 $1,000.00 $750.00 $250.00 $750.00 $500.00 $1,500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $500.00 $500.00 $1,000.00 $500.00 $250.00 $750.00 $750.00 $500.00 $500.00 $250.00 $500.00 $250.00 $250.00 $1,000.00 $250.00 $500.00 $500.00 $250.00 $250.00 $500.00 $250.00 $250.00 $1,500.00 $250.00 $1,000.00 $500.00 Hail Drivers under 30 None None Hail None None None None None None Flood None None None None None None None Drivers under 30 None Drivers under 30 None Flood None Hail None None None Drivers under 30 Drivers under 30 Inexperience Driver None Inexperience Driver None Hail Inexperience Driver None None Hail None Inexperience Driver Inexperience Driver None None None None Drivers under 30 None Flood Comprehensive Very Dissatisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Satisfied 3rd Party Very Dissatisfied Comprehensive Satisfied Comprehensive Satisfied 3rd Party Dissatisfied 3rd Party Dissatisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Garage Secure Public Driveway Garage Garage Garage Garage Garage Garage Garage Driveway Street Secure Public Driveway Garage Garage Garage Garage 2 3 2 3 1 1 2 2 3 4 3 2 1 2 3 2 2 2 2 1 3 2 3 3 1 1 2 1 2 2 2 2 3 2 2 3 1 1 2 2 2 1 1 2 2 3 1 3 1 4 4 6 5 6 7 4 8 7 1 4 2 6 4 6 3 1 2 1 1 5 1 1 7 1 5 7 6 7 5 8 1 7 7 6 2 4 7 2 3 1 5 6 3 1 6 1 1 2 1 7 $500.00 $1,000.00 $500.00 $250.00 $250.00 $500.00 $500.00 $750.00 $750.00 $500.00 $750.00 $750.00 $500.00 $500.00 $250.00 $500.00 $500.00 $500.00 $250.00 $250.00 $250.00 $750.00 $250.00 $250.00 $500.00 $250.00 $1,500.00 $250.00 $1,500.00 $1,000.00 $250.00 $500.00 $250.00 $250.00 $500.00 $250.00 $500.00 $500.00 $500.00 $500.00 $1,500.00 $1,500.00 $250.00 $1,000.00 $500.00 $500.00 $500.00 $500.00 $500.00 $250.00 Inexperience Driver None Inexperience Driver None Flood None None Hail None None Inexperience Driver None None None None Hail Inexperience Driver None None None None None Drivers under 30 Drivers under 30 None Drivers under 30 None Inexperience Driver None None None None None None None None None None None Inexperience Driver None None Hail None None None Inexperience Driver None None Flood Comprehensive Neutral Comprehensive Neutral Comprehensive Very Satisfied 3rd Party Neutral Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Dissatisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Dissatisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Dissatisfied Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Satisfied 3rd Party Neutral Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Satisfied 3rd Party Neutral Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Street Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Driveway Street Garage Garage Garage Garage 1 2 1 3 2 3 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 3 1 2 2 2 1 3 2 3 2 4 4 3 2 4 3 4 2 2 3 4 2 2 3 2 1 2 2 2 1 1 6 4 6 7 6 7 7 8 5 1 5 1 2 6 1 5 2 1 3 2 5 7 5 5 2 8 7 2 8 3 8 7 1 4 7 1 2 1 2 8 8 1 8 4 5 7 3 8 $1,500.00 $500.00 $750.00 $1,000.00 $500.00 $1,500.00 $250.00 $250.00 $250.00 $500.00 $250.00 $750.00 $500.00 $250.00 $500.00 $1,000.00 $500.00 $500.00 $750.00 $1,000.00 $500.00 $500.00 $1,000.00 $750.00 $750.00 $500.00 $500.00 $250.00 $500.00 $250.00 $250.00 $250.00 $250.00 $250.00 $500.00 $250.00 $500.00 $500.00 $250.00 $1,500.00 $250.00 $750.00 $500.00 $250.00 $1,500.00 $500.00 $500.00 $500.00 $250.00 $250.00 None None None None None None Drivers under 30 None Hail None None None None None None None Inexperience Driver None None None None Drivers under 30 Hail None Inexperience Driver Flood None Drivers under 30 None Drivers under 30 None Drivers under 30 None None None None Drivers under 30 Inexperience Driver None Hail None Flood None Drivers under 30 Hail None None Flood Inexperience Driver None Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Dissatisfied Comprehensive Satisfied 3rd Party Neutral Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied 3rd Party Very Satisfied Comprehensive Satisfied Comprehensive Very Dissatisfied Comprehensive Very Dissatisfied 3rd Party Very Satisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Satisfied 3rd Party Neutral Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Satisfied Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied 3rd Party Satisfied Comprehensive Neutral Garage Secure Public Garage Garage Garage Garage Garage Driveway Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Street Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Secure Public Garage Street Garage Garage Garage Garage Garage Street Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage 1 2 3 2 2 1 1 1 2 2 4 4 2 3 2 1 2 2 1 3 3 3 4 2 3 2 1 1 2 2 2 2 3 2 1 3 1 1 2 1 4 2 2 1 3 2 2 2 1 4 2 6 1 6 1 1 4 1 8 1 8 8 8 5 7 7 2 5 7 2 8 8 8 1 6 1 4 4 8 7 7 7 6 2 1 5 1 7 1 6 8 1 2 6 8 5 4 4 6 4 $250.00 $500.00 $250.00 $1,500.00 $500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $250.00 $500.00 $1,500.00 $500.00 $500.00 $1,500.00 $250.00 $500.00 $250.00 $1,500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $1,500.00 $250.00 $250.00 $500.00 $1,000.00 $1,500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $1,500.00 $1,000.00 $500.00 $250.00 $500.00 $750.00 $500.00 $1,000.00 $500.00 $750.00 None Inexperience Driver None None None Hail None None Inexperience Driver None None Drivers under 30 Inexperience Driver Inexperience Driver Inexperience Driver None None Drivers under 30 None Inexperience Driver None None Flood None None Inexperience Driver Flood Drivers under 30 Inexperience Driver None None Inexperience Driver None Hail Hail None Drivers under 30 None Hail Inexperience Driver Flood Drivers under 30 None Drivers under 30 Drivers under 30 None None None None None Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Dissatisfied 3rd Party Neutral Comprehensive Neutral 3rd Party Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral 3rd Party Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Very Satisfied 3rd Party Neutral Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral 3rd Party Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Very Dissatisfied Comprehensive Neutral Comprehensive Satisfied Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Secure Public Garage Garage Garage Garage Garage Garage Garage Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage 2 1 2 2 3 1 2 4 4 2 4 2 2 2 2 1 1 1 1 3 1 2 4 1 2 4 3 2 2 3 2 1 3 2 2 3 2 2 4 1 2 3 3 2 3 2 2 2 4 2 8 6 5 1 5 2 8 8 4 7 3 7 5 8 7 2 6 5 6 7 6 8 8 1 8 8 4 7 1 1 2 5 7 1 2 1 6 2 4 4 5 8 1 5 1 1 6 2 3 1 $500.00 $500.00 $500.00 $750.00 $1,500.00 $500.00 $500.00 $500.00 $250.00 $1,500.00 $1,000.00 $500.00 $500.00 $250.00 $250.00 $250.00 $250.00 $1,500.00 $500.00 $750.00 $250.00 $1,500.00 $1,000.00 $500.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $500.00 $500.00 $500.00 $500.00 $500.00 $250.00 $500.00 $500.00 $500.00 $500.00 $500.00 $250.00 $250.00 $500.00 $250.00 $500.00 $250.00 $500.00 $250.00 $1,000.00 Inexperience Driver Flood None Drivers under 30 None Drivers under 30 Flood None Drivers under 30 None None None Flood Inexperience Driver None None None Inexperience Driver Inexperience Driver None Inexperience Driver None None Inexperience Driver None Inexperience Driver None Drivers under 30 Drivers under 30 None None None Drivers under 30 None None Inexperience Driver None None None None Hail Flood None Hail None None None None None None Comprehensive Neutral Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Dissatisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Dissatisfied Comprehensive Very Dissatisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Satisfied Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Street Garage Garage Garage Garage Street Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage 1 1 4 3 3 3 4 3 2 1 1 2 1 3 2 3 3 3 2 2 4 2 2 3 2 1 1 2 2 1 1 1 3 2 2 2 2 2 3 2 3 4 2 3 1 2 1 1 2 2 5 5 4 1 1 7 4 2 6 4 8 5 3 1 2 6 7 6 8 8 8 2 1 8 1 5 7 5 6 5 7 1 7 2 1 1 4 2 1 6 8 4 8 4 5 6 6 1 1 4 $250.00 $250.00 $750.00 $250.00 $250.00 $250.00 $250.00 $1,500.00 $250.00 $500.00 $750.00 $500.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $1,000.00 $500.00 $250.00 $250.00 $250.00 $250.00 $500.00 $250.00 $750.00 $500.00 $250.00 $250.00 $500.00 $250.00 $250.00 $750.00 $500.00 $250.00 $500.00 $1,000.00 $250.00 $250.00 $750.00 $500.00 $1,500.00 $250.00 $500.00 $1,500.00 $750.00 $250.00 $500.00 $500.00 Inexperience Driver None None Hail Flood Drivers under 30 Drivers under 30 None None None None Hail Drivers under 30 None None Drivers under 30 None None Hail None Inexperience Driver None None None Flood Inexperience Driver None None None None Inexperience Driver None Inexperience Driver None Flood Hail Inexperience Driver None Drivers under 30 None None None None Drivers under 30 None None None None None Flood Comprehensive Dissatisfied Comprehensive Very Dissatisfied Comprehensive Satisfied Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied 3rd Party Dissatisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied 3rd Party Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Dissatisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Very Dissatisfied 3rd Party Neutral Comprehensive Neutral Comprehensive Very Satisfied 3rd Party Neutral 3rd Party Satisfied Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Dissatisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Satisfied 3rd Party Neutral Garage Garage Driveway Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Street Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Garage Secure Public Garage Garage Garage Garage Garage Garage 2 3 2 2 2 2 3 1 1 2 4 2 1 2 2 2 3 2 1 1 4 1 2 3 1 1 2 2 2 2 1 2 2 3 1 1 1 2 2 4 2 4 2 1 2 2 4 1 2 1 4 1 5 8 1 5 8 7 7 2 3 1 7 6 8 7 3 5 1 1 8 2 2 1 7 5 2 7 6 1 6 7 5 2 1 2 5 2 7 8 6 7 2 1 6 2 4 2 6 8 $500.00 $250.00 $250.00 $500.00 $1,000.00 $500.00 $250.00 $500.00 $500.00 $1,500.00 $250.00 $250.00 $250.00 $500.00 $250.00 $250.00 $750.00 $500.00 $500.00 $1,500.00 $250.00 $500.00 $500.00 $250.00 $250.00 $750.00 $500.00 $750.00 $500.00 $1,000.00 $250.00 $250.00 $1,000.00 $250.00 $250.00 $500.00 $250.00 $500.00 $500.00 $500.00 $500.00 $250.00 $500.00 $250.00 $750.00 $250.00 $500.00 $250.00 $1,500.00 $500.00 None None Drivers under 30 Hail Hail None Drivers under 30 None None None None None Inexperience Driver Drivers under 30 None None Flood Inexperience Driver None None Drivers under 30 None Inexperience Driver None None Inexperience Driver Flood None None Hail Hail Flood None Inexperience Driver None None None None Flood Hail Inexperience Driver None None Inexperience Driver None None None Inexperience Driver None Hail Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Neutral 3rd Party Satisfied Comprehensive Satisfied Comprehensive Very Dissatisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Neutral Comprehensive Neutral Comprehensive Dissatisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Dissatisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Neutral Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Satisfied 3rd Party Very Satisfied Comprehensive Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Satisfied Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Neutral Comprehensive Satisfied Comprehensive Very Satisfied Comprehensive Very Satisfied Comprehensive Satisfied 3rd Party Dissatisfied Comprehensive Satisfied 3rd Party Satisfied Garage 1 1 $1,000.00 Inexperience Driver Comprehensive Satisfied Prev_Ins_Cost $1,974.00 $508.00 $480.00 $1,478.00 $749.00 $591.00 $441.00 $1,250.00 $868.00 $410.00 $3,151.00 $998.00 $439.00 $508.00 $1,064.00 $529.00 $534.00 $699.00 $550.00 $914.00 $868.00 $1,548.00 $571.00 $918.00 $637.00 $437.00 $988.00 $509.00 $1,171.00 $453.00 $524.00 $664.00 $453.00 $592.00 $565.00 $1,856.00 $1,998.00 $403.00 $504.00 $961.00 $949.00 $639.00 $676.00 $583.00 $1,097.00 $452.00 $1,771.00 $2,132.00 $573.00 Quote_Val $906.00 $468.00 $460.00 $1,350.00 $540.00 $493.00 $441.00 $690.00 $576.00 $439.00 $2,258.00 $615.00 $439.00 $469.00 $635.00 $475.00 $476.00 $626.00 $600.00 $820.00 $576.00 $1,400.00 $487.00 $591.00 $507.00 $447.00 $820.00 $469.00 $666.00 $453.00 $473.00 $515.00 $453.00 $493.00 $485.00 $1,700.00 $914.00 $437.00 $467.00 $604.00 $746.00 $508.00 $600.00 $491.00 $644.00 $452.00 $846.00 $953.00 $488.00 Savings $1,068.00 $40.00 $20.00 $128.00 $209.00 $98.00 $0.00 $560.00 $292.00 -$29.00 $893.00 $383.00 $0.00 $39.00 $429.00 $54.00 $58.00 $73.00 -$50.00 $94.00 $292.00 $148.00 $84.00 $327.00 $130.00 -$10.00 $168.00 $40.00 $505.00 $0.00 $51.00 $149.00 $0.00 $99.00 $80.00 $156.00 $1,084.00 -$34.00 $37.00 $357.00 $203.00 $131.00 $76.00 $92.00 $453.00 $0.00 $925.00 $1,179.00 $85.00 $646.00 $454.00 $2,697.00 $1,364.00 $795.00 $677.00 $474.00 $524.00 $537.00 $438.00 $482.00 $1,069.00 $445.00 $1,057.00 $1,032.00 $439.00 $1,056.00 $1,029.00 $756.00 $1,070.00 $409.00 $394.00 $2,266.00 $468.00 $437.00 $492.00 $546.00 $803.00 $961.00 $1,415.00 $505.00 $541.00 $973.00 $632.00 $608.00 $353.00 $527.00 $588.00 $374.00 $482.00 $889.00 $498.00 $602.00 $434.00 $513.00 $554.00 $2,775.00 $507.00 $780.00 $496.00 $510.00 $454.00 $2,122.00 $724.00 $554.00 $519.00 $550.00 $473.00 $477.00 $448.00 $461.00 $836.00 $445.00 $632.00 $625.00 $439.00 $632.00 $824.00 $542.00 $636.00 $439.00 $434.00 $993.00 $456.00 $447.00 $464.00 $580.00 $556.00 $604.00 $739.00 $467.00 $478.00 $607.00 $506.00 $498.00 $422.00 $474.00 $492.00 $428.00 $461.00 $582.00 $465.00 $497.00 $446.00 $470.00 $482.00 $2,500.00 $468.00 $550.00 $465.00 $136.00 $0.00 $575.00 $640.00 $241.00 $158.00 -$76.00 $51.00 $60.00 -$10.00 $21.00 $233.00 $0.00 $425.00 $407.00 $0.00 $424.00 $205.00 $214.00 $434.00 -$30.00 -$40.00 $1,273.00 $12.00 -$10.00 $28.00 -$34.00 $247.00 $357.00 $676.00 $38.00 $63.00 $366.00 $126.00 $110.00 -$69.00 $53.00 $96.00 -$54.00 $21.00 $307.00 $33.00 $105.00 -$12.00 $43.00 $72.00 $275.00 $39.00 $230.00 $31.00 $466.00 $939.00 $840.00 $481.00 $449.00 $425.00 $510.00 $653.00 $1,044.00 $1,003.00 $452.00 $3,150.00 $1,047.00 $446.00 $487.00 $509.00 $530.00 $3,908.00 $491.00 $539.00 $1,253.00 $972.00 $438.00 $933.00 $690.00 $600.00 $420.00 $408.00 $3,315.00 $2,082.00 $808.00 $593.00 $478.00 $1,349.00 $354.00 $1,225.00 $523.00 $488.00 $425.00 $367.00 $389.00 $575.00 $428.00 $1,255.00 $554.00 $490.00 $895.00 $659.00 $1,529.00 $571.00 $456.00 $597.00 $568.00 $460.00 $449.00 $444.00 $469.00 $512.00 $628.00 $750.00 $452.00 $2,300.00 $629.00 $446.00 $462.00 $469.00 $560.00 $1,952.00 $463.00 $478.00 $691.00 $607.00 $448.00 $595.00 $523.00 $496.00 $442.00 $439.00 $2,307.00 $938.00 $558.00 $600.00 $460.00 $720.00 $423.00 $683.00 $473.00 $462.00 $444.00 $426.00 $433.00 $588.00 $445.00 $692.00 $482.00 $463.00 $584.00 $513.00 $773.00 $487.00 $10.00 $342.00 $272.00 $21.00 $0.00 -$19.00 $41.00 $141.00 $416.00 $253.00 $0.00 $850.00 $418.00 $0.00 $25.00 $40.00 -$30.00 $1,956.00 $28.00 $61.00 $562.00 $365.00 -$10.00 $338.00 $167.00 $104.00 -$22.00 -$31.00 $1,008.00 $1,144.00 $250.00 -$7.00 $18.00 $629.00 -$69.00 $542.00 $50.00 $26.00 -$19.00 -$59.00 -$44.00 -$13.00 -$17.00 $563.00 $72.00 $27.00 $311.00 $146.00 $756.00 $84.00 $939.00 $601.00 $1,345.00 $801.00 $588.00 $2,082.00 $933.00 $644.00 $1,260.00 $737.00 $453.00 $407.00 $529.00 $452.00 $449.00 $1,631.00 $409.00 $877.00 $356.00 $897.00 $542.00 $569.00 $373.00 $1,003.00 $628.00 $427.00 $348.00 $693.00 $665.00 $368.00 $483.00 $1,308.00 $1,394.00 $524.00 $684.00 $513.00 $529.00 $601.00 $740.00 $382.00 $476.00 $938.00 $455.00 $527.00 $712.00 $405.00 $642.00 $664.00 $395.00 $453.00 $697.00 $496.00 $718.00 $656.00 $492.00 $939.00 $595.00 $509.00 $693.00 $537.00 $453.00 $438.00 $475.00 $452.00 $449.00 $804.00 $439.00 $579.00 $400.00 $585.00 $479.00 $487.00 $428.00 $616.00 $504.00 $444.00 $421.00 $524.00 $515.00 $427.00 $461.00 $1,200.00 $1,033.00 $473.00 $521.00 $470.00 $475.00 $496.00 $538.00 $431.00 $459.00 $650.00 $455.00 $474.00 $529.00 $438.00 $508.00 $515.00 $435.00 $453.00 $242.00 $105.00 $627.00 $145.00 $96.00 $1,143.00 $338.00 $135.00 $567.00 $200.00 $0.00 -$31.00 $54.00 $0.00 $0.00 $827.00 -$30.00 $298.00 -$44.00 $312.00 $63.00 $82.00 -$55.00 $387.00 $124.00 -$17.00 -$73.00 $169.00 $150.00 -$59.00 $22.00 $108.00 $361.00 $51.00 $163.00 $43.00 $54.00 $105.00 $202.00 -$49.00 $17.00 $288.00 $0.00 $53.00 $183.00 -$33.00 $134.00 $149.00 -$40.00 $0.00 $524.00 $889.00 $453.00 $1,436.00 $999.00 $355.00 $840.00 $341.00 $588.00 $1,828.00 $3,094.00 $653.00 $1,038.00 $1,034.00 $1,139.00 $560.00 $3,017.00 $421.00 $574.00 $1,421.00 $858.00 $961.00 $408.00 $3,523.00 $999.00 $827.00 $532.00 $984.00 $485.00 $973.00 $452.00 $693.00 $1,143.00 $341.00 $779.00 $415.00 $634.00 $655.00 $378.00 $358.00 $471.00 $1,082.00 $1,122.00 $476.00 $674.00 $1,755.00 $554.00 $697.00 $982.00 $1,246.00 $473.00 $582.00 $453.00 $745.00 $615.00 $423.00 $568.00 $419.00 $492.00 $862.00 $2,800.00 $512.00 $627.00 $626.00 $657.00 $484.00 $1,218.00 $442.00 $488.00 $741.00 $573.00 $604.00 $439.00 $2,569.00 $615.00 $564.00 $476.00 $611.00 $461.00 $607.00 $452.00 $524.00 $658.00 $419.00 $649.00 $441.00 $506.00 $512.00 $430.00 $424.00 $458.00 $640.00 $652.00 $459.00 $518.00 $841.00 $482.00 $525.00 $610.00 $989.00 $51.00 $307.00 $0.00 $691.00 $384.00 -$68.00 $272.00 -$78.00 $96.00 $966.00 $294.00 $141.00 $411.00 $408.00 $482.00 $76.00 $1,799.00 -$21.00 $86.00 $680.00 $285.00 $357.00 -$31.00 $954.00 $384.00 $263.00 $56.00 $373.00 $24.00 $366.00 $0.00 $169.00 $485.00 -$78.00 $130.00 -$26.00 $128.00 $143.00 -$52.00 -$66.00 $13.00 $442.00 $470.00 $17.00 $156.00 $914.00 $72.00 $172.00 $372.00 $257.00 $425.00 $635.00 $1,211.00 $1,542.00 $2,698.00 $398.00 $1,070.00 $593.00 $530.00 $1,489.00 $2,583.00 $957.00 $423.00 $2,362.00 $944.00 $2,174.00 $1,023.00 $1,010.00 $503.00 $1,026.00 $1,079.00 $2,863.00 $1,441.00 $626.00 $972.00 $951.00 $488.00 $513.00 $634.00 $1,642.00 $969.00 $385.00 $619.00 $466.00 $1,113.00 $1,229.00 $547.00 $873.00 $1,013.00 $938.00 $397.00 $474.00 $1,064.00 $409.00 $571.00 $397.00 $552.00 $452.00 $527.00 $1,040.00 $444.00 $507.00 $678.00 $777.00 $1,122.00 $436.00 $636.00 $494.00 $475.00 $761.00 $2,300.00 $602.00 $443.00 $1,022.00 $599.00 $966.00 $622.00 $618.00 $467.00 $623.00 $639.00 $2,172.00 $1,147.00 $504.00 $607.00 $851.00 $462.00 $470.00 $506.00 $807.00 $606.00 $432.00 $502.00 $456.00 $649.00 $684.00 $480.00 $578.00 $819.00 $597.00 $435.00 $458.00 $634.00 $439.00 $487.00 $435.00 $482.00 $452.00 $474.00 $627.00 -$19.00 $128.00 $533.00 $765.00 $1,576.00 -$38.00 $434.00 $99.00 $55.00 $728.00 $283.00 $355.00 -$20.00 $1,340.00 $345.00 $1,208.00 $401.00 $392.00 $36.00 $403.00 $440.00 $691.00 $294.00 $122.00 $365.00 $100.00 $26.00 $43.00 $128.00 $835.00 $363.00 -$47.00 $117.00 $10.00 $464.00 $545.00 $67.00 $295.00 $194.00 $341.00 -$38.00 $16.00 $430.00 -$30.00 $84.00 -$38.00 $70.00 $0.00 $53.00 $413.00 $687.00 $734.00 $1,025.00 $678.00 $1,046.00 $554.00 $743.00 $2,812.00 $453.00 $932.00 $2,848.00 $407.00 $681.00 $1,293.00 $825.00 $380.00 $500.00 $1,159.00 $1,096.00 $405.00 $469.00 $1,308.00 $1,135.00 $3,263.00 $439.00 $720.00 $476.00 $399.00 $550.00 $1,147.00 $423.00 $734.00 $508.00 $408.00 $425.00 $428.00 $508.00 $346.00 $422.00 $532.00 $587.00 $829.00 $956.00 $662.00 $617.00 $1,119.00 $862.00 $2,264.00 $1,435.00 $368.00 $522.00 $536.00 $823.00 $519.00 $629.00 $482.00 $600.00 $1,790.00 $453.00 $595.00 $2,167.00 $438.00 $520.00 $703.00 $563.00 $430.00 $466.00 $663.00 $644.00 $438.00 $457.00 $707.00 $656.00 $2,588.00 $439.00 $532.00 $459.00 $436.00 $481.00 $659.00 $443.00 $536.00 $469.00 $439.00 $444.00 $445.00 $468.00 $420.00 $443.00 $476.00 $492.00 $664.00 $602.00 $514.00 $501.00 $651.00 $574.00 $993.00 $745.00 $427.00 $165.00 $198.00 $202.00 $159.00 $417.00 $72.00 $143.00 $1,022.00 $0.00 $337.00 $681.00 -$31.00 $161.00 $590.00 $262.00 -$50.00 $34.00 $496.00 $452.00 -$33.00 $12.00 $601.00 $479.00 $675.00 $0.00 $188.00 $17.00 -$37.00 $69.00 $488.00 -$20.00 $198.00 $39.00 -$31.00 -$19.00 -$17.00 $40.00 -$74.00 -$21.00 $56.00 $95.00 $165.00 $354.00 $148.00 $116.00 $468.00 $288.00 $1,271.00 $690.00 -$59.00 $653.00 $1,456.00 $453.00 $359.00 $1,450.00 $453.00 $421.00 $588.00 $372.00 $526.00 $870.00 $408.00 $438.00 $1,415.00 $941.00 $908.00 $511.00 $579.00 $1,071.00 $1,491.00 $493.00 $942.00 $595.00 $508.00 $494.00 $989.00 $2,016.00 $1,438.00 $547.00 $661.00 $453.00 $438.00 $940.00 $396.00 $453.00 $998.00 $648.00 $1,154.00 $1,665.00 $621.00 $884.00 $735.00 $383.00 $3,071.00 $848.00 $493.00 $583.00 $327.00 $814.00 $340.00 $512.00 $752.00 $453.00 $424.00 $750.00 $453.00 $442.00 $492.00 $428.00 $600.00 $677.00 $439.00 $448.00 $739.00 $598.00 $588.00 $469.00 $490.00 $637.00 $762.00 $464.00 $598.00 $495.00 $469.00 $464.00 $612.00 $919.00 $746.00 $480.00 $514.00 $453.00 $448.00 $597.00 $435.00 $453.00 $615.00 $510.00 $661.00 $814.00 $502.00 $581.00 $636.00 $431.00 $2,234.00 $570.00 $464.00 $491.00 $414.00 $660.00 $418.00 $141.00 $704.00 $0.00 -$65.00 $700.00 $0.00 -$21.00 $96.00 -$56.00 -$74.00 $193.00 -$31.00 -$10.00 $676.00 $343.00 $320.00 $42.00 $89.00 $434.00 $729.00 $29.00 $344.00 $100.00 $39.00 $30.00 $377.00 $1,097.00 $692.00 $67.00 $147.00 $0.00 -$10.00 $343.00 -$39.00 $0.00 $383.00 $138.00 $493.00 $851.00 $119.00 $303.00 $99.00 -$48.00 $837.00 $278.00 $29.00 $92.00 -$87.00 $154.00 -$78.00 $2,805.00 $1,154.00 $1,651.00 Q8 Numerical Data s Known Confidence Interval for mean (m) Data Population Standard Deviation (s) Sample Mean ( ഥ 𝒙) Sample Size (n) Confidence Level Intermediate Calculations Standard Error of the Mean ( SE = 𝝈Τ )𝒏 Z Value Sampling Error/Margin of Error (= SE *Z Value) Confidence Interval Interval Lower Limit (= Sample Mean - ME) Interval Upper Limit (= Sample Mean + ME) Numerical Data s Unknown Confidence Interval for mean (m) Data Sample Standard Deviation (s) Sample Mean ( ഥ 𝒙) Sample Size (n) Confidence Level Intermediate Calculations Standard Error of the Mean ( SE = 𝒔Τ )𝒏 Degrees of Freedom (df = n-1) t Value Sampling Error/Margin of Error (= SE * t Value) Confidence Interval Interval Lower Limit (= Sample Mean - ME) Interval Upper Limit (= Sample Mean + ME) Categorical Data Confidence Interval for proportion (p) Data Sample Size (n) Count of Successes Confidence Level Intermediate Calculations Sample Proportion (p) Z Value Standard Error of the Proportion ( 𝑺𝑬 = 𝒑(𝟏 − 𝒑))Τ𝒏 Sampling Error/Margin of Error (= SE * Z Value) Confidence Interval Interval Lower Limit (= Sample Proportion - ME) Interval Upper Limit (= Sample Proportion + ME) Categorical Data Sample size for a Proportion Data Estimate of True Proportion ( p or p ) Sampling Error/Margin of Error Confidence Level Intermediate Calculations Z value Calculated Sample Size Result Minimum Sample Size Needed Always Round up! Numerical Data Sample size for a Mean Data Population OR Sample Standard Deviation ( s or s) Sampling Error/Margin of Error Confidence Level Intermediate Calculations Z value Calculated Sample Size Result Minimum Sample Size Needed Always Round up! Numerical Data s Known Hypothesis Test for µ (Mean) Hypotheses Null Hypothesis µ Alternative Hypothesis µ Test Type Level of significance Select from = ≤ ≥ Select from  < > (Lower/Upper/Two Tail) α Critical Region Critical Value (s) Table E.2 OR =NORM.S.INV(probability) Population Standard Deviation Sample Data Sample Mean Sample Size Standard Error of the Mean Z Sample Statistic p-value = s/n = (𝑥ҧ -m)/Standard Error Table E.2 OR =NORM.S.DIST(z,TRUE) Decision Critical Value(s) from Standard Normal (Z) Distribution NORM.S.INV - Returns the left-tailed inverse of the Standard Normal Distribution. =NORM.S.INV(Cumulative area) Lower Tail test Critical Value =NORM.S.INV(%) Upper Tail test Critical Value =NORM.S.INV(1-%) Two tail Test Critical Values () =NORM.S.INV(1-%/2) p-value NORM.S.DIST - Returns the Standard Normal Distribution. NORM.S.DIST - Returns the Standard Normal Distribution. =NORM.S.DIST(z,TRUE) Lower Tail test p-value = NORM.S.DIST(Z Sample Statistic, TRUE) Upper Tail test p-value = 1- NORM.S.DIST(Z Sample Statistic, TRUE) OR p-value = NORM.S.DIST(-Z Sample Statistic, TRUE) Two Tail test Negative z Sample Statistic p-value = 2*NORM.S.DIST(Z Sample Statistic, TRUE) Positive z Sample Statistic p-value = 2*NORM.S.DIST(-Z Sample Statistic, TRUE) s Unknown Hypothesis Test for µ (Mean) Hypotheses Null Hypothesis µ Alternative Hypothesis µ Test Type Level of significance Select from = ≤ ≥ Select from  < > (Lower/Upper/Two Tail) α Critical Region NORM.S.INV(probability) = n-1 Table E.3 OR = T.INV(probability,df) OR = T.I Degrees of Freedom Critical Value (s) Sample Data Sample Standard Deviation Sample Mean Sample Size Standard Error of the Mean t Sample Statistic p-value = s/n = (𝑥ҧ -m)/Standard Error =T.DIST(x, df, TRUE) OR NORM.S.DIST(z,TRUE) Decision Critical Value(s) from t Distribution T.INV - Returns the left-tailed inverse of the Student's t-distribution. =T.INV(Cumulative area, n-1) Lower Tail test Critical Value =T.INV(%, n-1) Upper Tail test Critical Value = T.INV(1-%, n-1) T.INV.2T - Returns the two-tailed inverse of the Student's t-distribution. =T.INV.2T(right and left-tailed area, n-1) Two tail Test Critical Values () =T.INV.2T(%, n-1) p-value p-value T.DIST - Returns the Student's left-tailed t-distribution. =T.DIST(x,df,TRUE) T.DIST.RT - Returns the right-tailed Student's t-distribution. =T.DIST.RT(x,df) T.DIST.2T - Returns the two-tailed Student's t-distribution. =T.DIST.2T(ABS(x),df) Lower Tail test p-value = T.DIST(t Sample Statistic, n-1, TRUE) Upper Tail test Lower/Upper/Two Tail) = T.INV(probability,df) OR = T.INV.2T(probability,df) )/Standard Error =T.DIST(x, df, TRUE) OR =T.DIST.2T(x, df) OR =T.DIST.RT(x,df) Categorical data Hypothesis Test for π (Proportion) Hypotheses Null Hypothesis π Alternative Hypothesis π Test Type Level of significance Select from = ≤ ≥ Select from  < > (Lower/Upper/Two Tail) α Critical Region Table E.2 OR = NORM.S.INV(probability) Critical Value (s) Sample Data Sample Size Count of 'Successes' = count of 'Successes'/Sample size) = p*(1-p)/n Sample proportion, p Standard Error Z Sample Statistic p-value = (p -p)/Standard Error Table E.2 OR = NORM.S.DIST(z,TRUE) Decision Critical Value(s) from Standard Normal (Z) Distribution NORM.S.INV - Returns the left-tailed inverse of the Standard Normal Distribution. =NORM.S.INV(Cumulative area) Lower Tail test Critical Value =NORM.S.INV(%) = NORM.S.INV(probability) Upper Tail test Critical Value =NORM.S.INV(1-%) Successes'/Sample size) Two tail Test Critical Values () =NORM.S.INV(1-%/2) = NORM.S.DIST(z,TRUE) p-value NORM.S.DIST - Returns the Standard Normal Distribution. =NORM.S.DIST(z,TRUE) Lower Tail test p-value = NORM.S.DIST(Z Sample Statistic, TRUE) Upper Tail test p-value = 1- NORM.S.DIST(Z Sample Statistic, TRUE) OR p-value = NORM.S.DIST(-Z Sample Statistic, TRUE) Two Tail test Negative z Sample Statistic p-value = 2*NORM.S.DIST(Z Sample Statistic, TRUE) Positive z Sample Statistic p-value = 2*NORM.S.DIST(-Z Sample Statistic, TRUE) ard Normal Distribution. 
Purchase answer to see full attachment