X 3. Ground Water Survey In the following data X = pH of well water Y...

Transcribed Image Text:

X 3. Ground Water Survey In the following data X = pH of well water Y = Bicarbonate (parts per million) of well water The data is by water well from a random sample of wells in Northwest Texas. Reference: Union Carbide Technical Report K/UR-1 Y 7.6 157 7.1 174 8.2 175 7.5 188 7.4 171 7.8 143 7.3 217 8 190 7.1 142 7.5 190 8.1 215 7 199 7.3 262 7.8 105 7.3 121 8 81 8.5 82 7.1 210 8.2 202 7.9 155 7.6 157 8.8 147 7.2 133. 7.9 53 8.1 56 7.7 113 8.4 35 7.4 125 7.3 76 8.5 48 7.8 147 6.7 117 7.1 182 7.3 87 Use the table above to: a) Produce the regression results using Microsoft Excel b) From a, find the following: (i) The Regression equation and interpret the intercept and the slope. (ii) Coefficient of Determination, R and interpret (iii) Is there a linear relationship between pH of well water and Bicarbonate? Use the t-test, F-test, the confidence interval of the slope to check c) Predict the Bicarbonate when pH of well water is 9.9. X 3. Ground Water Survey In the following data X = pH of well water Y = Bicarbonate (parts per million) of well water The data is by water well from a random sample of wells in Northwest Texas. Reference: Union Carbide Technical Report K/UR-1 Y 7.6 157 7.1 174 8.2 175 7.5 188 7.4 171 7.8 143 7.3 217 8 190 7.1 142 7.5 190 8.1 215 7 199 7.3 262 7.8 105 7.3 121 8 81 8.5 82 7.1 210 8.2 202 7.9 155 7.6 157 8.8 147 7.2 133. 7.9 53 8.1 56 7.7 113 8.4 35 7.4 125 7.3 76 8.5 48 7.8 147 6.7 117 7.1 182 7.3 87 Use the table above to: a) Produce the regression results using Microsoft Excel b) From a, find the following: (i) The Regression equation and interpret the intercept and the slope. (ii) Coefficient of Determination, R and interpret (iii) Is there a linear relationship between pH of well water and Bicarbonate? Use the t-test, F-test, the confidence interval of the slope to check c) Predict the Bicarbonate when pH of well water is 9.9.

Answer rating: 100% (QA)

Regression Analysis of Groundwater Data a Using the provided data in Microsoft Excel I performed a l... View the full answer