Questions Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from 2018 to 2022: 2018 2019 2020 2021 2022 Jan – March 21 35 49 60 10 Apr – June July – Sept...


please solve this question for me


Questions<br>Consider the following quarterly demand level for electricity (in 1000 megawatts) in<br>Mankweng from 2018 to 2022:<br>2018 2019 2020 2021 2022<br>Jan – March<br>21<br>35<br>49<br>60<br>10<br>Apr – June<br>July – Sept<br>Oct – Dec<br>42<br>54<br>55<br>64<br>05<br>60<br>91<br>95<br>99<br>12<br>14<br>74<br>80<br>1. Find the least squares trend line for electricity demand using Ex = 0 method.<br>2. Find the seasonal index for each quarter.<br>3. Find adjusted seasonal index.<br>4. Find the De-seasonalized values for Quarter 1, 2,3 and 4 for the year 2023.<br>5. Estimate the demand for electricity for Quarter 1, 2, 3 and 4 for the year 2024.<br>

Extracted text: Questions Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from 2018 to 2022: 2018 2019 2020 2021 2022 Jan – March 21 35 49 60 10 Apr – June July – Sept Oct – Dec 42 54 55 64 05 60 91 95 99 12 14 74 80 1. Find the least squares trend line for electricity demand using Ex = 0 method. 2. Find the seasonal index for each quarter. 3. Find adjusted seasonal index. 4. Find the De-seasonalized values for Quarter 1, 2,3 and 4 for the year 2023. 5. Estimate the demand for electricity for Quarter 1, 2, 3 and 4 for the year 2024.

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?