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
(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 ::