Auto Safety
You work for an automatic insurance company. Your boss has assigned you the task of reviewing recent auto safety records and thinking about how that information may be relevant to your company. You found these data on the web.
HIGHWAY LOSS
DATA
INSTITUE
(www.hwysafety.org)
AUTOMOBILE INSURANCE INJURY LOSSES (2000-01)
|
Small Cars
|
|
Mid-Size Cars
|
|
Large Cars
|
|
Model
Rating
|
Model
Rating
|
Model
|
Rating
|
|
A4 Quattro
|
|
63
|
Saab 9-3
|
|
58
|
Buick LeSabre
|
39
|
|
Audi A4
|
|
67
|
Buick Century
|
|
63
|
Bonneville
|
53
|
|
VW Beetle
|
|
69
|
Toyota Avalon
|
|
66
|
Grand Marquis
|
53
|
|
Volvo S40
|
|
82
|
Volvo S70
|
|
72
|
Buick Regal
|
57
|
|
VW Golf
|
|
91
|
Lexus ES 300
|
|
75
|
Olds Intrigue
|
58
|
|
Impreza
|
|
98
|
Saturn LS
|
|
76
|
Crowns Victoria
|
63
|
|
Subaru G20
|
|
104
|
Acura
|
|
78
|
Concorde
|
66
|
|
Saturn SL
|
|
104
|
VW Passat
|
|
80
|
Chrysler LHS
|
66
|
|
Honda Civic
|
|
105
|
Infiniti I30
|
|
82
|
Chrysler 300
|
70
|
|
VW Jetta
|
|
107
|
Maxima
|
|
94
|
Chevy Impala
|
73
|
|
Chevy Prizm
|
|
118
|
Chevy Malibu
|
|
97
|
Chevy Lumina
|
73
|
|
Ford Focus
|
|
120
|
Olds Alero
|
|
97
|
Grand Prix
|
74
|
|
Acura Integra
|
|
133
|
Cirrus
|
|
98
|
Mercury Sable
|
80
|
|
Nissan Sentra
|
|
134
|
Honda Accord
|
|
102
|
Monte Carlo
|
85
|
|
Eclipse
|
|
136
|
Toyota Camry
|
|
102
|
Ford Taurus
|
88
|
|
Chevy Metro
|
|
138
|
Grand AM
|
|
105
|
Dodge Intrepid
|
90
|
|
Ford Escort
|
|
141
|
Mystique
|
|
108
|
|
|
Civic Coupe
|
|
143
|
Diamante
|
|
109
|
|
|
Protégé
|
|
144
|
Millenia
|
|
114
|
|
|
Corolla
|
|
147
|
Ford Contour
|
|
118
|
|
|
Dodge Neon
|
|
167
|
Dodge Stratus
|
|
122
|
|
|
Accent
|
|
181
|
Breeze
|
|
128
|
|
|
Elantra
|
|
190
|
Cavalier
|
|
134
|
|
|
Kia Sephia
|
|
221
|
Mazda 626
|
|
135
|
|
|
Mirage
|
|
246
|
Sunfire
|
|
140
|
|
|
Esteem
|
|
247
|
Nissan Altima
|
|
144
|
|
|
|
|
Galant
|
|
164
|
|
|
|
|
Sonata
|
|
169
|
|
|
Insurance injury loss results are stated in relative terms. 100 represent average result for all cars.
|
|
Lower numbers are better. For example, a rating 122 means 22% worse than average.
|
Write a report to your boss, including:
-
Appropriate comparative plots and summary statistics;
-
Descriptions of the injury ratings for each group of cars;
-
A comparison of injury ratings for the three sizes of cars;
-
Your recommendation to your boss about your company’s insurance policies.
Price: $10.92
Solution: The downloadable solution consists of 8 pages, 292 words and 2 charts.
Deliverable: Word Document
