Microsoft Office Tutorials and References
In Depth Information
Fig. 6.22 Dialogue Box for a Linear Trendline
6.5 Finding the Regression Equation
The main reason for charting the relationship between X and Y (i.e., weight as X
and eggs produced as Y in our example) is to see if there is a strong enough
relationship between X and Y so that the regression equation that summarizes
this relationship can be used to predict Y for a given value of X.
Since we know that the correlation between the weight of the ﬁsh and the
number of eggs produced is
.87 , this tells us that it makes sense to use weight
to predict eggs produced based on past data.
Search JabSto ::