Question: 11.9.3 An electric utility is interested in developing a model relating peak-hour demand (y in kilowatts) to total monthly energy usage during the month (x,
11.9.3 An electric utility is interested in developing a model relating peak-hour demand (y in kilowatts) to total monthly energy usage during the month (x, in kilowatt hours). Data for 50 residential customers are shown in the table below. 1. Draw a scatter diagram of y versus x. 2. Fit the simple linear regression model. 3. Test for significance of regression using = 0.05. 4. Plot the residuals versus yiyi and comment on the underlying regression assumptions. Specifically, does it seem that the equality of variance assumption is satisfied? 5. Find a simple linear regression model using yy as the response. Does this transformation on y stabilize the inequality of variance problem noted in part (d)?
| Customer | x | y |
| 1 | 679 | 0.79 |
| 2 | 292 | 0.44 |
| 3 | 1012 | 0.56 |
| 4 | 493 | 0.79 |
| 5 | 582 | 2.70 |
| 6 | 1156 | 3.64 |
| 7 | 997 | 4.73 |
| 8 | 2189 | 9.50 |
| 9 | 1097 | 5.34 |
| 10 | 2078 | 6.85 |
| 11 | 1818 | 5.84 |
| 12 | 1700 | 5.21 |
| 13 | 747 | 3.25 |
| 14 | 2030 | 4.43 |
| 15 | 1643 | 3.16 |
| 16 | 414 | 0.50 |
| 17 | 354 | 0.17 |
| 18 | 1276 | 1.88 |
| 19 | 745 | 0.77 |
| 20 | 795 | 3.70 |
| 21 | 540 | 0.56 |
| 22 | 874 | 1.56 |
| 23 | 1543 | 5.28 |
| 24 | 1029 | 0.64 |
| 25 | 710 | 4.00 |
| 26 | 1434 | 0.31 |
| 27 | 837 | 4.20 |
| 28 | 1748 | 4.88 |
| 29 | 1381 | 3.48 |
| 30 | 1428 | 7.58 |
| 31 | 1255 | 2.63 |
| 32 | 1777 | 4.99 |
| 33 | 370 | 0.59 |
| 34 | 2316 | 8.19 |
| 35 | 1130 | 4.79 |
| 36 | 463 | 0.51 |
| 37 | 770 | 1.74 |
| 38 | 724 | 4.10 |
| 39 | 808 | 3.94 |
| 40 | 790 | 0.96 |
| 41 | 783 | 3.29 |
| 42 | 406 | 0.44 |
| 43 | 1242 | 3.24 |
| 44 | 658 | 2.14 |
| 45 | 1746 | 5.71 |
| 46 | 895 | 4.12 |
| 47 | 1114 | 1.90 |
| 48 | 413 | 0.51 |
| 49 | 1787 | 8.33 |
| 50 | 3560 | 14.94 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
