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,xy + B2X2 + B3×3 C. E(y) Po +B1xq + B2X2 + B3×3 ts O D. E(y) = B3 + B2×1 + B1X2 + Pox×3 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 x2 to the nearest integer as needed. Round the coefficient for x3 to the nearest hundredth as needed.)
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,xy + B2X2 + B3×3 C. E(y) Po +B1xq + B2X2 + B3×3 ts O D. E(y) = B3 + B2×1 + B1X2 + Pox×3 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 x2 to the nearest integer as needed. Round the coefficient for x3 to the nearest hundredth as needed.)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
How can I input this in excel

Transcribed Image 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.)

Transcribed Image 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
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman