Scribd
Upload
27 views

Year Period 2016 1 2017 2 2018 3 2019 4 2020 5 2021 6 2022 7 2023 8 2024 9 2025 10

The document contains energy sales data from 2016 to 2025 and a linear regression forecasting model. The model was fitted to the 2016-2020 data and forecasts energy sales out to 2025 with an R-squared value of 0.98, indicating a highly accurate fit. The forecasted values are shown on a graph along with the actual historic values from 2016-2020 and the linear trendline.

Uploaded by

Michael Darmstaedter
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
27 views

Year Period 2016 1 2017 2 2018 3 2019 4 2020 5 2021 6 2022 7 2023 8 2024 9 2025 10

The document contains energy sales data from 2016 to 2025 and a linear regression forecasting model. The model was fitted to the 2016-2020 data and forecasts energy sales out to 2025 with an R-squared value of 0.98, indicating a highly accurate fit. The forecasted values are shown on a graph along with the actual historic values from 2016-2020 and the linear trendline.

Uploaded by

Michael Darmstaedter
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/ 9

YEAR PERIOD

2016 1
2017 2
2018 3
2019 4
2020 5
2021 6
2022 7
2023 8
2024 9
2025 10
ENERGY FORECAST
1,200,000
ENERGY SALES FORECASTED
608,671 611,912.00 1,000,000
651,589 656,614.00 800,000
713,684 701,316.00 f(x) = 44702.3 x + 567209.5
R² = 0.987426369785486

MWH
749,322 746,018.00 600,000

783,316 790,720.00 400,000


? 835,422.00
200,000
? 880,124.00
? 924,826.00 -
0 1 2 3 4 5 6
? 969,528.00
? 1,014,230.00 PERIOD

R^2 = 0.9874 PASS

CRITERIA
R^2>=0.70 PASS
R^2<0.70 FAIL

MAPE =
CRITERIA
MAPE<=3% PASS
MAPE>3% FAIL
NERGY FORECAST

567209.5
785486

4 5 6 7 8 9 10 11
PERIOD
Y = 567209.5+44702.3*X1
YEAR PERIOD
2016 1
2017 2
2018 3
2019 4
2020 5
2021 6
2022 7
2023 8
2024 9
2025 10
209.5+44702.3*X1
ENERGY SALES FORECASTED
608,671 611,911.80
651,589 656,614.10
713,684 701,316.40
749,322 746,018.70
783,316 790,721.00
? 835,423.30
? 880,125.60
? 924,827.90
? 969,530.20
? 1,014,232.50

R^2 = 0.987 PASS

CRITERIA
R^2>0.70 PASS
R^2<0.71 FAIL
YEAR T MWH FORECASTED_MWH
2016 1 608671 611,912
ENERGY FORECA
2017 2 651589 656,614 1200000
2018 3 713684 701,316 1000000
2019 4 749322 746,018
2020 5 783316 790,720 800000
f(x) = 44702.3 x + 567209.5
2021 6 835,422 R² = 0.987426369785486

MWH
600000
2022 7 880,124
2023 8 924,826 400000
2024 9 969,528 200000
2025 10 1,014,230
0
0 1 2 3 4 5 6 7 8 9 10
TIME
ENERGY FORECASTING

f(x) = 44702.3 x + 567209.5 ACTUAL MWH


R² = 0.987426369785486
Linear (ACTUAL MWH)
FORECASTED MWH

2 3 4 5 6 7 8 9 10
TIME

You might also like