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 ::