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 video. Thank you for watching! Elizabeth
*Michigan’s bridges are bad — and a fix could take nearly a centuryhttps://www.freep.com/in-depth/news/investigations/2019/05/14/interactive-bridges-michigan-roads/2305976002/