Microsoft Office Tutorials and References

In Depth Information

Fig. 6.11
Example of Using Excel to Find the Sample Size, Mean, and STDEV

relationship between these two variables. In effect, the higher the weight, the more

eggs produced by the ﬁsh.

Save this ﬁle as: eggs33

The ﬁnal spreadsheet appears in Fig.
6.13
.

6.3 Creating a Chart and Drawing the Regression

Line onto the Chart

This section deals with the concept of “linear regression.” Technically, the use of a

simple linear regression model (i.e., the word “simple” means that only one

predictor, X, is used to predict the criterion, Y) requires that the data meet the

following four assumptions if that statistical model is to be used:

1. The underlying relationship between the two variables under study (X and Y) is

linear
in the sense that a straight line, and not a curved line, can ﬁt among the

data points on the chart.

Search JabSto ::

Custom Search