[go: up one dir, main page]
Scribd
Upload
28 views3 pages

Forecasting Usingexponential Power Functions

Uploaded by

shehryarahmed2k
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
28 views3 pages

Forecasting Usingexponential Power Functions

Uploaded by

shehryarahmed2k
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Year Revenue (millions of USD) Year No.

2017 $218.6 1
2018 $435.0 2
2019 $915.0 3
2020 $1,825.9 4
2021 $4,021.8 5
6

Actual Data Forecasted Data Absolute % Error


Year No. Revenue (millions of USD) Exp. Power Exp.
1 $ 218.60 214.08 $ 170.97 2.07%
2 $ 435.00 442.41 $ 575.51 1.70%
3 $ 915.00 914.28 $ 1,170.60 0.08%
4 $ 1,825.90 1889.45 $ 1,937.26 3.48%
5 $ 4,021.80 3904.72 $ 2,863.43 2.91%
6 $ 3,582.10 8069.45 $ 3,940.40 125.27%
7 16676.25 MAPE 22.59%

Power
Constant a 170.97
Exponent b 1.7511

Exponential
a 103.59
b 0.7259
Revenue (millions of USD)
$218.6
$435.0
$915.0
$1,825.9 Revenue (millions of USD)
$4,021.8
$4,500.0
$ 3,582.10 $4,021.8
f(x) = 135.801286677229 exp( 0.609875008104077 x)
$4,000.0 $3,582.10
$3,500.0 f(x) = 173.938210611781 x^1.72091476617317
Absolute % Error $3,000.0
Power $2,500.0

Revenue
20.14% $1,825.9
$2,000.0
30.08% $1,500.0
$915.0
28.03% $1,000.0
$435.0
2.53% $500.0 $218.6
26.67% $0.0
0 1 2 3 4 5 6 7
51.17%
Year Number
26.44%

y = 103.59e0.7259x
y = 170.97x1.7511
,021.8
008104077 x)
$3,582.10
17317

5 6 7

You might also like