Skip navigation

Use COUNTIF to analyze trends

Use COUNTIF to analyze trends: Excel Workshop: Working with Real-Time Data
Use COUNTIF to analyze trends: Excel Workshop: Working with Real-Time Data

Calculate accident rates under each weather category in order to understand the relative risk of driving in dry, rainy or snowy conditions. Use Excel’s COUNTIF function to determine the average number of accidents per day under each weather type, and compare rates to quantify estimated levels of risk.

  • Overview
  • Transcript
  • View Offline
Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 18m
Duration
52,713
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now