Something New For Today

It takes a lot of money to build and repair bridges. By some estimates, it will take 100 years to fix the roads in Michigan*. Who owns these bridges? When was the last inspection? What is the rating?

This lesson analyzes actual transportation data using Statistical Functions in Excel to answer important questions:
AVERAGEIF- What is the average number of months since the last inspection?
COUNTIFS- How many bridges in this County are in good repair?
MAXIFS -What is the greatest number of lanes that cross the bridge?
MINIFT: What is the oldest bridge?

I enjoyed creating this lesson. Thank you for watching! eBeth

*Michigan’s bridges are bad — and a fix could take nearly a century…