Microsoft Office Tutorials and References
In Depth Information
Fig. 6.20
Example of a chart that is enlarged to fit the cells: A29:H48
Save the file 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 fit 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-fitting’’ 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