TIBCO Spotfire Analytics and Statistics 2

Question 1

What does the OVER function in Spotfire expressions allow you to compute?

Accepted Answer

Aggregations scoped to a specific set of columns (window/grouping context)

Answer

OVER performs an aggregation partitioned by specified columns, similar to SQL window functions, without collapsing rows.

Question 2

In Spotfire, what does the function 'Rank([Value]) OVER ([Category])' compute?

Accepted Answer

Rank of each value within its category group

Answer

Using OVER partitions the ranking by the specified category, so each group gets its own independent rank sequence.

Question 3

Which Spotfire function returns the value of a column from the previous row when data is ordered by a specific column?

Accepted Answer

Lag

Answer

Lag retrieves the value from a preceding row by a specified offset, useful for period-over-period calculations.

Question 4

What is the purpose of the 'NodeId()' function in Spotfire's expression language?

Accepted Answer

Returns the internal row index identifier for each row

Answer

NodeId() returns Spotfire's internal zero-based row index, useful for uniquely identifying rows in expressions.

Question 5

In Spotfire, what does 'Correlation coefficient' as a trend line statistic measure?

Accepted Answer

The strength and direction of the linear relationship between X and Y

Answer

The correlation coefficient (r) ranges from -1 to +1 and quantifies how strongly and in which direction two variables are linearly related.

TIBCO - Spotfire Practice Test