Excel's __________ can be used to construct a frequency distribution for quantitative data.
A) COUNTIF function
B) SUM function
C) PivotTable report
D) AVERAGE function

Question

Quizplus · Accepted Answer

PivotTable reports in Excel can be used to construct frequency distributions for quantitative data by summarizing and grouping the data into intervals or bins. The resulting table displays the count, sum, average, or other function of the data within each interval or bin. The COUNTIF function can also be used to count the number of occurrences of a specific value or range of values in a data set, but it does not group the data into intervals or bins. The SUM and AVERAGE functions are used to calculate the total or average of a range of values, but they do not create frequency distributions.

Excel's __________ Can Be Used to Construct a Frequency Distribution