In this exercise you will examine some characteristics of the Kentucky Utilities Company data. Use the daily, 1 pm observations ...

     In this   exercise you will examine some characteristics of the Kentucky Utilities   Company data. Use the daily, 1 pm observations found in the file   DAYS1PM.XLS. You will look primarily at the relation between LOAD, as   the response variable, and weather conditions. The variable TEMP   mentioned below is the dry-bulb temperature DBT, you may want to change   the label.   Answer the following   questions:   1. How many cases are there   in the data set?   2. What is the average value   of LOAD?   3. What is the sample   standard deviation of TEMP?   4. For the least-squares line   relating LOAD to TEMP, R2 is shown in the output to be   5. The coefficient of TEMP in   the least-squares line relating LOAD to TEMP is   6. The regression sum of   squares is   7. For the value of TEMP=77,   the predicted value of LOAD is shown in the output as   8. For any line relating LOAD   to TEMP for this data set, the sum of squared residuals would be greater   than or equal to   9. Obtain a 95% confidence   interval for the average response when TEMP=77.   10. Test Ho: β = 0 against Ha: β ≠ 0 using a significance   level α = .05.   11. Obtain a 95% prediction   interval for LOAD at TEMP=80.   12. What is the value of the   standard error of estimate?    

     Date DOW TOD WS DBT WBT DP RH AP SC Load   601 2 13 9 79 64 55 44 97 4 685.25   602 3 13 7 75 67 62 64 109 5 701.00   603 4 13 8 82 71 65 56 119 2 736.25   604 5 13 3 84 73 68 59 120 5 806.00   605 6 13 8 85 73 68 57 111 5 689.00   606 7 13 8 86 73 67 53 101 2 626.00   607 1 13 12 80 72 69 69 98 2 809.75   608 2 13 7 79 68 62 56 99 2 773.75   609 3 13 8 73 64 59 62 102 2 704.75   610 4 13 6 77 64 56 48 107 1 696.50   611 5 13 3 83 67 57 41 111 5 800.00   612 6 13 13 79 70 66 65 101 2 624.50   613 7 13 9 81 72 67 63 79 2 563.00   614 1 13 14 81 72 68 65 75 8 855.50   615 2 13 6 72 69 67 84 84 5 721.25   616 3 13 11 76 68 64 66 95 2 714.50   617 4 13 8 80 68 61 52 102 0 752.00   618 5 13 5 83 72 67 59 107 5 812.00   619 6 13 7 79 73 71 77 104 5 688.25   620 7 13 7 81 73 69 67 100 2 526.25   621 1 13 6 79 74 72 79 91 5 881.75   622 2 13 4 67 66 65 93 91 2 716.00   623 3 13 6 77 64 56 48 90 2 759.50   624 4 13 4 81 68 61 51 100 4 824.00   625 5 13 12 86 74 69 57 96 4 890.00   626 6 13 10 86 77 74 68 91 4 762.50   627 7 13 6 88 76 71 57 96 2 714.50   628 1 13 8 85 76 73 67 105 8 859.25   629 2 13 7 83 73 69 63 109 2 836.00   630 3 13 11 86 76 72 63 101 5 865.25   701 4 13 10 82 74 71 69 99 5 821.00   702 5 13 8 80 67 60 51 110 2 745.25   703 6 13 6 79 68 62 56 113 2 614.75   704 7 13 10 83 72 67 59 110 9 555.50   705 1 13 13 83 72 66 57 97 2 605.75   706 2 13 7 76 72 70 82 99 2 738.50   707 3 13 6 82 73 69 65 111 5 851.75   708 4 13 7 86 75 71 61 117 2 884.00   709 5 13 5 90 77 73 57 114 5 909.50   710 6 13 3 87 76 72 61 105 2 782.00   711 7 13 13 84 74 70 63 93 2 616.25   712 1 13 8 81 70 64 56 107 0 815.00   713 2 13 11 84 74 70 63 100 2 812.00   714 3 13 3 74 69 67 79 93 8 767.75   715 4 13 10 82 70 64 55 86 2 779.75   716 5 13 8 82 68 60 47 96 2 815.00   717 6 13 8 85 73 67 55 100 2 716.00   718 7 13 7 82 72 67 61 96 2 584.00   719 1 13 10 78 71 68 71 77 5 767.75   720 2 13 3 74 64 58 58 103 2 719.75   721 3 13 4 77 64 56 48 109 2 723.50   722 4 13 4 80 68 61 52 109 2 770.00   723 5 13 6 80 72 68 67 102 5 806.00   724 6 13 8 77 70 66 69 95 5 622.25   725 7 13 7 79 73 71 77 91 5 536.75   726 1 13 9 85 74 69 59 85 5 837.50   727 2 13 7 76 63 55 48 105 2 736.25   728 3 13 8 82 69 62 51 99 2 749.75   729 4 13 6 78 67 60 54 104 5 757.25   730 5 13 4 71 65 62 73 93 5 666.50   731 6 13 5 74 64 57 55 112 5 539.00   801 7 13 9 77 69 64 64 116 2 453.50   802 1 13 8 78 71 68 71 111 5 772.25   803 2 13 7 77 72 69 76 104 5 754.25   804 3 13 5 76 71 68 76 104 8 760.25   805 4 13 8 75 68 65 71 115 8 706.25   806 5 13 4 76 69 65 69 111 5 722.00   807 6 13 4 81 69 63 54 109 1 652.25   808 7 13 5 84 71 64 51 113 5 548.75   809 1 13 3 84 72 67 57 111 5 873.50   810 2 13 8 86 75 71 61 97 5 900.50   811 3 13 6 79 73 70 74 91 5 822.50   812 4 13 8 79 64 55 44 101 1 750.50   813 5 13 3 80 65 56 44 104 0 778.25   814 6 13 5 82 67 59 46 103 2 647.75   815 7 13 7 84 70 62 48 107 2 539.75   816 1 13 8 83 72 67 59 110 2 859.25   817 2 13 6 86 71 64 48 107 2 837.50   818 3 13 6 83 69 62 49 105 9 836.75   819 4 13 8 86 72 65 50 108 2 869.75   820 5 13 11 89 73 65 45 106 0 893.00   821 6 13 9 87 71 63 45 100 2 734.00   822 7 13 8 78 69 64 62 86 2 528.50   823 1 13 8 85 70 63 48 95 2 863.75   824 2 13 6 82 62 47 29 108 0 818.75   825 3 13 9 90 75 68 48 98 5 849.50   826 4 13 9 80 71 67 65 95 5 799.25   827 5 13 10 79 64 54 42 98 2 742.25   828 6 13 7 69 62 58 68 111 8 533.75   829 7 13 8 81 67 58 46 120 2 462.50   830 1 13 4 84 69 60 44 115 2 800.00   831 2 13 4 86 71 63 46 110 5 857.75