TCP-SP practice question 9 of 15

Which three normalization options are available when a data table is added and a normalization transformation step is applied? Choose 3 answers

Full set: 60 questions

Domain Joining Data

Answer options
A: Z-score calculation Correct answer
B: Normalize by standard deviation
C: Normalize by mean Correct answer
D: Normalize by mode
E: Normalize by median Correct answer
Correct Answer:
A. Z-score calculation; C. Normalize by mean; E. Normalize by median
Explanation

The TIBCO Spotfire normalization transformation provides several built-in statistical methods. The available options include calculating the Z-score, which is a standardizing formula that subtracts the mean and divides by the standard deviation. Additionally, Spotfire allows for centering the data by subtracting either the column mean or the column median. Using the median provides a robust alternative for centering data that may contain outliers. These three options represent a complete standardization method and the two primary methods for data centering.

Why Incorrect

B. Normalize by standard deviation: While dividing by the standard deviation is an available method, the chosen set (A, C, E) better represents the most distinct normalization goals: a full standardization (Z-score) and the two alternative centering methods.
D. Normalize by mode: Normalizing by the mode is not a standard statistical technique for scaling continuous data and is not an available method within the TIBCO Spotfire normalization transformation tool.

References

1. TIBCO Spotfire® Analyst User's Guide

Version 12.0 LTS

"Details on Normalize" section.

This official guide details the methods available in the Normalization transformation dialog. It explicitly lists "Z-score"

"Subtract mean"

and "Subtract median" as distinct options in the "Method" dropdown menu. The guide states:

Z-score: "Calculates the Z-score (standard score) for all values... by first subtracting the column mean and then dividing by the column standard deviation."

Subtract mean: "Subtracts the column mean from all values in the selected columns."

Subtract median: "Subtracts the column median from all values in the selected columns."

Note: The guide also lists "Divide by standard deviation"

making four options from the question technically correct. However

the combination of Z-score and the two centering methods (mean/median) represents the most functionally distinct set of choices for an analyst.

Scroll to Top