need details solution please

QUESTION 5 A study was done to investigate the effect of ambient temperature on the electric power consumed by a chemical plant. Other factors were held constant and the data were collected from an experimental pilot plant. The following data provides the ambient temperature to predict the electric power consumed by the chemical plant. Ambient temperature (F) Electric Power (BTU) 34 220 47 351 38 321 31 243 46 401 44 367 51 503 49 389 52 497 57 491 65 623 69 585 71 652 56 476 72 667 (a) Find the linear correlation coefficient for the above data. Show your table of calculation. (5 marks) (b) Find the simple linear regression line for the above data. (3 marks) (c) Interpret the values of a and b that calculated in part (a). (2 marks) (d) Predict the power consumption for an ambient temperature of 65OF. (2 marks) (e) Test at 5% significance level that B is different from 12. (5 marks) ( f ) Estimate the ambient temperature if the power consumption is 573 BTU. (2 marks)