What Affects Auto Insurance Costs? Understanding the Data
Submitted By:Nina Hoe, University of Pennsylvania
Date:July 1, 2011
Grade Level(s):9, 10, 11, 12
In this lesson, students read the Knowledge@Wharton High School article, “Driver Alert: Car Insurance Will Cost You,” and look at data that compares average annual insurance expenditures, number of traffic fatalities, deaths per 100 million vehicle miles traveled, percentages of population living in urban areas, per capita incomes by state and state population. Students will use Microsoft Excel to examine statistics by state and produce scatter plots to investigate the relationship between several factors and the average annual auto insurance expenditure per state. Additionally, students sort these data to better understand statistical factors that affect auto insurance expenditures. *Note: This activity requires students to use computers with Microsoft Excel. If computers are not available for individual students, the teacher can project this on the overhead.
Computation, II. Number Relationships and Operations