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