시작하기무료로 시작하기

Averages and IF conditions

So the West and North precincts appear to have higher levels of crime. But do these crimes tend to occur at different times of the day? The Seattle PD not only has to allocate resources between precincts; they also have to determine which times of day require the most officers. You can help them determine where and when to dispatch officers using more of the "IF" functions you've learned.

Remember that these functions take a range of cells to evaluate, the criterion to evaluate, and the range of cells to which to apply the function.

이 연습은 강의의 일부입니다

Google Sheets로 배우는 오류와 불확실성

강의 보기

연습 안내

  • In cell H2, calculate the average time at which crimes occurred in the West precinct.
  • Do the same for the South, Unknown, Southwest, North, and East precincts in cells H3:H7, respectively.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작