Additive Multiple-Regression Method Quarterly Australian Electricity data answers EXCEL

Additive Multiple-Regression Method Quarterly Australian Electricity data answers EXCEL

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1254 Australia monthly production of electricity. 1290 Actual m.KWH 1379 1346 January 1957- December 1986 Quarterly t Yt 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 t 1409 1387 1543 1502 1693 1616 1841 1787 1631 1649 1586 1500 1497 1463 1648 1595 1777 1824 1994 1835 1787 1699 1633 1645 1597 1577 1709 1756 1936 2052 2105 2016 1914 1925 1824 1765 1721 1752 1914 1857 2159 2195 2287 2276 2096 2055 2004 1924 1851 1839 2019 1937 2270 2251 2382 2364 2129 2110 2072 1980 1995 1932 2171 2162 2489 2424 2641 2630 2324 2412 2284 2186 2184 2144 2379 2383 2717 2774 3051 2891 2613 2600 2493 2410 2390 2463 2616 2734 2970 3125 3342 3207 2964 2919 2764 2732 2622 2698 2950 2895 3200 3408 3679 3473 3154 3107 3052 2918 2786 2739 3125 3033 3486 3661 3927 3851 3456 3390 3280 3166 3080 3069 3340 3310 3798 3883 b0 bm b1 b2 b3 b4 1189.392 234.8015 -466.6989 1100.879 2188.457 0 SSE Additive Multiple-Regression Quarterly q1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 1751732 4081010 9429638 2888051 18150431 q2 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 q3 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 Yt 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 4339 4811 5259 4735 4608 5196 5616 4977 4883 5744 6035 5514 5387 6211 6659 5983 5709 6458 6875 6162 6098 7075 7595 6882 6707 7874 8555 7503 7469 8829 9513 8415 8270 9503 10306 9077 8650 10180 11234 9836 9489 10991 12170 10470 10089 11858 13198 11413 11136 13040 14248 12762 12328 14493 15661 13781 13299 15230 16667 14484 13838 15919 17149 15564 15024 17064 18512 16467 16249 18515 20377 17681 16692 19184 20078 18260 18023 20234 22272 19684 19031 21545 23270 20107 20084 22634 24494 21396 21323 23644 25994 22802 22604 24510 26690 24132 23639 26320 28345 24890 24675 27122 28590 25371 24687 27285 29290 26684 26641 29042 31876 28357 28114 30843 33175 29658 predictions 29518 28194.47 32017 29996.85 34390 31319.23 31065 29365.57 ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online