Demand for golf clubs
Month Price Demand[1]
1 450 45
Text Box: Range names used:
Intercept - B19
Slope - B20
PowConst - B22
PowExpon - B23
ExpConst - B25
ExpExpon - B26
2 300 103
3 440 49
4 360 86
5 290 125
6 450 52
7 340 87
8 370 68
9 500 45
10 490 44
11 430 58
12 390 68
Parameters of best-fitting curves Predictions Absolute percentage error
Linear Linear Power Exponential Linear Power Exponential
Intercept 211.31 51.74 50.80 51.20 14.98% 12.89% 13.78%
Slope -0.3546 104.93 110.12 106.94 1.87% 6.91% 3.83%
Power 55.29 53.02 53.78 12.83% 8.21% 9.75%
Constant 5871064 83.65 77.76 79.65 2.73% 9.58% 7.38%
Exponent -1.9082 108.48 117.48 112.32 13.22% 6.01% 10.14%
Exponential 51.74 50.80 51.20 0.50% 2.31% 1.53%
Constant 466.51 90.75 86.73 87.87 4.31% 0.32% 1.00%
Exponent -0.00491 80.11 73.80 75.84 17.81% 8.53% 11.52%
34.01 41.55 40.06 24.42% 7.67% 10.99%
37.56 43.18 42.07 14.65% 1.86% 4.38%
58.83 55.40 56.49 1.43% 4.48% 2.61%
73.02 66.75 68.74 7.38% 1.84% 1.09%
MAPEs --> 9.68% 5.88% 6.50%

[1]
In thousands