Question

1) Excel's _____________ can be used to construct a frequency distribution for quantitative data.

a) COUNTIF function

b) AVERAGE function

c) FREQUENCEY function

d) none of these answers is correct

e) SUM function

2) Excel's ______________ can be used to construct a frequency distribution for qualitative data.

a) Pivot Table report

b) COUNTIF function

C) chart wizard

d) SUM function

e) none of these answers is correct

3) The relative frequency of a class is computed by

a) None of these answers is correct

b) dividing the frequency of the class by the midpoint.

c) dividing the sample size by the frequency of the class.

d) dividing the frequency of the class by the sample size.

e) dividing the midpoint of the class by the sample size.

4) The sum of the relative frequencies for all classes will always equal:

a) 100

b) none of these answers is correct

c) the sample size

d) one

e) the number of classes

5) The percent frequency of a class is computed by

a) using the Excel % icon to change the relative frequency.

b) None of these answers is correct

c) dividing the relative frequency by 100.

d) multiplying the relative frequency by 10.

e) adding 100 to the relative frequency.

Answer 1

1) c) FREQUENCEY function

2)

COUNTIF function

3)

d) dividing the frequency of the class by the sample size.

4)

d) one

5)

a) using the Excel % icon to change the relative frequency.