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%