Question: Use computer software packages, such as Minitab or Excel, to solve this problem. Consider the following data for a dependent variable y and two independent
Use computer software packages, such as Minitab or Excel, to solve this problem. Consider the following data for a dependent variable y and two independent variables, x1 and x2.
| x1 | x2 | y |
| 29 | 13 | 94 |
| 47 | 11 | 109 |
| 25 | 18 | 112 |
| 50 | 16 | 178 |
| 41 | 6 | 94 |
| 51 | 19 | 176 |
| 75 | 7 | 170 |
| 37 | 12 | 117 |
| 60 | 13 | 143 |
| 77 | 17 | 211 |
The estimated regression equation for this data is
= -23+ 2.01x1 + 4.88x2
Round your answers to two decimal places.
a. Develop a 95% confidence interval for the mean value of y when x1 = 45 and x2 = 15.
95% confidence interval is to .
b. Develop a 95% prediction interval for y when x1 = 45 and x2 = 15.
95% prediction interval is to .
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
