Microsoft Office Tutorials and References
In Depth Information
Fig. 6.13 Final Result of Using the
¼
correl Function to Compute the Correlation Coefficient
Let’s suppose that you would like to use weight as the predictor variable, and
that you would like to use it to predict the number of eggs produced in this species
of fish. Since the correlation between these two variables is
.87 , this shows that
there is a strong, positive relationship and that weight is a good predictor of eggs
produced.
þ
1. Open the file that you saved earlier in this chapter:
eggs33
6.3.1 Using Excel to Create a Chart and the
Regression Line Through the Data Points
Objective : To create a chart and the regression line summarizing
the relationship between weight and eggs produced
Search JabSto ::




Custom Search