Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Week Production (tonnes) 1 150 Energy (kWh) 140726 103223 3 60 90764 4 50 87567 170 146600 6 180 154773 7 120 121575 8 40 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 190 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 22 110 108041 70 136388 190 141428 26 160 141215 27 120 118319 28 190 29 80 152506 99267 30 90 94468 31 180 140188 70 91262 33 50 78248 89115 Specific energy (kWh/tonne) 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity consumption are plotted on one graph. Have electricity consumption on primary vertical axis and production on secondary vertical axis. Horizontal will have time (in weeks). Comment on the trend (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. (vii) Write a linear equation to predict electricity consumption. Give quantity and its units of all parameters in the equation. (viii) Use data analysis tool pack on MS Excel and carry out a simple linear re- gression. Present the results that you have obtained and explain what the values mean in the table. (ix) Compare the equation that you have obtained in parts (vii) and (viii) End of document

Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Week Production (tonnes) 1 150 Energy (kWh) 140726 103223 3 60 90764 4 50 87567 170 146600 6 180 154773 7 120 121575 8 40 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 190 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 22 110 108041 70 136388 190 141428 26 160 141215 27 120 118319 28 190 29 80 152506 99267 30 90 94468 31 180 140188 70 91262 33 50 78248 89115 Specific energy (kWh/tonne) 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity consumption are plotted on one graph. Have electricity consumption on primary vertical axis and production on secondary vertical axis. Horizontal will have time (in weeks). Comment on the trend (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. (vii) Write a linear equation to predict electricity consumption. Give quantity and its units of all parameters in the equation. (viii) Use data analysis tool pack on MS Excel and carry out a simple linear re- gression. Present the results that you have obtained and explain what the values mean in the table. (ix) Compare the equation that you have obtained in parts (vii) and (viii) End of document