Which Excel Function Would Not Be Appropriate to Use When

question 61

Multiple Choice

Which Excel function would not be appropriate to use when conducting a hypothesis test for a population proportion?

• A)NORM.S.DIST
• B)COUNTIF
• C)STDEV
• D)All are appropriate.

---

Definitions:

Reapply

The action of applying a previous action or setting again in order to ensure current data or content conforms to a specific standard or format.

Filter

A tool in data processing and analysis that allows for the narrowing down of data sets by specifying criteria to display only the data that meet those criteria.

LOCATE

A command or function in programming and software applications that is used to find and identify the position of a specified piece of data within a file or database.

LOOKUP

A function used in spreadsheet programs that searches one or more rows or columns for a specified value and returns a corresponding value from a different row or column in the same range.