Question

Problem 2: Temperature and power consumption of a city are recorded for 30 days period as below Temperature (Deg C) Power consumption (KWH) 16.64 18.83 15.25 23.13 26.67 29.37 37.21 36.90 41.32 45.76 47.32 46.22 30.67 25.32 29.32 24.65 21.22 25.32 45.63 36.72 35.65 42.31 21 25 27 19 39 38 42 48 40 23 25 19 18 46 43 46 43 38.56 39.32 38.76 29.60 32.41 34.31 33.32 38.81 19 15 18 24 19 1) Draw scatter plot between temperature and power consumption 2) Compute correlation coefficient and the equation of the regression line

Answer 1

1 Temperature(Deg C) Powe consumption(KWH) Chart Title y 0.546x16.869 R2 0.5098 16.64 18.83 15.25 23.13 26.67 29.37 37.21 36.90 41.32 45.76 47.32 46.22 30.67 25.32 29.32 24.65 21.22 25.32 45.63 36.72 35.65 50.00 45.00 40.00 35.00 30.00 25.00 20.00 15.00 10.00 21 25 4 17 19 39 38 10 42 13 14 15 16 17 18 23 0.00 19 10 20 30 40 18 Slope Intercept16.8687"-INTERCEPT(B3 B32,A3 A32) 21 0.5460-SLOPE(B3 B32.A3A32)" 41 43 Correlatio coefficient0.7140 CORREL(B3-B32,A3:A32)"