Forecast function

[rhola]

If the variance of known x's equals zero, then forecast returns #DIV/O!
And I don't understand it

This is the example.

Year_Wk 1_Monday 2_Tuesday 3_Wednesday 4_Thursday 5_Friday Grand Total
200427 134 94 38 164 65 495
200428 89 132 142 198 562
200429 156 58 147 67 428
200430 218 57 23 183 100 581
200431 130 21 57 204 412
200432 125 42 50 147 2 366
200433 102 173 30 172 132 609
200434 113 51 52 250 2 468
200435 123 169 48 244 39 623
200436 99 116 11 186 62 474
200437 154 61 127 344
200438 159 99 113 100 472
200439 156 32 102 168 141 599
200440 42 118 93 10 45 308
200441 182 4 36 178 400
200442 36 60 119 79 53 347
200443 167 2 78 196 2 445
200444 0 187 156 125 468
200445 0 97 2 53 153
200446 161 53 101 96 411
200447 2 18 2 22
200448 154 114 31 236 99 632
200449 41 18 154 92 59 364
200450 77 55 173 2 308
200451 136 58 197 55 10 456
200452 25 63 43 54 10 195
200501 4 59 54 130 146 393
200502 92 107 45 214 135 593
200503 83 39 52 225 32 431
200504 113 95 99 200 129 636
200505 166 80 25 107 141 519
200506 62 40 93 105 4 304
200507 125 38 82 268 513
200508 173 121 3 215 66 578
200509 137 107 26 65 90 425
200510 70 133 71 117 159 550
200511 69 100 194 186 55 604
200512 50 56 28 214 5 353
200513 0 111 69 186 82 448
200514 0 201 111 224 14 550
200515 196 47 65 237 113 658
200516 150 48 32 226 16 472
200517 83 181 198 62 525
200518 115 82 148 82 427
200519 203 158 99 80 125 665
200520 0 76 97 191 8 372
200521 180 33 301 123 79 716
200522 65 115 96 182 51 509
200523 160 139 26 224 59 608
200524 104 86 110 116 11 427
200525 208 117 118 246 3 692
200526 203 54 23 135 59 474
200527 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
200528 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
200529 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
200530 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Rudi (Belgium)

 

[btadams]

If you're using the dates to forecast, you'll need to change them to real dates rather than text.