for Business Intelligence-I need you write Part b Task B (section a-c)

profileBlessedTopWriter
regression-models.xls
Home>Mathematics homework help>Numerical analysis homework help>for Business Intelligence-I need you write Part b Task B (section a-c)

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.7570645248
R Square 0.5731466947
Adjusted R Square 0.5304613642
Standard Error 77252.763591272
Observations 133
ANOVA
df SS MS F Significance F
Regression 12 961604393078.769 80133699423.2308 13.4272521187 3.56449798006216E-17
Residual 120 716158737898.674 5967989482.48895
Total 132 1677763130977.44
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -26163.4229786224 107744.94935394 -0.2428273727 0.8085536986 -239490.924198557 187164.078241312 -239490.924198557 187164.078241312
Temp 24868.502029042 5829.5621545873 4.2659296478 0.000039945 13326.3746708568 36410.6293872273 13326.3746708568 36410.6293872273
January D -162446.963119582 66685.9466835577 -2.435999955 0.0163201208 -294480.496550065 -30413.4296890997 -294480.496550065 -30413.4296890997
Febuary D -63677.7637528155 62039.5808208202 -1.0264054481 0.3067650623 -186511.816138527 59156.2886328959 -186511.816138527 59156.2886328959
March D -72219.5760426331 58797.1471998712 -1.228283675 0.2217441006 -188633.835515766 44194.6834304998 -188633.835515766 44194.6834304998
April D -76433.6695128069 44515.8099809625 -1.7170005341 0.0885589804 -164571.875200987 11704.5361753731 -164571.875200987 11704.5361753731
May D -87403.587794633 37147.3052940669 -2.3528917401 0.0202550762 -160952.667013236 -13854.50857603 -160952.667013236 -13854.50857603
July D 119315.096063258 32987.0813858767 3.6170249398 0.0004371188 54002.9706524318 184627.221474084 54002.9706524318 184627.221474084
August D 29787.9337443275 33789.364679806 0.8815772071 0.3797678746 -37112.6567536391 96688.5242422941 -37112.6567536391 96688.5242422941
September D -44277.121844761 40512.4385035112 -1.0929266043 0.2766152483 -124488.930621895 35934.6869323734 -124488.930621895 35934.6869323734
October D -47991.1623402648 48395.2375372477 -0.9916505173 0.3233634061 -143810.364601449 47828.0399209191 -143810.364601449 47828.0399209191
November D -51169.7284114788 53731.5131861582 -0.9523224897 0.3428477273 -157554.385079841 55214.9282568838 -157554.385079841 55214.9282568838
December D 98671.3330482761 58797.1471998712 1.6781653149 0.0959173575 -17742.9264248568 215085.592521409 -17742.9264248568 215085.592521409
RESIDUAL OUTPUT
Observation Predicted Tourism Residuals
1 507707.670714972 -46307.6707149722
2 603990.019878835 -118990.019878835
3 568092.855357071 -94692.8553570708
4 486786.405596867 -51786.4055968667
5 381316.179604681 -38416.179604681
6 381680.010297667 -1980.0102976669
7 523376.758187063 -45176.7581870627
8 476126.049317504 -65926.0493175037
9 499048.151641679 -75548.1516416791
10 532636.864189738 -59736.8641897383
11 544379.39933595 -54379.3993359496
12 694220.460795705 -53320.4607957045
13 495273.419700451 -44273.4197004511
14 576634.667646888 -66434.6676468884
15 555658.60434255 -35658.6043425498
16 464404.753770729 -29504.7537707289
17 450947.985285999 -86247.9852859987
18 389140.560906379 8859.4390936205
19 510942.507172542 -31342.5071725418
20 503481.40154945 -70981.4015494499
21 451797.997786499 -20297.9977864992
22 567452.767030397 -106552.767030397
23 512050.346698195 -17650.3466981949
24 704167.861607321 -93067.8616073211
25 482839.16868593 -46539.1686859301
26 521923.963182996 13776.0368170039
27 538250.65292222 -30550.6529222204
28 422128.300321358 -3028.3003213576
29 388776.730213394 -12576.7302133937
30 438877.564964464 -61577.5649644636
31 518403.057781254 5396.9422187457
32 433849.595868132 -20049.5958681323
33 469205.949206829 -72005.9492068286
34 522689.463378121 -72489.4633781215
35 521997.747509812 -53597.7475098118
36 743957.464853788 -137257.464853788
37 525115.622135302 -79015.6221353016
38 559226.716226559 -63726.716226559
39 553171.754139646 -71271.7541396456
40 459431.053364921 -10731.0533649205
41 393750.430619202 -24950.430619202
42 428930.164152847 -71330.1641528468
43 543271.559810296 -90771.5598102964
44 538297.304390109 -129997.304390109
45 513969.252859104 -81669.2528591043
46 470465.609117133 7234.3908828667
47 599090.103799842 -120590.103799842
48 729036.363636363 -86736.3636363633
49 507707.670714972 -66607.6707149722
50 608963.720284643 -59963.7202846431
51 565606.005154167 -44706.0051541666
52 499220.656611388 -76620.6566113877
53 393750.430619202 -23450.430619202
54 409035.362529613 -10335.3625296131
55 510942.507172542 -5642.5071725418
56 458718.097897174 -12618.0978971743
57 454284.847989404 14515.1520105965
58 487873.560537463 -1673.5605374627
59 521997.747509812 -11497.7475098118
60 736496.914245076 -65896.9142450758
61 510194.520917876 -45494.5209178764
62 631345.372110781 -83745.3721107809
63 555658.60434255 -62758.6043425498
64 456944.203162016 -2344.2031620163
65 361421.377981447 16778.6220185525
66 421469.613544134 -38569.6135441341
67 520889.907984159 -25089.9079841585
68 486073.45012912 -25273.4501291205
69 469205.949206829 -44505.9492068286
70 470465.609117133 18934.3908828667
71 566761.051162087 -54361.0511620874
72 634536.055926003 32263.9440739965
73 480352.318483026 6247.6815169741
74 559226.716226559 -14826.716226559
75 520842.701501891 14657.298498109
76 484299.555393963 -27699.5553939625
77 393750.430619202 -6850.430619202
78 414009.062935422 -1909.0629354215
79 523376.758187063 -33476.7581870627
80 498507.701143641 -9807.7011436415
81 491587.601032966 -26287.6010329665
82 515228.912769409 -10428.9127694089
83 529458.298118524 18841.7018814757
84 741470.614650884 -28370.6146508842
85 515168.221323685 -40468.2213236848
86 569174.117038176 26825.8829618242
87 573066.555762879 7533.4442371208
88 481812.705191058 -30012.7051910583
89 411158.382039532 -5058.3820395316
90 426443.313949943 16056.6860500575
91 580574.31285386 -56974.3128538595
92 530836.753781396 -7336.7537813961
93 556245.706308476 -67945.7063084757
94 574913.31763911 -40213.3176391098
95 536918.848727237 38381.1512727631
96 751418.015462501 33781.9845374988
97 505220.820512068 46579.1794879321
98 576634.667646888 54565.3323531116
99 568092.855357071 27707.1446429292
100 484299.555393963 42100.4446060375
101 448461.135083095 21638.8649169055
102 456285.516384793 -1285.516384793
103 560679.511230626 26120.4887693742
104 433849.595868132 104950.404131868
105 464232.24880102 53267.7511989798
106 547557.965407164 40542.0345928364
107 576708.451973704 33691.5480262958
108 751418.015462501 60781.9845374988
109 515168.221323685 34731.7786763152
110 591555.768864314 132144.231135686
111 568092.855357071 108207.144642929
112 459431.053364921 92968.9466350795
113 401210.981227915 85489.0187720853
114 431417.014355751 57582.9856442491
115 520889.907984159 106610.092015841
116 488560.300332025 85539.6996679753
117 434390.04636617 137509.95363383
118 572426.467436206 52773.5325637944
119 589142.702988225 79857.2970117748
120 743957.464853788 154742.535146212
121 505220.820512068 115279.179487932
122 616424.270893356 180375.729106644
123 573066.555762879 181533.444237121
124 514141.757828813 96658.242171187
125 468355.936706328 73644.0632936719
126 451311.815978985 104488.184021015
127 565653.211636434 150346.788363566
128 481099.749723312 151500.250276688
129 464232.24880102 182967.75119898
130 522689.463378121 171610.536621879
131 579195.302176608 141304.697823392
132 788720.768506064 183079.231493936
133 559931.52497596 165868.47502404

Sheet4

28
27.9
26.8
23.7
19.9
16.4
17.3
19
22.9
24.4
25
25
27.5
26.8
26.3
22.8
22.7
16.7
16.8
20.1
21
25.8
23.7
25.4
27
24.6
25.6
21.1
20.2
18.7
17.1
17.3
21.7
24
24.1
27
28.7
26.1
26.2
22.6
20.4
18.3
18.1
21.5
23.5
21.9
27.2
26.4
28
28.1
26.7
24.2
20.4
17.5
16.8
18.3
21.1
22.6
24.1
26.7
28.1
29
26.3
22.5
19.1
18
17.2
19.4
21.7
21.9
25.9
22.6
26.9
26.1
24.9
23.6
20.4
17.7
17.3
19.9
22.6
23.7
24.4
26.9
28.3
26.5
27
23.5
21.1
18.2
19.6
21.2
25.2
26.1
24.7
27.3
27.9
26.8
26.8
23.6
22.6
19.4
18.8
17.3
21.5
25
26.3
27.3
28.3
27.4
26.8
22.6
20.7
18.4
17.2
19.5
20.3
26
26.8
27
27.9
28.4
27
24.8
23.4
19.2
19
19.2
21.5
24
26.4
28.8
30.1
Temp
Residuals
Temp Residual Plot

Dummy Variables

1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
January D
Residuals
January D Residual Plot
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
Febuary D
Residuals
Febuary D Residual Plot
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
March D
Residuals
March D Residual Plot
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
April D
Residuals
April D Residual Plot
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
May D
Residuals
May D Residual Plot
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
July D
Residuals
July D Residual Plot
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
August D
Residuals
August D Residual Plot
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
September D
Residuals
September D Residual Plot
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
October D
Residuals
October D Residual Plot
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
November D
Residuals
November D Residual Plot
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
December D
Residuals
December D Residual Plot
Year Tourism Temp January D Febuary D March D April D May D July D August D September D October D November D December D
Jan-2006 461400 28 1 0 0 0 0 0 0 0 0 0 0
Feb-2006 485000 27.9 0 1 0 0 0 0 0 0 0 0 0
Mar-2006 473400 26.8 0 0 1 0 0 0 0 0 0 0 0
Apr-2006 435000 23.7 0 0 0 1 0 0 0 0 0 0 0
May-2006 342900 19.9 0 0 0 0 1 0 0 0 0 0 0
Jun-2006 379700 16.4 0 0 0 0 0 0 0 0 0 0 0
Jul-2006 478200 17.3 0 0 0 0 0 1 0 0 0 0 0
Aug-2006 410200 19 0 0 0 0 0 0 1 0 0 0 0
Sep-2006 423500 22.9 0 0 0 0 0 0 0 1 0 0 0
Oct-2006 472900 24.4 0 0 0 0 0 0 0 0 1 0 0
Nov-2006 490000 25 0 0 0 0 0 0 0 0 0 1 0
Dec-2006 640900 25 0 0 0 0 0 0 0 0 0 0 1
Jan-2007 451000 27.5 1 0 0 0 0 0 0 0 0 0 0
Feb-2007 510200 26.8 0 1 0 0 0 0 0 0 0 0 0
Mar-2007 520000 26.3 0 0 1 0 0 0 0 0 0 0 0
Apr-2007 434900 22.8 0 0 0 1 0 0 0 0 0 0 0
May-2007 364700 22.7 0 0 0 0 1 0 0 0 0 0 0
Jun-2007 398000 16.7 0 0 0 0 0 0 0 0 0 0 0
Jul-2007 479600 16.8 0 0 0 0 0 1 0 0 0 0 0
Aug-2007 432500 20.1 0 0 0 0 0 0 1 0 0 0 0
Sep-2007 431500 21 0 0 0 0 0 0 0 1 0 0 0
Oct-2007 460900 25.8 0 0 0 0 0 0 0 0 1 0 0
Nov-2007 494400 23.7 0 0 0 0 0 0 0 0 0 1 0
Dec-2007 611100 25.4 0 0 0 0 0 0 0 0 0 0 1
Jan-2008 436300 27 1 0 0 0 0 0 0 0 0 0 0
Feb-2008 535700 24.6 0 1 0 0 0 0 0 0 0 0 0
Mar-2008 507700 25.6 0 0 1 0 0 0 0 0 0 0 0
Apr-2008 419100 21.1 0 0 0 1 0 0 0 0 0 0 0
May-2008 376200 20.2 0 0 0 0 1 0 0 0 0 0 0
Jun-2008 377300 18.7 0 0 0 0 0 0 0 0 0 0 0
Jul-2008 523800 17.1 0 0 0 0 0 1 0 0 0 0 0
Aug-2008 413800 17.3 0 0 0 0 0 0 1 0 0 0 0
Sep-2008 397200 21.7 0 0 0 0 0 0 0 1 0 0 0
Oct-2008 450200 24 0 0 0 0 0 0 0 0 1 0 0
Nov-2008 468400 24.1 0 0 0 0 0 0 0 0 0 1 0
Dec-2008 606700 27 0 0 0 0 0 0 0 0 0 0 1
Jan-2009 446100 28.7 1 0 0 0 0 0 0 0 0 0 0
Feb-2009 495500 26.1 0 1 0 0 0 0 0 0 0 0 0
Mar-2009 481900 26.2 0 0 1 0 0 0 0 0 0 0 0
Apr-2009 448700 22.6 0 0 0 1 0 0 0 0 0 0 0
May-2009 368800 20.4 0 0 0 0 1 0 0 0 0 0 0
Jun-2009 357600 18.3 0 0 0 0 0 0 0 0 0 0 0
Jul-2009 452500 18.1 0 0 0 0 0 1 0 0 0 0 0
Aug-2009 408300 21.5 0 0 0 0 0 0 1 0 0 0 0
Sep-2009 432300 23.5 0 0 0 0 0 0 0 1 0 0 0
Oct-2009 477700 21.9 0 0 0 0 0 0 0 0 1 0 0
Nov-2009 478500 27.2 0 0 0 0 0 0 0 0 0 1 0
Dec-2009 642300 26.4 0 0 0 0 0 0 0 0 0 0 1
Jan-2010 441100 28 1 0 0 0 0 0 0 0 0 0 0
Feb-2010 549000 28.1 0 1 0 0 0 0 0 0 0 0 0
Mar-2010 520900 26.7 0 0 1 0 0 0 0 0 0 0 0
Apr-2010 422600 24.2 0 0 0 1 0 0 0 0 0 0 0
May-2010 370300 20.4 0 0 0 0 1 0 0 0 0 0 0
Jun-2010 398700 17.5 0 0 0 0 0 0 0 0 0 0 0
Jul-2010 505300 16.8 0 0 0 0 0 1 0 0 0 0 0
Aug-2010 446100 18.3 0 0 0 0 0 0 1 0 0 0 0
Sep-2010 468800 21.1 0 0 0 0 0 0 0 1 0 0 0
Oct-2010 486200 22.6 0 0 0 0 0 0 0 0 1 0 0
Nov-2010 510500 24.1 0 0 0 0 0 0 0 0 0 1 0
Dec-2010 670600 26.7 0 0 0 0 0 0 0 0 0 0 1
Jan-2011 464700 28.1 1 0 0 0 0 0 0 0 0 0 0
Feb-2011 547600 29 0 1 0 0 0 0 0 0 0 0 0
Mar-2011 492900 26.3 0 0 1 0 0 0 0 0 0 0 0
Apr-2011 454600 22.5 0 0 0 1 0 0 0 0 0 0 0
May-2011 378200 19.1 0 0 0 0 1 0 0 0 0 0 0
Jun-2011 382900 18 0 0 0 0 0 0 0 0 0 0 0
Jul-2011 495800 17.2 0 0 0 0 0 1 0 0 0 0 0
Aug-2011 460800 19.4 0 0 0 0 0 0 1 0 0 0 0
Sep-2011 424700 21.7 0 0 0 0 0 0 0 1 0 0 0
Oct-2011 489400 21.9 0 0 0 0 0 0 0 0 1 0 0
Nov-2011 512400 25.9 0 0 0 0 0 0 0 0 0 1 0
Dec-2011 666800 22.6 0 0 0 0 0 0 0 0 0 0 1
Jan-2012 486600 26.9 1 0 0 0 0 0 0 0 0 0 0
Feb-2012 544400 26.1 0 1 0 0 0 0 0 0 0 0 0
Mar-2012 535500 24.9 0 0 1 0 0 0 0 0 0 0 0
Apr-2012 456600 23.6 0 0 0 1 0 0 0 0 0 0 0
May-2012 386900 20.4 0 0 0 0 1 0 0 0 0 0 0
Jun-2012 412100 17.7 0 0 0 0 0 0 0 0 0 0 0
Jul-2012 489900 17.3 0 0 0 0 0 1 0 0 0 0 0
Aug-2012 488700 19.9 0 0 0 0 0 0 1 0 0 0 0
Sep-2012 465300 22.6 0 0 0 0 0 0 0 1 0 0 0
Oct-2012 504800 23.7 0 0 0 0 0 0 0 0 1 0 0
Nov-2012 548300 24.4 0 0 0 0 0 0 0 0 0 1 0
Dec-2012 713100 26.9 0 0 0 0 0 0 0 0 0 0 1
Jan-2013 474700 28.3 1 0 0 0 0 0 0 0 0 0 0
Feb-2013 596000 26.5 0 1 0 0 0 0 0 0 0 0 0
Mar-2013 580600 27 0 0 1 0 0 0 0 0 0 0 0
Apr-2013 451800 23.5 0 0 0 1 0 0 0 0 0 0 0
May-2013 406100 21.1 0 0 0 0 1 0 0 0 0 0 0
Jun-2013 442500 18.2 0 0 0 0 0 0 0 0 0 0 0
Jul-2013 523600 19.6 0 0 0 0 0 1 0 0 0 0 0
Aug-2013 523500 21.2 0 0 0 0 0 0 1 0 0 0 0
Sep-2013 488300 25.2 0 0 0 0 0 0 0 1 0 0 0
Oct-2013 534700 26.1 0 0 0 0 0 0 0 0 1 0 0
Nov-2013 575300 24.7 0 0 0 0 0 0 0 0 0 1 0
Dec-2013 785200 27.3 0 0 0 0 0 0 0 0 0 0 1
Jan-2014 551800 27.9 1 0 0 0 0 0 0 0 0 0 0
Feb-2014 631200 26.8 0 1 0 0 0 0 0 0 0 0 0
Mar-2014 595800 26.8 0 0 1 0 0 0 0 0 0 0 0
Apr-2014 526400 23.6 0 0 0 1 0 0 0 0 0 0 0
May-2014 470100 22.6 0 0 0 0 1 0 0 0 0 0 0
Jun-2014 455000 19.4 0 0 0 0 0 0 0 0 0 0 0
Jul-2014 586800 18.8 0 0 0 0 0 1 0 0 0 0 0
Aug-2014 538800 17.3 0 0 0 0 0 0 1 0 0 0 0
Sep-2014 517500 21.5 0 0 0 0 0 0 0 1 0 0 0
Oct-2014 588100 25 0 0 0 0 0 0 0 0 1 0 0
Nov-2014 610400 26.3 0 0 0 0 0 0 0 0 0 1 0
Dec-2014 812200 27.3 0 0 0 0 0 0 0 0 0 0 1
Jan-2015 549900 28.3 1 0 0 0 0 0 0 0 0 0 0
Feb-2015 723700 27.4 0 1 0 0 0 0 0 0 0 0 0
Mar-2015 676300 26.8 0 0 1 0 0 0 0 0 0 0 0
Apr-2015 552400 22.6 0 0 0 1 0 0 0 0 0 0 0
May-2015 486700 20.7 0 0 0 0 1 0 0 0 0 0 0
Jun-2015 489000 18.4 0 0 0 0 0 0 0 0 0 0 0
Jul-2015 627500 17.2 0 0 0 0 0 1 0 0 0 0 0
Aug-2015 574100 19.5 0 0 0 0 0 0 1 0 0 0 0
Sep-2015 571900 20.3 0 0 0 0 0 0 0 1 0 0 0
Oct-2015 625200 26 0 0 0 0 0 0 0 0 1 0 0
Nov-2015 669000 26.8 0 0 0 0 0 0 0 0 0 1 0
Dec-2015 898700 27 0 0 0 0 0 0 0 0 0 0 1
Jan-2016 620500 27.9 1 0 0 0 0 0 0 0 0 0 0
Feb-2016 796800 28.4 0 1 0 0 0 0 0 0 0 0 0
Mar-2016 754600 27 0 0 1 0 0 0 0 0 0 0 0
Apr-2016 610800 24.8 0 0 0 1 0 0 0 0 0 0 0
May-2016 542000 23.4 0 0 0 0 1 0 0 0 0 0 0
Jun-2016 555800 19.2 0 0 0 0 0 0 0 0 0 0 0
Jul-2016 716000 19 0 0 0 0 0 1 0 0 0 0 0
Aug-2016 632600 19.2 0 0 0 0 0 0 1 0 0 0 0
Sep-2016 647200 21.5 0 0 0 0 0 0 0 1 0 0 0
Oct-2016 694300 24 0 0 0 0 0 0 0 0 1 0 0
Nov-2016 720500 26.4 0 0 0 0 0 0 0 0 0 1 0
Dec-2016 971800 28.8 0 0 0 0 0 0 0 0 0 0 1
Jan-2017 725800 30.1 1 0 0 0 0 0 0 0 0 0 0
Feb-2017 583190.909090909 27.0636363636 0 1 0 0 0 0 0 0 0 0 0 Coefficients
Mar-2017 558145.454545454 26.4 0 0 1 0 0 0 0 0 0 0 0 Intercept -26163.4229786224
Apr-2017 473899.999999999 23.1818181818 0 0 0 1 0 0 0 0 0 0 0 Temp 24868.502029042
May-2017 408445.454545454 20.9909090909 0 0 0 0 1 0 0 0 0 0 0 January D -162446.963119582
Jun-2017 422600 18.0454545455 0 0 0 0 0 0 0 0 0 0 0 Febuary D -63677.7637528155
Jul-2017 534454.545454545 17.7454545455 0 0 0 0 0 1 0 0 0 0 0 March D -72219.5760426331
Aug-2017 484490.909090909 19.3363636364 0 0 0 0 0 0 1 0 0 0 0 April D -76433.6695128069
Sep-2017 478927.272727272 22.0909090909 0 0 0 0 0 0 0 1 0 0 0 May D -87403.587794633
Oct-2017 525854.545454545 24.1272727273 0 0 0 0 0 0 0 0 1 0 0 July D 119315.096063258
Nov-2017 552518.181818182 25.3272727273 0 0 0 0 0 0 0 0 0 1 0 August D 29787.9337443275
Dec-2017 729036.363636363 26.4 0 0 0 0 0 0 0 0 0 0 1 September D -44277.121844761
Jan-2018 509290.211753184 28.0636363636 1 0 0 0 0 0 0 0 0 0 0 October D -47991.1623402648
Feb-2018 583190.909090909 27.0636363636 0 1 0 0 0 0 0 0 0 0 0 November D -51169.7284114788
Mar-2018 558145.454545454 26.4 0 0 1 0 0 0 0 0 0 0 0 December D 98671.3330482761
Apr-2018 473899.999999999 23.1818181818 0 0 0 1 0 0 0 0 0 0 0
May-2018 408445.454545454 20.9909090909 0 0 0 0 1 0 0 0 0 0 0
Jun-2018 422600 18.0454545455 0 0 0 0 0 0 0 0 0 0 0