Microsoft Office Tutorials and References

In Depth Information

Fig. 6.20

Example of a chart that is enlarged to ﬁt the cells: A29:H48

Save the ﬁle as: eggs34

Important note: If you printed eggs34 now, it would ‘‘dribble over’’ to four pages

of printout because the scale needs to be reduced below 100

percent in order for this spreadsheet to ﬁt onto only one page.

Now, let’s draw the regression line onto the chart. This regression line is called

the ‘‘least-squares regression line’’ and it is the ‘‘best-ﬁtting’’ straight line through

the data points.

6.3.1.4 Drawing the Regression Line Through the Data Points in the Chart

Objective: To draw the regression line through the data points on the chart

Right-click on any one of the data points inside the chart

Add Trendline (see Fig.
6.21
)

Search JabSto ::

Custom Search