Practice challenge
Average customer response time
#4
3 attempts remaining
BeginnerCustomersTarget F2
A support team records response time in hours for four tickets.
Write a formula for F2 that returns the average response time.
Average customer response time
Swipe horizontally to view the full table.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| # | Agent | Ticket 1 | Ticket 2 | Ticket 3 | Ticket 4 | Average |
| 2 | Maya | 2.5 | 1.75 | 3 | 2 | blank |
| 3 | Luis | 1.25 | 1.5 | 2 | 1.75 | blank |
| 4 | Ava | 4 | 3.5 | 2.75 | 3.25 | blank |