QUESTION:In its Jan 2005 issue,Environmental Science & Technology JournalofAmerican Chemical Society (ASC)reported about a study of the reliability of commercial kits to test for arsenic in ground water.The field kit was used to test a sample of 328 groundwater wells in Bangladesh. In addition to arsenic level (micro-gramsper littler) the latitude (degrees), longitude (degrees), and depth (feet) of each well was measured. The data is saved in theattached Excel fileAresenicWells.

10.Explain the relationship between R²and R²-adjusted of the model and interpret R²-adjusted.

11.Test the global utility of the model at the significance level of 1%. Interpret your results. Would you recommend using this model to predict a street vendor earning based on the above answers to #1 through #10?

12.Calculate a 95% confidence interval for the average arsenic level of a well whose latitude, longitude, and depth is 23.78 degrees, 90.60 degrees, and 126 feet, respectively. Post your Minitab output.

13.Calculate a 95% prediction interval for the arsenic level of a well whose latitude, longitude, and depth is 23.78 degrees, 90.60 degrees, and 126 feet, respectively. Post your Minitab output.

14.Calculate a 90% confidence interval for the average arsenic level of a well whose latitude, longitude, and depth is 23.68 degrees, 90.76 degrees, and 226 feet, respectively. Post your Minitab output.