Use the template for finding bias pasted as the basis to build your own version. You should keep the same actual listed in the template.
Compare the estimating model shown in the figure with the following estimates:
Period: 1 2 3 4 5 6 78
Estimate: 164 241 67 67 77 450 40 165
Base your comparison on the mean bias and the MAR. Comment on the differences and their meaning.

Transcribed Image Text:

4 Tracking Signal Suml(At /Et)-1/MAR Trackin 6 Period Estimate Actua A/E) 1At/E) MAR Signal 052 008 457 130 053 230 155 163 242 052 1.-448 0.172 2.904 0.898 0.1404.120 155 5.205 0.154.523 160 5.670 240 0.030 457 130 053 230 125 227 104 0.1623 344 423 13 7 14 8 15 16 Total 17 128 157 227 1.281 1 19 Cell D7 |=(C7B7)-1 (copy to cells D8:D14) 20 Cell D7 (ABS)D7 (copy to cells ES:E14 21 Cell F8 -SUMCEST ESYCOUNT ES7:ES) (copy to cells F9-F14 22 Cell G8 SUMDS7 D8)/F8 (copy to cellsG9.G14 25 Cell DI6 SUM(D :D14) lcopy to cells E16)