2 Calibr - 12 A A General Past Conditional Format as Cell Insert Delete Format B Merge & Center % 9 08 20 Formatting Table Styles clipboard Font Alignment Number Styles XVfx 51 52 53 d) Find the coefficient of determination and correlation coefficient. 2 marks 54 55 56 Correlation of determination 57 Correlation Coefficient 58 59 e) What does the doefficient of determination say about the "Electiricity Usage"? 60 61 62 2 marks 63 64 65 66 + 67 68 69 70 3 marks 71 f) What would be your estimate of the "Electricity Usage" in million dollars if the "Production" is 6 million kWh? 72 173 74 75 76 77 Name Q1 02 Q3 Results | Last Sheet + Ready Box Accessibility, Investigate 1 33OF Q Search LOLCBA CloudyFile Home insert Page Layout Formulas Data Review View Help Calibri * 12 ~ A " A " E E 2P Wrap Text General Past E $ ~ % 9 00 20 Conditional Format as Cell Insert Defs Merge & Center Formatting Table y Stylesy Undo Clipboard IS Font Alignment Number Fy Styles B47 vi XV fx A B C D E F G H K The manager of a car plant wishes to investigate how the plant's electricity usage depends upon the plant's production. So for one year, every 8 month, he records the production and electricity usage. The table below shows the production and electricity usage for twele months. 9 10 11 12 13 Production Electricity Usage Month ($ million) (million kWh) 14 4.48 15 January 4.51 4.26 16 February 3.58 17 March 4.31 4.47 18 April 5.06 4.77 19 May 5.64 4.99 + June 4.99 5.05 20 5.18 21 July 5.29 22 August 5.83 5.46 September 4.7 5.03 23 24 October 5.61 5.26 25 November 4.9 4.67 December 4.7 4.53 26 27 28 29 We want to see whether there is any relationship between "Production" and "Electricity Usage". 30 Name Q1 Q2 Q3 Results Last Sheet + Ready ux Accessibility. Investigate 1 33 OF Q Search W CloudyGeneral Paste Merge & Center Conditional Format as Cell Insert Delete Formatting ~ Table Styles Undo Clipboard Font Alignment Number Styles Cells B47 XV f A B C D E G H 27 28 29 We want to see whether there is any relationship between "Production" and "Electricity Usage". 30 31 32 33 34 a) What is the independent variable? Production 2 marks 35 36 37 b) Create a graph to examine the relationship between the two variables. Enter the cell cumber of the top left corner of the grapg. What does 38 the graph indicate about the possible relationship between the variables and their suitability for simple linear regression? 39 40 41 Cell number 2 marks 42 43 44 c) Run a regression of "Electricity Usage" on "Production" and write the estimated regression equation for determining "Electricity Usage" 45 based on "Production" 46 3 marks 7 equation: 48 49 50 51 52 53 1d) Find the coefficient of determination and correlation coefficient Name Q1 1 02 03 Results Last Sheet + Ready Ex Accessibility: Investigate 1 33OF Q Search W X CloudyCalibri ~ 12 A A 29 Wrap text General Faste B Merge & Center Conditional Format as Cell Inget Delete Format Formatting Table. Styles Clipboard Font Alignment Number Style 647 XV fx D G H 79 g) Test the hypothesis for significance at 0.05 to see whether there is any linear relation between "Production" and "Electricity Usage"? 80 81 82 3 marks 83 84 85 86 87 88 89 90 91 h) For confidence level of 95%, find the critical value/values? 92 93 3 marks 94 95 96 97 98 99 100 101 102 103 104 Q3 Results Last Sheet + Name Q1 02 Ready Accessibility: Investigate Q Search 1 33OF Cloudy