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

question 52

Multiple Choice

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

---

Definitions:

Horizontal Axis

In a graph or chart, the horizontal line along which the values of one variable are plotted or measured.

Vertical Axis

In graphing data, this is the y-axis, which is typically used to measure the dependent variable or show the scale of values in a chart.

Utility Function

A mathematical representation of how consumer preferences over a set of goods and services are ranked.

Horizontal Axis

In a graphical representation, the x-axis, which typically shows the independent variable or the quantity of goods.