Lab 3Specific Energy Consumption and Constructing Simple Linear Regression Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Energy (kWh) 140726 Week Production (tonnes) 1 150 2 103223 3 60 90764 4 50 87567 5 170 146600 6 180 154773 7 120 121575 8 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 110 70 24 170 25 190 141428 26 160 141215 120 118319 28 190 152506 Specific energy (kWh/tonne) 29 80 99267 30 90 94468 31 180 140188 32 70 91262 33 50 78248 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity con- sumption are plotted on one graph. Have electricity consump- tion on primary vertical axis and production on secondary ver- tical axis. Horizontal will have time (in weeks). Comment on the trend 108041 89115 136388 (ii) Calculate the specific energy in every week. (iii) Determine the average weekly specific energy. (iv) Determine the total production and total energy in 36 weeks. (v) Plot a scatter plot graph with y-axis having Energy consumption and x-axis having production. (vi) Add a linear trend line to the plotted graph in part (v) and put equation and R-squared value on the graph.
Lab 3Specific Energy Consumption and Constructing Simple Linear Regression Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Energy (kWh) 140726 Week Production (tonnes) 1 150 2 103223 3 60 90764 4 50 87567 5 170 146600 6 180 154773 7 120 121575 8 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 110 70 24 170 25 190 141428 26 160 141215 120 118319 28 190 152506 Specific energy (kWh/tonne) 29 80 99267 30 90 94468 31 180 140188 32 70 91262 33 50 78248 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity con- sumption are plotted on one graph. Have electricity consump- tion on primary vertical axis and production on secondary ver- tical axis. Horizontal will have time (in weeks). Comment on the trend 108041 89115 136388 (ii) Calculate the specific energy in every week. (iii) Determine the average weekly specific energy. (iv) Determine the total production and total energy in 36 weeks. (v) Plot a scatter plot graph with y-axis having Energy consumption and x-axis having production. (vi) Add a linear trend line to the plotted graph in part (v) and put equation and R-squared value on the graph.
Related questions
Question
100%
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 7 images