nerdexam
CompTIA

DA0-001 · Question #392

A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula: volume = height ?width ?depth. Which of the following variable types…

The correct answer is A. Derived. The variable 'volume' is a derived variable because its value is calculated by combining other existing variables using a specific formula.

Data Analysis

Question

A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula: volume = height ?width ?depth. Which of the following variable types describes volume?

Options

  • ADerived
  • BNormalized
  • CConcatenated
  • DAggregated

How the community answered

(27 responses)
  • A
    93% (25)
  • B
    4% (1)
  • D
    4% (1)

Why each option

The variable 'volume' is a derived variable because its value is calculated by combining other existing variables using a specific formula.

ADerivedCorrect

A derived variable is one whose value is computed through a mathematical operation or transformation applied to one or more other variables. In this scenario, 'volume' is explicitly calculated using 'height', 'width', and 'depth', making it a prime example of a derived variable.

BNormalized

Normalized variables typically refer to data scaled to a standard range or reduced in redundancy, which does not apply to a direct calculation like volume.

CConcatenated

Concatenated variables are formed by joining textual data, not by performing arithmetic operations on numerical values.

DAggregated

Aggregated variables involve summarizing data from multiple entries or observations, whereas 'volume' is calculated for a single distinct entity from its own properties.

Concept tested: Data variable types - derived

Topics

#Derived variables#Data transformation#Calculated fields#Variable types

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice