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 ﬁle: eggs36 (that you saved in Sect. 6.5.2)

Search JabSto ::

Custom Search