Microsoft Office Tutorials and References
In Depth Information
Fig. 6.28 Dialogue Box for Adding the Regression Equation to the Chart Next to the Regression
Line on the Chart
Y
¼
bX
þ
a
(6.4)
where a
¼
y-intercept and b
¼
slope of the line
Note that this equation is identical to the one we are using in this topic with the
terms arranged in a different sequence.
For the example we used in Sect. 6.5.3, Excel 2007 would write the regression
equation on the chart as:
¼
þ
Y
24.73
This is the format that will result when you add the regression equation to the
chart using Excel 2007 using the following steps:
0.0165 X
Open the file: eggs36 (that you saved in Sect. 6.5.2)
Search JabSto ::




Custom Search