Multicollinearity-Aware Variance Driver Detection

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional financial analysis tools struggle to accurately identify primary drivers of variance due to multicollinearity issues while calculating relative weights for predictor variables, making it difficult to determine the individual effect of each independent variable on the dependent variable.

Innovation Solution

A method and system that computes correlations and partial effects between independent variables, estimates row relative weights, and uses weighted Euclidean distances to detect drivers of variance, while accounting for multicollinearity through eigenvector and eigenvalue calculations, and displays results visually.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If conventional financial analysis tools calculate relative weights for predictor variables, then they can identify factors contributing to variance, but multicollinearity issues prevent accurate determination of individual variable effects

Engineering Contradiction:
Improveaccuracy of individual variable effect determinationVSAvoidreliability of relative weight calculation
Core Design Contradiction:
Measurement precisionVSReliability

Solution Approach 1:

The patent segments the calculation process into multiple distinct steps: first computing correlations between independent variables, then calculating partial effects,接着 estimating row relative weights based on squared partial effects, and finally detecting drivers of variance. This segmentation allows each step to address specific aspects of the multicollinearity problem independently, improving both measurement precision and reliability.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces intermediate calculations (correlation matrices, partial effect computations, and squared effect aggregations) as mediators between the raw data and the final relative weight estimates. These intermediaries help isolate and account for multicollinearity effects, enabling more accurate determination of individual variable contributions despite intercorrelations.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Measurement precision

If marketing teams manually scan general ledgers to identify drivers of change, then they can find variance drivers, but it consumes substantial time and resources

Engineering Contradiction:
Improveaccuracy of driver identificationVSAvoidtime spent on manual analysis
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The system enables self-service automated analysis by computing all necessary statistics (correlations, partial effects, relative weights) and automatically detecting drivers of variance without requiring manual intervention. The processor executes the complete analysis pipeline autonomously, eliminating the need for marketing teams to manually scan general ledgers while maintaining accurate driver identification.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent replaces the manual mechanical process of scanning and analyzing general ledgers with an automated computational system. The processor-based system performs calculations and detections that were previously done manually, substituting human effort with algorithmic processing to reduce time loss while preserving analytical accuracy.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

3Adaptability or versatility

If existing financial analysis tools are used, then basic expense analysis can be performed, but they lack the ability to solve multicollinearity issues

Engineering Contradiction:
Improvecapability to handle multicollinearityVSAvoidcomplexity of analysis methodology
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the complex analysis into modular computational steps that can be implemented sequentially: correlation computation, partial effect calculation, squared effect aggregation, and variance driver detection. This segmentation makes the sophisticated multicollinearity handling achievable through standard computational operations, increasing adaptability without proportionally increasing perceived complexity.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system performs multiple functions within a unified framework: it computes correlations, calculates partial effects, estimates relative weights, and detects variance drivers all through a single integrated process. This multi-functionality allows the tool to handle multicollinearity issues while maintaining ease of use, as users need only provide input data and receive comprehensive results without managing separate analytical procedures.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS20250307935A1System and method for detecting driver of variance
Publication Date: 2025.10.02 JPMORGAN CHASE BANK NA
  • US20250307935A1 patent drawing
  • US20250307935A1 patent drawing
  • US20250307935A1 patent drawing

AI summary

A system and method for detecting driver of variance are disclosed. The method includes receiving dependent variable(s) (y) and a set of independent variables (Xn). Next, the method includes computing a correlation (Rxx) between at least two of the independent variables and then calculating a partial effect (β) of each of the independent variables on the dependent variable(s) (y). The method includes estimating a row relative weight as a percentage of coefficient of determination R2 based on a sum of squared values of the calculated partial effect of the independent variables. The method includes determining a distance from median of x-coordinate (DFM x) and y-coordinate (DFM y) of the set of independent variables. The method includes detecting and displaying at least one driver of variance calculated via a weighted Euclidean distance calculated based on the DFM x and DFM y, and the estimated row relative weight.