Trend Modeling

by zircote

data

This skill should be used when the user asks to "model trends with limited data", "three-valued logic analysis", "scenario generation", "transitional graphs", "qualitative trend analysis", "uncertain data analysis", "minimal-information modeling", or needs guidance on trend-based modeling using INC/DEC/CONST logic, scenario planning with limited quantitative data, or generating transitional scenario graphs.

Skill Details

Repository Files

4 files in this skill directory


name: Trend Modeling description: This skill should be used when the user asks to "model trends with limited data", "three-valued logic analysis", "scenario generation", "transitional graphs", "qualitative trend analysis", "uncertain data analysis", "minimal-information modeling", or needs guidance on trend-based modeling using INC/DEC/CONST logic, scenario planning with limited quantitative data, or generating transitional scenario graphs. version: 0.1.0

Trend Modeling with Three-Valued Logic

Overview

Based on research in trend-based optimization for product innovation, this skill applies three-valued logic (increasing/decreasing/constant) to analyze markets when precise numerical data is unavailable. This approach enables meaningful analysis with minimal information.

Core Concept

Traditional market analysis requires extensive quantitative data. Three-valued logic provides an alternative when:

  • Data is scarce or unreliable
  • Relationships are qualitative
  • Uncertainty is high
  • Quick directional insights are needed

The Three Values

INC (Increasing)

  • Variable is trending upward
  • Rate of increase may be accelerating (AG) or decelerating (DG)
  • Symbol: ↑ or (+)

DEC (Decreasing)

  • Variable is trending downward
  • Rate of decrease may be accelerating (AD) or decelerating (DD)
  • Symbol: ↓ or (-)

CONST (Constant)

  • Variable is stable or unchanged
  • OR insufficient data to determine direction
  • Symbol: → or (=)

Extended Notation

For more nuanced analysis:

Code Meaning Description
AG Accelerating Growth INC with increasing rate
DG Decelerating Growth INC with decreasing rate
AD Accelerating Decrease DEC with increasing rate
DD Decelerating Decrease DEC with decreasing rate

Correlation-to-Trend Conversion

Transform correlation relationships into trend relationships:

If variables X and Y have positive correlation:

  • When X is INC → Y is INC
  • When X is DEC → Y is DEC
  • Notation: INC(X, Y)

If variables X and Y have negative correlation:

  • When X is INC → Y is DEC
  • When X is DEC → Y is INC
  • Notation: DEC(X, Y)

Example:

  • Market size and competition have positive correlation
  • If Market Size = INC, then Competition = INC
  • If Market Size = DEC, then Competition = DEC

Trend Model Construction

Step 1: Identify Variables

List market variables of interest:

  • Market size
  • Competition intensity
  • Price pressure
  • Innovation rate
  • Customer adoption
  • Regulatory burden

Step 2: Determine Relationships

For each pair of variables:

  • Identify correlation direction (positive/negative)
  • Convert to trend relationship (INC/DEC)

Step 3: Build Trend Matrix

Variable Market Size Competition Price Innovation
Market Size - INC DEC INC
Competition INC - DEC CONST
Price DEC DEC - DEC
Innovation INC CONST DEC -

Step 4: Generate Scenarios

A scenario is a consistent assignment of INC/DEC/CONST to all variables that satisfies all relationships.

Step 5: Identify Terminal Scenarios

Terminal scenarios are equilibrium states where:

  • All relationships are satisfied
  • System is stable
  • No further transitions occur

Transitional Scenario Graphs

Create Mermaid diagrams showing scenario evolution:

stateDiagram-v2
    [*] --> S1: Initial conditions

    S1: Scenario 1<br/>Market=INC, Comp=INC<br/>Price=DEC, Innov=INC

    S2: Scenario 2<br/>Market=CONST, Comp=INC<br/>Price=DEC, Innov=CONST

    S3: Scenario 3 (Terminal)<br/>Market=DEC, Comp=CONST<br/>Price=CONST, Innov=DEC

    S4: Scenario 4 (Terminal)<br/>Market=INC, Comp=INC<br/>Price=DEC, Innov=INC

    S1 --> S2: Market saturation
    S1 --> S4: Sustained growth
    S2 --> S3: Commoditization
    S2 --> S4: Innovation breakthrough

Multi-Objective Trade-offs

From the research: "No scenario satisfies all objective functions simultaneously."

When analyzing terminal scenarios:

  1. Identify competing objectives
  2. Map which scenarios favor which objectives
  3. Highlight trade-offs required
  4. Recommend based on priority alignment

Application to Market Analysis

Use Case: New Market Entry

Variables:

  • Market Growth (MG)
  • Competitive Intensity (CI)
  • Entry Barriers (EB)
  • Customer Awareness (CA)

Relationships:

  • INC(MG, CI) - Growing markets attract competitors
  • INC(MG, CA) - Growth increases awareness
  • DEC(EB, CI) - Lower barriers increase competition
  • INC(CA, MG) - Awareness drives growth

Scenarios Generated:

  1. Explosive growth: MG=AG, CI=AG, EB=DEC, CA=AG
  2. Mature equilibrium: MG=DG, CI=CONST, EB=CONST, CA=CONST
  3. Consolidation: MG=DEC, CI=DEC, EB=INC, CA=CONST

Output Structure

## Trend Model Summary

### Variables
| Variable | Current State | Trend | Confidence |
|----------|---------------|-------|------------|
| [Name] | [Description] | INC/DEC/CONST | High/Med/Low |

### Relationship Matrix
[Matrix showing INC/DEC relationships]

### Generated Scenarios
| Scenario | Var1 | Var2 | Var3 | Terminal? |
|----------|------|------|------|-----------|
| S1 | INC | DEC | CONST | No |
| S2 | CONST | CONST | DEC | Yes |

### Transitional Graph
[Mermaid state diagram]

### Terminal Scenario Analysis
**Scenario X**: [Description]
- Conditions: [What leads here]
- Trade-offs: [What must be sacrificed]
- Recommendation: [Strategic implication]

### Key Insights
1. [Insight about scenario transitions]
2. [Insight about trade-offs]

Best Practices

  • Start simple: Begin with 4-6 variables
  • Validate relationships: Check with domain experts
  • Document uncertainty: Note where relationships are speculative
  • Update iteratively: Refine model as new information emerges
  • Focus on transitions: The paths between scenarios often matter more than endpoints

Advantages of This Approach

From the research:

  • "No numerical values of constants or parameters are needed"
  • "A complete list of all futures/histories is obtained"
  • "Results remain easy to understand without knowledge of sophisticated mathematical tools"

Additional Resources

For theoretical background and advanced techniques, see:

  • references/three-valued-logic.md - Theoretical foundation
  • references/scenario-generation.md - Algorithm details
  • examples/trend-model-example.md - Worked example

Related Skills

Xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

Data Storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

data

Kpi Dashboard Design

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

designdata

Dbt Transformation Patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

testingdocumenttool

Sql Optimization Patterns

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

designdata

Anndata

This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.

arttooldata

Xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

tooldata

Skill Information

Category:Data
Version:0.1.0
Last Updated:1/22/2026