444,971 views
8 votes
8 votes
In the Trendline option window (curve fitting), the Set Intercept value is set to zero. What does this mean

User MLister
by
2.7k points

1 Answer

24 votes
24 votes

Answer:

the data is modeled as a proportion

Explanation:

When the trendline is chosen to be linear, the intercept value can be computed from the data, or it can be set to some value of your choosing. When it is set to zero, the data is approximated by a line that goes through the origin. That is, the model is of a proportional relationship.

In the Trendline option window (curve fitting), the Set Intercept value is set to-example-1
User Dilshan
by
3.0k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.