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 questionsDomain Joining Data
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.
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.
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.
Keep practicing
Take the free TCP-SP practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other TCP-SP practice questions
- Question 1Which of the following are types of action controls? Choose 3 answers
- Question 2Which two of the following are can be passed lo a script via a parameter? Choose 2 answers
- Question 3Which data relationship algorithm compares two numerical values?
- Question 4Which two of the following are ways to use R scripts in custom expressions? Choose 2 answ…
- Question 5Which namespace contains classes used to interact with visualizations in a document?
- Question 6Which is the right level of permission to be set for a folder in a library?
