Question I (15 points) Hw 4 Use the file Miiani.xlsx. US travel to Mitan. Si are provided for you. Estimate a TSD wodel using the provided Si and a trond equation with por oummy variabie 1 1.om period 103 to 140 dummy variable for period 220 to end dummy variable 1 from period 14 30 15 118 Eg is per . * Juramy 109-140" * dummy 220 to end - ** dummy 14-15 All an decimal places. The Si indicate the busiest month of the year is (use number) The forecast seasonally adjusted Bissengers for August 2014 is nc decimais The Final forecast w/ seasonality for the same time period is obs MXP MXP YEAR 1 1990 2 1990 3 1990 4 1990 5 1990 6 1990 7 1990 8 1990 9 1990 10 1990 11 1990 12 1990 13 1991 14 1991 15 1991 16 1991 17 1991 18 1991 19 1991 20 1991 21 1991 Milan 15,736 16,609 14,947 19,580 25,572 25,186 24,581 32,003 25,069 17,691 13,120 11,326 13,024 6,356 10,658 16,571 21,026 26,550 25,257 33,598 28,286 MONTH ORIGIN_COUNTRY DEST 1 US MXP 2 US MXP 3 US MXP 4 US MXP 5 US MXP 6 US MXP 7 US 8 US 9 US MXP 10 US MXP 11 US MXP 12 US IVIXP 1 US MXP 2 US MXP 3 US MXP 4 US MXP 5 US MXP 6 US MXP 7 US MXP 8 US MXP 9 US MXP 1991 1991 1991 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 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 43 49 50 51 52 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 1993 21,065 17,228 15,133 21,815 16,845 24,578 23,171 28,414 29,954 27,580 36,933 31,470 29,214 22,249 13,469 25,845 17,911 27,458 21,178 24,859 25,192 23,801 31,806 28,051 22,512 17,889 16,552 22,307 13,925 21,460 18,324 24,427 25,348 23,390 28,852 28,748 21,010 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 1994 1994 1994 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 4 US 53 54 55 5 US 6 US 7 US 8 US 9 US 10 US 56 57 58 1994 1994 1994 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 1994 1994 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 16,817 15,495 19,718 14,853 21,825 21,179 23,189 26,972. 25,537 34,186 30,193 23,904 20,463 18,092 19,383 17,013 25,630 23,443 28,517 32,617 28,419 38,650 35,914 27,772 19,436 17,161 21,116 17,757 27,120 23,715 29,770 34,259 30,948 35,556 35,700 27,367 22,328 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MiXP MXP MXP MXP MXP MXP 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 127 128 129 130 131 132 1997 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 19,251 23,518 20,352 28,804 27,800 31,159 32,573 26,976 30,567 32,433 31,767 36,080 33,635 38,515 36,458 56,205 49,099 52,957 56,377 56,085 59,978 63,145 55,581 46,468 38,470 43,482 41,360 64,348 67,836 78,783 81,441 72,468 76,954 79,765 67,790 53,615 51,985 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXO MXP MXP MXP MXP MXP MXP 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2004 47,889 43,159 64,891 59,947 68,548 68,868 62,169 62,194 47,278 31,552 31,149 35,308 32,350 31,611 42,045 36,210 49,509 48,411 41,812 42,239 49,239 41,372 39,844 38,738 34,029 26,458 33,062 29,334 38,694 40,916 37,744 40,384 44,856 39,996 37,448 35,826 33,173 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 10 US 11 US 12 US 1 US 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 29,413 46,546 42,206 48,448 54,718 47,882 48,390 46,327 48,211 43,104 42,602 37,638 31,738 49,127 44,166 53,880 52,438 49,154 48,895 50,351 42,070 37,723 40,054 35,583 32,896 46,362 45,503 51,279 58,461 52,563 49,995 55,672 43,947 39,195 42,774 38,525 31,997 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 1.2 US 1 US 2 US 196 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 214 215 MXP 8 US 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2010 2010 2010 49,149 45,159 52,896 53,828 47,121 46,910 52,365 40,975 38,643 41,964 39,393 29,438 45,432 20,949 32,188 32,350 25,792 30,082 30,488 23,045 19,707 21,043 19,001 13,554 21,031 26,367 30,533 30,573 26,919 32,211 33,047 23,844 16,052 16,992 14,890 11,819 19,339 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 244 245 246 247 248 249 250 251 252 253 254 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 255 MXP 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 2010 2010 2010 2010 2010 2010 2010 2010 2010 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2013 2013 2013 2013 19,352 24,416 27,566 23,923 24,373 25,590 21,737 16,809 19,892 18,176 14,029 22,715 25,391 28,647 28,595 25,018 24,857 27,242 23,284 19,135 20,181 18,937 16,214 22,327 24,918 28,355 29,899 27,605 29,161 29,241 22,346 18,430 19,565 18,411 15,292 22,118 21,976 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 281 282 283 284 285 286 287 25,519 29,771 26,848 24,755 25,407 28,214 26,262 33,224 29,568 24,106 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 288 289 290 291 292 293 294 295 296 297 298 299 300 2013 2013 2013 2013 2013 2013 2013 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US Question I (15 points) Hw 4 Use the file Miiani.xlsx. US travel to Mitan. Si are provided for you. Estimate a TSD wodel using the provided Si and a trond equation with por oummy variabie 1 1.om period 103 to 140 dummy variable for period 220 to end dummy variable 1 from period 14 30 15 118 Eg is per . * Juramy 109-140" * dummy 220 to end - ** dummy 14-15 All an decimal places. The Si indicate the busiest month of the year is (use number) The forecast seasonally adjusted Bissengers for August 2014 is nc decimais The Final forecast w/ seasonality for the same time period is obs MXP MXP YEAR 1 1990 2 1990 3 1990 4 1990 5 1990 6 1990 7 1990 8 1990 9 1990 10 1990 11 1990 12 1990 13 1991 14 1991 15 1991 16 1991 17 1991 18 1991 19 1991 20 1991 21 1991 Milan 15,736 16,609 14,947 19,580 25,572 25,186 24,581 32,003 25,069 17,691 13,120 11,326 13,024 6,356 10,658 16,571 21,026 26,550 25,257 33,598 28,286 MONTH ORIGIN_COUNTRY DEST 1 US MXP 2 US MXP 3 US MXP 4 US MXP 5 US MXP 6 US MXP 7 US 8 US 9 US MXP 10 US MXP 11 US MXP 12 US IVIXP 1 US MXP 2 US MXP 3 US MXP 4 US MXP 5 US MXP 6 US MXP 7 US MXP 8 US MXP 9 US MXP 1991 1991 1991 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 1992 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 43 49 50 51 52 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 1993 21,065 17,228 15,133 21,815 16,845 24,578 23,171 28,414 29,954 27,580 36,933 31,470 29,214 22,249 13,469 25,845 17,911 27,458 21,178 24,859 25,192 23,801 31,806 28,051 22,512 17,889 16,552 22,307 13,925 21,460 18,324 24,427 25,348 23,390 28,852 28,748 21,010 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 1994 1994 1994 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 4 US 53 54 55 5 US 6 US 7 US 8 US 9 US 10 US 56 57 58 1994 1994 1994 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 1994 1994 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 1997 16,817 15,495 19,718 14,853 21,825 21,179 23,189 26,972. 25,537 34,186 30,193 23,904 20,463 18,092 19,383 17,013 25,630 23,443 28,517 32,617 28,419 38,650 35,914 27,772 19,436 17,161 21,116 17,757 27,120 23,715 29,770 34,259 30,948 35,556 35,700 27,367 22,328 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MiXP MXP MXP MXP MXP MXP 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 127 128 129 130 131 132 1997 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 19,251 23,518 20,352 28,804 27,800 31,159 32,573 26,976 30,567 32,433 31,767 36,080 33,635 38,515 36,458 56,205 49,099 52,957 56,377 56,085 59,978 63,145 55,581 46,468 38,470 43,482 41,360 64,348 67,836 78,783 81,441 72,468 76,954 79,765 67,790 53,615 51,985 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXO MXP MXP MXP MXP MXP MXP 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2004 47,889 43,159 64,891 59,947 68,548 68,868 62,169 62,194 47,278 31,552 31,149 35,308 32,350 31,611 42,045 36,210 49,509 48,411 41,812 42,239 49,239 41,372 39,844 38,738 34,029 26,458 33,062 29,334 38,694 40,916 37,744 40,384 44,856 39,996 37,448 35,826 33,173 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 10 US 11 US 12 US 1 US 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 29,413 46,546 42,206 48,448 54,718 47,882 48,390 46,327 48,211 43,104 42,602 37,638 31,738 49,127 44,166 53,880 52,438 49,154 48,895 50,351 42,070 37,723 40,054 35,583 32,896 46,362 45,503 51,279 58,461 52,563 49,995 55,672 43,947 39,195 42,774 38,525 31,997 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 1.2 US 1 US 2 US 196 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 214 215 MXP 8 US 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2010 2010 2010 49,149 45,159 52,896 53,828 47,121 46,910 52,365 40,975 38,643 41,964 39,393 29,438 45,432 20,949 32,188 32,350 25,792 30,082 30,488 23,045 19,707 21,043 19,001 13,554 21,031 26,367 30,533 30,573 26,919 32,211 33,047 23,844 16,052 16,992 14,890 11,819 19,339 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 244 245 246 247 248 249 250 251 252 253 254 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 255 MXP 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 2010 2010 2010 2010 2010 2010 2010 2010 2010 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2013 2013 2013 2013 19,352 24,416 27,566 23,923 24,373 25,590 21,737 16,809 19,892 18,176 14,029 22,715 25,391 28,647 28,595 25,018 24,857 27,242 23,284 19,135 20,181 18,937 16,214 22,327 24,918 28,355 29,899 27,605 29,161 29,241 22,346 18,430 19,565 18,411 15,292 22,118 21,976 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 281 282 283 284 285 286 287 25,519 29,771 26,848 24,755 25,407 28,214 26,262 33,224 29,568 24,106 MXP MXP MXP MXP MXP MXP MXP MXP MXP MXP 288 289 290 291 292 293 294 295 296 297 298 299 300 2013 2013 2013 2013 2013 2013 2013 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US 1 US 2 US 3 US 4 US 5 US 6 US 7 US 8 US 9 US 10 US 11 US 12 US