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

User Steveax
by
3.2k points

1 Answer

9 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 Verysuperfresh
by
3.2k points