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 find 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
coefficients in the Summary Output.
(d) Print the table and regression results below the table so that they fit onto one
(e) By hand on this printout, circle and label:
(1a) multiple correlation R xy
(2b) coefficients for the y-intercept, precipitation, and temperature.
(f) Save this file as: PLANT3A
(g) Now, go back to your Excel file 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 file 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 coefficient for precipitation b 1 ?
4. What is the coefficient 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