
This page includes Step-by-Step instructions to use Minitab to calculate the multiple regression equation for the Water/Temperature/Mowing Time example.
Example: Assume that during a three-hour period spent outside, a person recorded the outside temperature, the time they spent mowing the grass, and their water consumption.
Use Excel to find the Multiple Correlation Coefficient, R if the amount of the amount of water consumed is dependent on the temperature and the time they spent mowing the grass. Use the data given below.
| Temperature (F) | Water Consumption (ounces) | Time mowing the grass (hours) |
| 75 | 16 | 1.85 |
| 83 | 20 | 1.25 |
| 85 | 25 | 1.5 |
| 85 | 27 | 1.75 |
| 92 | 32 | 1.15 |
| 97 | 48 | 1.75 |
| 99 | 48 | 1.6 |
Preliminaries:
Entering
the data.
1. Select Stats>Regression>Regression
2. For Response type in
'Water Consumption' and for Predictors
type 'Time Mowing' 'Temperature'
3. Select OK

Save the data. Select FILE > SAVE AS. Call the data set MinitabData1. (You will use the data again in future tutorials.)
Learn the Procedure for calculating the multiple regression
coefficient
Don't skip looking at the Terms for Multiple Regression.
Regression Tutorial Menu Dictionary