Microsoft Office Tutorials and References

In Depth Information

Fig. 6.13
Final Result of Using the

¼

correl Function to Compute the Correlation Coefﬁcient

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 ﬁsh. 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 ﬁle 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