
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