What Formula Auditing Tool Can Be Used to Control the Data

question 20

Multiple Choice

What formula auditing tool can be used to control the data input from the user?

• A)IFERROR
• B)Data validation
• C)Watch Window
• D)Trace dependents

---

Definitions:

Sample Variance

A measure of how datapoints in a sample are spread out from their sample mean, quantifying the extent of variation within the sample.

Kurtosis

A measure of the "tailedness" of the probability distribution of a real-valued random variable; high kurtosis indicates a distribution with heavy tails and a sharp peak, while low kurtosis indicates a flatter distribution.

Histogram

This is a graphical representation of data using bars of different heights where each bar groups numbers into ranges.

Unimodal

Describing a distribution with a single peak or mode, representing the most frequently occurring value.