SheetXL - v1.0.2
    Preparing search index...

    Interface TrendlineFit

    A fitted trendline's numbers.

    interface TrendlineFit {
        coefficients: number[];
        rSquared: number;
        type: "linear" | "power" | "exponential" | "logarithmic" | "polynomial";
    }
    Index
    coefficients: number[]
    • linear and polynomial: the coefficients from x⁰ up, [c0, c1, …];
    • exponential: [a, b] of y = a·e^(b·x);
    • logarithmic: [a, b] of y = a·ln(x) + b;
    • power: [a, b] of y = a·x^b.

    x is the series' x on a scatter, else the category's number from 1.

    rSquared: number

    Excel's R²: the square of the correlation between the series' y and the fit's.

    type: "linear" | "power" | "exponential" | "logarithmic" | "polynomial"