Question

use the cat scores worksheet in data sets. why is there 14 in cell h5 but only 11 in cell j5? 14. what formula is in cell j6?

Explanation:

Step1: Analyze cell H5

Cell H5 shows the count of scores less than 22 using a cumulative - count method. It includes all scores in the range of less than 22, which is 14.

Step2: Analyze cell J5

Cell J5 shows the frequency of scores in the bin [18...22). It only counts scores that are greater than or equal to 18 and less than 22. So some scores counted in H5 (scores less than 18) are not counted in J5, resulting in 11.

Step3: Guess formula for J6

Assuming a common frequency - counting method like COUNTIFS, for the bin [26...30), the formula in J6 might be something like =COUNTIFS(scores,">=26",scores,"<30")

Answer:

For the first question: Cell H5 uses a cumulative count less than 22 while cell J5 counts within the [18...22) range.
For the second question: A possible formula is =COUNTIFS(scores,">=26",scores,"<30")