Microsoft Office Tutorials and References

In Depth Information

Fig. 7.11
Worksheet Data for Chapter 7: Practice Problem #2

(a) create an Excel spreadsheet using PRODUCTIVITY as the criterion (Y), and

the other variables as the two predictors of this criterion.

(b) Use Excel’s
multiple regression
function to ﬁnd the relationship between

these variables and place it below the table.

(c) Use number format (2 decimal places) for the multiple correlation on the

Summary Output, and use number format (three decimal places) for the

coefﬁcients in the Summary Output.

(d) Print the table and regression results below the table so that they ﬁt onto one

page.

(e) By hand on this printout,
circle and label:

(1a) multiple correlation R
xy

(2b) coefﬁcients for the y-intercept, precipitation, and temperature.

(f) Save this ﬁle as: PLANT3A

(g) Now, go back to your Excel ﬁle and create a correlation matrix for these

three variables, and place it underneath the Summary Table.
Change each

correlation to just two decimals
. Save this ﬁle again as: PLANT3A

(h) Now, print out
just this correlation matrix in portrait mode
on a separate

sheet of paper.

Answer the following questions using your Excel printout:

1. What is the multiple correlation R
xy
?

2. What is the y-intercept
a
?

3. What is the coefﬁcient for precipitation
b
1
?

4. What is the coefﬁcient for temperature
b
2
?

5. What is the multiple regression equation?

6. Underneath this regression equation by hand, predict the productivity you

would expect for an annual precipitation of 300 cm/yr and an annual

temperature of +2 C.

Search JabSto ::

Custom Search