Lab 4 CUSUM method Aim: To determine CUSUM of data and analyse Week Production (tonnes) Energy (kWh) Predicted consumption (kWh) 1 140726 2 80 103223 90764 4 87567 5 170 146600 180 154773 7 120 121575 8 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 13 140 125892 14 155 138966 15 165 139922 16 190 152274 77788 18 55 82711 19 150 124317 20 80 94677 21 63 84628 22 110 108041 23 89115 24 170 136388 25 190 141428 26 160 141215 27 120 118319 152506 29 80 99267 30 94468 31 180 140188 32 91262 Difference CUSUM (Actual-Predicted) 33 78248 34 155 128005 35 167 36 120 131003 109192 (i) Using the predictive model "Electricity consumption -511x Pro- duction +61370", determine the predicted electricity consumption from week 1 to week 36. (ii) Determine the difference between actual and predicted elec- tricity consumption (iii) Determine the cumulative sum of differences for each week (iv) Plot a graph of how CUSUM varies with each week (v) List the week where “kinks” are observed on the graph in part (iv) and give possible reasons. End of document

icon
Related questions
Question
Lab 4 CUSUM method
Aim: To determine CUSUM of data and analyse
Week
Production
(tonnes)
Energy (kWh)
Predicted consumption
(kWh)
1
140726
2
80
103223
90764
4
87567
5
170
146600
180
154773
7
120
121575
8
81436
9
110
115586
10
90
105909
11
40
83916
12
50
86272
13
140
125892
14
155
138966
15
165
139922
16
190
152274
77788
18
55
82711
19
150
124317
20
80
94677
21
63
84628
22
110
108041
23
89115
24
170
136388
25
190
141428
26
160
141215
27
120
118319
152506
29
80
99267
30
94468
31
180
140188
32
91262
Difference
CUSUM
(Actual-Predicted)
33
78248
34
155
128005
35
167
36
120
131003
109192
(i) Using the predictive model "Electricity consumption -511x Pro-
duction +61370", determine the predicted electricity
consumption from week 1 to week 36.
(ii) Determine the difference between actual and predicted elec-
tricity consumption
(iii) Determine the cumulative sum of differences for each week
(iv) Plot a graph of how CUSUM varies with each week
(v) List the week where “kinks” are observed on the graph in part
(iv) and give possible reasons.
End of document
Transcribed Image Text:Lab 4 CUSUM method Aim: To determine CUSUM of data and analyse Week Production (tonnes) Energy (kWh) Predicted consumption (kWh) 1 140726 2 80 103223 90764 4 87567 5 170 146600 180 154773 7 120 121575 8 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 13 140 125892 14 155 138966 15 165 139922 16 190 152274 77788 18 55 82711 19 150 124317 20 80 94677 21 63 84628 22 110 108041 23 89115 24 170 136388 25 190 141428 26 160 141215 27 120 118319 152506 29 80 99267 30 94468 31 180 140188 32 91262 Difference CUSUM (Actual-Predicted) 33 78248 34 155 128005 35 167 36 120 131003 109192 (i) Using the predictive model "Electricity consumption -511x Pro- duction +61370", determine the predicted electricity consumption from week 1 to week 36. (ii) Determine the difference between actual and predicted elec- tricity consumption (iii) Determine the cumulative sum of differences for each week (iv) Plot a graph of how CUSUM varies with each week (v) List the week where “kinks” are observed on the graph in part (iv) and give possible reasons. End of document
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer