Question

guided practice activity #12 - cat scores
we will use the cat scores worksheet in data sets.
h6
fx =countif(scores,\<26\)
1 cat scores
2 data set
3 count scores
4 1 35
5 2 24
6 3 25
7 4 29
8 5 26
9 6 27
10 7 30
descriptive
statistics (avg ch data
mean 26.0
median 26
mode 24
stdev 4.5
max 35
min 12
histogram
bins freq
<18 3 0...18)
<22 14 18... 22)
<26 45 22... 26)
<30 26...30)
<34 30... 34)
<38 34... 38)

1. what formula should be typed into cell h7?

Explanation:

Step1: Analyze the pattern

Cell H6 has a COUNTIF formula to count values less than 26. Cell H7 should count values less than 30 according to the bins in the histogram.

Step2: Write the formula

The formula should be =COUNTIF(scores,"<30")

Answer:

=COUNTIF(scores,"<30")