Preliminaries: Entering the data. 

• Enter the Water data in column B, Temperature data in column C, and Mowing Time in column D.  Put the category names in B1, C1, and D1.
• If you need help entering the data, see the Introduction to Excel tutorial.

Procedure for Finding the Standardized Regression Equation

1. Type mean in A9 and standard deviation in A10 then calculate the mean and standard deviation for each column. (If you need help with this, refer to the mean and standard deviation tutorial.)

2. Type in 'New Water' in cell E1 then hit Enter.

3. In the formula toolbar, click the = sign and type in: (1/SQRT(6))*((B2-B$9)/B$10). Click OK.

   • The value -0.47536 should appear in cell E2. 

   • Now click the bottom right corner of this cell and drag it all the way down to cell E8. This will apply the formula to all of those cells.

4. Type in 'New Temp' in cell F1 and 'New Mowing' in cell G1.

   • Click on cell E2. In the toolbar, select edit>copy then click on cell F2 and select edit>paste.

   • Now click on the bottom right corner of cell F2 and drag it across to cell G2 and down both of those columns to copy the formula.

5. Your table values should be the same as the ones below.

   	Water	Temperature	Mowing	New Water	New Temp	New Mowing
   	16	75	1.85	-0.47536	-0.62692	0.46017899
   	20	83	1.25	-0.34738	-0.24112	-0.460179
   	25	85	1.5	-0.1874	-0.14467	-0.0766965
   	27	85	1.75	-0.12341	-0.14467	0.306786
   	32	92	1.15	0.036566	0.192897	-0.613572
   	48	97	1.75	0.548489	0.434019	0.306786
   	48	99	1.6	0.548489	0.530467	0.0766965
   mean	30.85714	88	1.55
   standard deviation	12.75968	8.465616733	0.266145

6. From the main menu select Tools>Data Analysis
   • From the Data Analysis dialog box, scroll down and select Regression. Click OK
   • Mark the box Show Label.
   • The Regression dialog box should appear.
     • Put your cursor in the field for the Input Y Range. 
     • Click the Collapse Dialog button (the button at the right end of the field. It has a small red arrow on the button. This will Collapse the dialog box and take you to the spreadsheet.
     • Highlight the range for the 'New Water' including the title. (i.e. Cells E1-E8)
     • Press the Return to Dialog button. (The button at the end of the field, with the small red arrow on it.)
     • Click in the field for the Input X Range. 
     • Click the Collapse Dialog button.
     • Highlight the range for the 'New Temperature and New Mowing' including the title. 
     • Note: You have to enter temperature and time mowing in the X range.
     • Press the Return to Dialog button. 
     • Mark the radio button for New Worksheet.  Click in the field box and type in Standardized Regression.

     Click here to check and interpret your answers.

     Learn the procedure to transform the standardized regression parameters back to the original regression parameters. 

*Don't forget to review the terms from the standardized multiple regression tutorial!*

Learn the Procedure for finding the Standardized Multiple Regression Equation

Regression Tutorial Menu  Dictionary

STATS @ MTSU