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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started