Spotfire Analytics and Statistics Flashcards

What does the 'Case' function in Spotfire's expression syntax accomplish?

Answer: Implements conditional logic returning different values based on tested conditions

The Case function evaluates a series of conditions and returns the corresponding value for the first condition that is true.

In Spotfire, what does the 'UniqueCount' aggregation function return?

Answer: Count of distinct non-null values in a column

UniqueCount counts only distinct values, ignoring duplicates and nulls, useful for measuring cardinality.

Which Spotfire function calculates a running cumulative total within a partitioned group?

Answer: RunningSum([Value]) OVER ([Category])

RunningSum with OVER computes a cumulative running total that resets per partition defined in the OVER clause.

What does the 'StandardDeviation' aggregation in Spotfire measure?

Answer: The spread of values around the mean as the square root of variance

Standard deviation measures how spread out values are from the mean, calculated as the square root of the variance.

In Spotfire, what is the purpose of 'Fit Model' in the statistics pane?

Answer: Fits a statistical curve (linear, polynomial, logistic, etc.) to chart data with diagnostics

Fit Model overlays a mathematical regression model on the visualization and displays fit statistics like R², p-values, and coefficients.

What does the 'Percentile([Value], 0.75)' expression compute in Spotfire?

Answer: The value below which 75% of the data falls (3rd quartile)

Percentile(column, 0.75) returns the 75th percentile — the value at or below which 75% of observations fall.