correlation and coefficients Questions

C) An experiment was carried out to investigate variation of solubility of chemical Y in a water. The quantities in kilograms that dissolved in 1 litre of water at nine different temperature levels was recorded and data has been analysed using IBM-SPSS software. Temperature (C) 10 15 20 25 30 35 40 50 70 Mass (kg) 1.6 2.2 2.4 2.7 3.5 4.0 5.1 7.0 8.3 Table 1: Correlations Temperature Mass Temperature Pearson Correlation 984 Sig. (2-tailed) 000 N Mass Pearson Correlation 984 Sig. (2-tailed) .000 N 9 *. Correlation is significant at the 0.01 level (2-tailed). Table 2: Coefficients Standardized Unstandardized Coefficients Coefficients Model B Std. Error Beta Sig. Constant) 137 308 444 670 Temperature X 108 .984 14.590 000 Based on the data and IBM-SPSS software output above: i) Validate that the Pearson correlation coefficient value is 0.984. Hence, comment on the value. (5 marks) ii) Compute the value of X in Table 2. (2 marks) iii) Determine the proportion of variance in the dependent variable. (2 marks) iv) Estimate mass that dissolved in the water if the temperature is set at 100 C. (3 marks) V) Identify whether the prediction value in (iv) is valid or not. Justify your answer using a reasonable reason. (2 marks)