Tibco Spotfire Certified Professional TCP-SP Exam Practice Test

Answer : D, E, F

A box plot is a graphical tool to visualize key statistical measures, such as median, mean and quartiles1. The median is the middle value of the data, which divides the data into two equal halves. The variance is a measure of how spread out the data is, calculated as the average squared deviation from the mean. The standard deviation is the square root of the variance, which has the same unit as the data.A box plot can show these three measures by using the following elements2:

The band in the middle of the box indicates the median.

The bottom and top of the box indicate the first and third quartiles, which are the medians of the lower and upper halves of the data. The difference between the third and first quartiles is called the interquartile range (IQR), which is a measure of variability similar to the standard deviation.

The bottom and top of the whiskers represent the minimum and maximum values within 1.5 times the IQR from the first and third quartiles. Any values outside this range are considered outliers and are shown as individual points. The length of the whiskers is related to the variance of the data, as larger variance implies more spread out data and longer whiskers.

The mean is denoted by a small circle, which may or may not be inside the box depending on how skewed the data is. The mean is another measure of central tendency, which is the average value of the data. The distance between the mean and the median reflects the symmetry of the data distribution.

What is a Box Plot?

Box Plot

Answer : C

TIBCO Spotfire Statistical Services is compatible with several statistical engines, such as S-PLUS, TERR, R, SAS, and MATLAB. These engines provide a comprehensive library of statistical and mathematical algorithms that can be used to perform advanced analytics on data.TIBCO Spotfire Statistical Services can be configured to work with these engines, either as a stand-alone server or as part of a Spotfire stack1. However, TIBCO Spotfire Statistical Services is not compatible with Scala, which is a general-purpose programming language that runs on the Java Virtual Machine.Scala is not a statistical engine, and it does not have a direct integration with TIBCO Spotfire Statistical Services2.Reference:

Spotfire Statistics Services - TIBCO Software

Scala (programming language) - Wikipedia

Answer : B, E

Pie charts and treemaps are both designed to display hierarchical data, as they can show the relative proportions of different categories and subcategories in a nested structure. Pie charts use circular sectors to represent the values, while treemaps use rectangular tiles.Both visualizations can be used to compare the sizes of different groups and drill down into the details12.

Map charts, heat maps, and scatter plots are not specifically designed for hierarchical data, although they can be used to show some aspects of it.Map charts show geographical data on a map, heat maps show the distribution of values in a matrix, and scatter plots show the relationship between two or more variables in a Cartesian coordinate system34.Reference:

Pie Chart - TIBCO Software

Treemap - TIBCO Software

Map Chart - TIBCO Software

Heat Map - TIBCO Software

[Scatter Plot - TIBCO Software]

Answer : A, B, D

Action controls are components that can be added to a text area to perform various actions when clicked. They can be either links, buttons, or images.The actions can include opening TIBCO Spotfire tools, applying bookmarks, navigating to a certain page or visualization, executing scripts, or refreshing data functions1.Scripts are custom actions that use the IronPython scripting functionality to automate tasks or extend the functionality of Spotfire2.Images are not a type of action control, but they can be used as the appearance of an action control1.Reference:Details on Action Control,IronPython Scripting in TIBCO Spotfire

Answer : C

Action control scripts are written in IronPython, which is an implementation of the Python programming language that runs on the .NET Framework.IronPython allows you to access the Spotfire API and create custom actions or tools for your analysis1.You can add action control scripts to a text area and link them to buttons, links, or images2.You can also use JavaScript in HTML mode to add interactivity to your text area3.Reference:

Using Scripts in the Text Area - TIBCO Software

Scripting - TIBCO Spotfire 7.6 - BEGINNER - Skillsoft

Details on Insert JavaScript and JavaScript Example Scripts - TIBCO Software

Answer : D

A treemap visualization is a way of displaying large amounts of hierarchically structured data. The space in the visualization is split up into rectangles that are sized and ordered by a quantitative variable. The treemap in Spotfire uses a squarified algorithm, which means that the rectangles in the treemap range in size from the top left corner of the visualization to the bottom right corner, with the largest rectangle positioned in the top left corner and the smallest rectangle in the bottom right corner. For hierarchies, that is, when the rectangles are nested, the same ordering of the rectangles is repeated for each rectangle in the treemap.Reference:What is a Treemap?,Creating a treemap

Answer : A, B, E

A data function is a reusable calculation that can be applied to data in a Spotfire analysis. A data function can have input and output parameters that define how the data function interacts with the data and the analysis. The input parameters specify what data or values are required for the data function to run, and the output parameters specify what data or values are returned by the data function.The types of input or output parameters for a data function are1:

Column: A column parameter represents a single column of data from a data table. A column parameter can be used as input to provide a vector of values to the data function, or as output to create a new column in the data table or overwrite an existing column. A column parameter can have a data type such as real, integer, string, or boolean.

Document property: A document property parameter represents a value that is stored in the analysis document and can be used to control various aspects of the analysis, such as filters, markings, colors, etc. A document property parameter can be used as input to provide a scalar value to the data function, or as output to create a new document property or overwrite an existing document property. A document property parameter can have a data type such as real, integer, string, boolean, date, or time.

Value: A value parameter represents a scalar value that is entered by the user or calculated by the data function. A value parameter can be used as input to provide a constant or variable value to the data function, or as output to return a single value from the data function. A value parameter can have a data type such as real, integer, string, boolean, date, or time.

The other options, column property, table, and visualization, are not valid types of input or output parameters for a data function.Reference:

Details on Data Functions -- Parameters

Configuring Data Function Parameters

How to select/deselect inputs/outputs/parameters in Statistica Data Function for Spotfire

How to pass input from Spotfire to Statistica Data Function?