Microsoft Office Tutorials and References

In Depth Information

File

Print

Print (see Fig.
6.24
)

Fig. 6.24

Final spreadsheet of regression line on a chart (80 % scale to ﬁt size)

Save your ﬁle as: eggs35

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.

Search JabSto ::

Custom Search