A magazine reported on a study of the reliability of a commercial kit to test for arsenic in groundwater. The field kit was used to test a sample of 20 groundwater wells in a country. In addition to...

How can I input this in excel


Extracted text: A magazine reported on a study of the reliability of a commercial kit to test for arsenic in groundwater. The field kit was used to test a sample of 20 groundwater wells in a country. In addition to the arsenic level (micrograms per liter), the latitude (degrees), longitude (degrees), and depth (feet) of each well was measured. Complete parts a through g. Click the icon to view the data table. a. Write a first-order model for arsenic level (y) as a function of latitude, longitude, and depth. Choose the correct answer below. A. E(y) = B3X1 + B2X2 + B1X3 O B. E(y) = B,×y + B2X2 + B3×3 C. E(y)= Po +B1xq + B2X2 + B3X3 ts O D. E(y) = B3 + B2×1 + B1 X2 + Pox3 b. Fit the model to the data using the method of least squares. Let x, be the latitudes, x, be the longitudes, and x, be the depths. SS ns (Round the constant term and the coefficients for x, and x, to the nearest integer as needed. Round the coefficient for xa to the nearest hundredth as needed.)


Extracted text: Data table Well ID Latitude Longitude Depth Arsenic 23.7949 90.6428 95 184 23.7711 90.6254 120 155 23.7679 90.6322 115 114 23.7902 90.6435 140 174 23.7655 90.6343 115 141 23.7883 90.6444 140 157 9. 23.7732 90.6146 65 163 23.7675 23.7729 90.6485 95 210 8. 90.6269 120 185 23.7789 90.6144 75 137 11 23.7811 90.6371 06 95 193 606 23.7771 12 84 13 90.6343 124 699 23.7703 14 90.6173 120 907 162 15 90.6513 23.7911 90.6432 117 17 23.7725 90.6324 115 143 18 23.7826 90.6157 75 114 23.7712 90.6497 55 158 23.7794 90.6498 65 234 Print Done 48