Microsoft Office Tutorials and References
In Depth Information
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.
18.104.22.168 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 ::