Preliminaries: Make sure you have the Data Analysis Tool Pak loaded.  Click here for additional information on the ToolPak.  Use the "back" button on your browser to return to this page.

Preliminaries: Entering the data. 

• If you have already entered the water/temperature data it should be saved in file exceldata1.  If you have this file, open the file.
• Otherwise enter the Temperature data in column A, Time mowing in column B and water in column C.  Put the category names in Row 1.
• If you need help entering the data, see the Intro to Excel  tutorial.

Procedure

Coefficients of partial determination can be expressed in terms of simple or other partial correlation coefficients. For example:

Where r_Y1 denotes the coefficient of simple correlation between Y and X1,  and  r₁₂  denotes the coefficient of simple correlation between X1 and X2, and so on.

1. To get r_Y1 :
   a) click the paste function button
   b) Select the CORREL function
   c) For your Array 1 select your temp values
   d) For your Array 2 select your Water Consumption
   e) Hit OK
2. To get r_Y2:
   a) click the paste function button
   b) Select the CORREL function
   c) For your Array 1 select your time values
   d) For your Array 2 select your Water Consumption
   e) Hit OK
3. To get r₁₂:
   a) click the paste function button
   b) Select the CORREL function
   c) For your Array 1 select your time values
   d) For your Array 2 select your temperature
   e) Hit OK
4. Plug your values into the formula
5. Save your work. Select FILE > SAVE AS. Call the data set ExcelRegCoefficient.
   

Click here to check your answers and interpretations.

Learn the Procedure for calculating the coefficient of partial determination

Partial Determination Tutorial Menu    Dictionary    Related Terms