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
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
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images