Linear Regression Model using Excel | |||||
Container throughput of Gabon | Predictions | Absolute percentage errors | |||
Year | Throughput | Linear | Exponential | Linear | Exponential |
1 | 153,657 | 152,480 | 153,193 | 0.77% | 0.30% |
2 | 162,415 | 163,945 | 163,563 | 0.94% | 0.71% |
3 | 174,596 | 175,410 | 174,635 | 0.47% | 0.02% |
4 | 188,389 | 186,875 | 186,456 | 0.80% | 1.03% |
5 | 197,997 | 198,340 | 199,078 | 0.17% | 0.55% |
6 |
| 209,805 | 212,554 |
|
|
7 |
| 221,270 | 226,942 |
|
|
8 |
| 232,735 | 242,305 |
|
|
9 |
| 244,200 | 258,707 |
|
|
10 |
| 255,665 | 276,219 |
|
|
|
|
| MAPE | 0.63% | 0.52% |