Skip to Main Content
Spotfire Ideas Portal
Status Already exists
Product Spotfire
Categories Analytics
Created by Guest
Created on Mar 30, 2020

Perform combination when doing Spearman R, rather than permutations

The Spearman Rank under Data Relationships analyzes the correlation based on all permutation of the specified X & Y parameters specified.

There is an inefficiency as the results of the correlation of A to B is the same as correlation of B to A. As a result the number of analysis performed is twice as many as required.

Example:

X-Parameters

A

B

C

Y parameters:

A

B

C

currently the analysis performed are:

A - B

A - C

B - A

B - C

C - A

C - B

however, all that is required is

A - B

A - C

B - C

I am requesting that the spearman rank tool be updated to either only form analysis

a) on the combination of parameters rather than permutations.

b) or provide an option(checkbox) to perform a combination of parameters rather than permutations.

Impact will be 2x faster processing and 1/2 the data storage in the resulting datatable.

  • ADMIN RESPONSE
    Apr 6, 2022

    The implementation is aware about the symmetric nature of this task and does not duplicate the calculations. The results of the calculations are shown for all permutations though, but this has very minor impact on performance.

  • Attach files