MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

Question
How can I input this in excel
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.)
expand button
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.)
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
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman