velonsa.blogg.se

Excel trendline equation wrong
Excel trendline equation wrong




In fact, the question is not limited to LINEST() and Excel. And there is a real question of whether the const argument is a useful option at all. Setting the const argument to FALSE can easily have major implications for the nature of the results that LINEST() returns.

  • stats, if TRUE, tells LINEST() to include statistics that are helpful in evaluating the quality of the regression equation as a means of gauging the strength of the relationship between the Y values and the X values.
  • If const is FALSE, the constant is omitted from the equation. If const is TRUE or omitted, the constant is calculated and included.

    excel trendline equation wrong

    const is either TRUE or FALSE, and indicates whether LINEST() should include a constant (also called an intercept) in the equation, or should omit the constant.X values represents the range that contains the variable or variables that are used as predictors.Y values represents the range that contains the outcome variable (or the variable that is to be predicted by the regression equation).=LINEST(Y values, X values, const, stats)

    excel trendline equation wrong

    One of the options that has always been available in Excel's LINEST() worksheet function is the const argument, short for constant.






    Excel trendline equation wrong