Microsoft Office Tutorials and References

In Depth Information

Fig. 6.29

Example of a chart with the regression equation displayed next to the regression line

Note that the regression equation on the chart is in the following form next to

the regression line on the chart (see Fig.
6.29
).

Y
¼
0
:
0165 X
þ
24
:
73

Now, save this ﬁle as: eggs37

6.7 How to Recognize Negative Correlations

in the SUMMARY OUTPUT Table

Important note:

Since Excel does not recognize negative correlations in the

SUMMARY OUTPUT results, but treats all correlations as if

they were positive correlations (this was a mistake made by the

programmer), you need to be careful to note that there may be a

negative correlation between X and Y even if the printout says

that the correlation is a positive correlation.

You will know that the correlation between X and Y is a negative correlation when

these two things occur:

1. THE SLOPE, b, IS A NEGATIVE NUMBER. This can only occur when there is

a negative correlation.

2. THE CHART CLEARLY SHOWS A DOWNWARD SLOPE IN THE

REGRESSION LINE, which can only occur when the correlation between X and Y is

negative.

Search JabSto ::

Custom Search