Count records, entries, blanks, or matching values to understand how often something happens.
How Many Students Have Paid?
A teacher is organizing a school trip. The sheet lists each student’s lunch choice, the amount they paid, and whether they returned their permission slip. How many students have paid for the trip? (If there is a number in the 'Amount paid' column, the student has paid; if it is blank, they have not.)
How Many Returned the Permission Form?
Using the same school trip sheet, count how many students returned the permission slip by providing any answer ('Yes' or 'No'). Remember, both 'Yes' and 'No' count as a response.
How Many Students Haven’t Picked Their Lunch?
Using the same school trip sheet, each student chose either 'Veg' or 'Meat' for lunch. If a cell is blank, that student hasn’t made a choice yet. How many students have not selected their lunch option?
How Many Visits to Emergency?
A clinic is reviewing today’s patient visits. The table lists each visit’s department, whether the patient saw a doctor, and the wait time. How many visits were to the Emergency department? Count all visits to Emergency, regardless of whether the patient saw a doctor.
How Many Emergency Patients Saw a Doctor?
Using the same clinic visit table, how many Emergency department patients were actually seen by a doctor? Count only those visits where both conditions are met: Department is Emergency and Doctor seen is Yes.
How Many Emergency Patients Waited Over an Hour?
Using the same clinic visit table, Emergency patients are meant to be seen within an hour. How many Emergency visits had a wait time over 60 minutes? Count only those visits where the Department is Emergency and the wait was more than an hour.
How Many Drivers Delivered the Most Parcels?
A delivery company tracks how many parcels each driver delivered today. Multiple drivers reached the highest number of deliveries in a single day. How many drivers delivered the maximum number of parcels?
How Many Branches Used More Than Average Electricity?
A company wants to identify which of its 8 branches are heavy electricity users. How many branches used more electricity than the average for all branches?