Statistical Functions
Intermediate

A response rate from COUNT and COUNTA

Numeric answers divided by people asked.

Task:

Eight customers were asked for a score out of 10; some replied with a number, some wrote a comment instead, some ignored it. In B11 give the share of customers who gave a numeric score.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of COUNT, COUNTA

0/3

The same formula in the other shapes it takes at work.

  1. COUNT Function (Statistical)

    The denominator, before you quote any statistic at all.

    Core
    Beginner
  2. A response rate from COUNT and COUNTA

    Numeric answers divided by people asked.

    Intermediate
  3. COUNT over a block

    One range can cover a whole grid of readings.

    Beginner

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

11 rows × 2 columns1 cell you fill in
AB
1CustomerScore
2K. Ahmed9
3L. Brown
4M. Costa7
5N. DuboisToo early to say
6O. Evans10
7P. Fischer6
8Q. Garcia
9R. Hall8
10
11Numeric response rate
What this exercise teachesMay contain the answer

Dividing by COUNTA of the scores would make the comment count as a respondent; dividing by a typed 8 breaks when a row is added. Counting the names keeps the denominator honest, and the result tells you how much weight the average score can bear.