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 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 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 35 8.4 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: (1) The Regression equation and interpret the intercept and the slope. (ii) Coefficient of Determination, R' and interpret (i) 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.

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 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 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 35 8.4 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: (1) The Regression equation and interpret the intercept and the slope. (ii) Coefficient of Determination, R' and interpret (i) 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.

Name: 3. Ground Water SurveyIn the following dataX= pH of well waterY = Bic
Uploaded: 2022-11-23T13:49:28.000Z
Channel: Bartleby
Description: 3. Ground Water SurveyIn the following dataX= pH of well waterY = Bicarbonate (parts per million) of well waterThe data is by water well from a random sample of wells in Northwest Texas.Reference: Union Carbide Technical Report K/UR-1Y7.61577.11748.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: The compressive strength of concrete is being studied, and four different mixing techniques are…

Q: I need help to find the test statistic

A: Step…

Q: SOURCE SS df MS f p-value Between Treatment 38.25 3 10.11 2.34 0.10 Within Treatment 26.91 16 0.90…

A: Given data is appropriate for Anova . ANOVA is splitting up of total variance into variance due to…

Q: A cell phone's SAR (Specific Absorption Rate) is a measure of the amount of radio frequency (RF)…

A: The question is about regression Given : Slope ( b ) = 59.6 Intercept ( a ) = -12 To find : Value…

Q: The authors of a paper presented a correlation analysis to investigate the relationship between…

A: a) It is needed to test, whether there is a positive correlation between maximal lactate level and…

Q: 1. A 2D data set S has the following averages and SDs. Average SD 100 x-coordinate 4 y-coordinate…

A: Note: As per my policy i can answer only three sub parts. kindly repost the remaining sub parts.'…

Q: A study was made on the amount of converted sugar in a certain process at various temperatures. The…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: What is the value of r for the data in the table? Male life expectancy Female life expectancy 01…

A: X:63.07,53.99,75.46,50.34,62.05,73.84,48.95,81.47 Y:74.77,59.21,81.73,48.45,66.27,79.63,55.33,87.54…

Q: data show Systole diastolic biood pressure i certain people. Find th regression letting the Systolic…

A: Solution: Let x = Systolic reading and y= Diastolic reading x y (x-x) (x-x)2 (y-y) (y-y)2…

Q: Available below are amounts of arsenic in samples of brown rice from three different regions. The…

A: we want to test the hypothesis Note: according to bartleby, expert can solve only one question and…

Q: Given the data set X = 3 6 5 2 Y = 0 15 12 5 Already calculated:…

A: Correlation Coefficient : The correlation coefficient is a statistical measure of the strength of…

Q: 8:53 Done ohm.lumenlearning.com AA C Here is a FDT for a small data set: data freq 42 3 43 3 44 3 45…

A: Mean = 33 Mode = 8 Midrange = 44

Q: The data represent below is the average of stiffness of coil spring. The data collected from 10…

A: Data represents average of stiffness of coil spring. The data collected from 10 samples, where each…

Q: Refer to question (2) in this assignment. Determine the percentage of all samples of three Swedish…

A: 1. Suppose a random variable x defines the brain weights of men.

Q: Below is the distance (X) of lightning flash versus charge (Y) transferred to earth X 6 6 6 6…

A: For the provided data, the value of correlation coefficient can be calculated as;

Q: The population parameters below describe the full-time equivalent number of students (FTES) each…

A: Given: μ = 1000 Median = 1014 σ = 474 First quartile = 528.5 Third quartile = 1447.5 n=29

Q: Please show work and formula, I need help with number 4, 6, and 7 A random sample of 25 frozen…

Q: d. Write a table with observations for these samples. e. Using the table, explain (calculate) where…

A: Given data, Treatment 1 Treatment 2 0 3 1 5 2 9 4 10 8 13 11 17 12 19 16 20 18…

Q: Using the data provided in question 1, assume now that the data was obtained from two indeper dent…

A: Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts. In case…

Q: A researcher wanted to determine if carpeted rooms contain more bacteria than uncarpeted rooms. The…

A: Given Information: Carpeted: Sample size (n1) = 8 Uncarpeted: Sample size (n2) = 8 Calculate mean…

Q: 2. Using the data provided in question 1, assume now that the data was obtained from two indepen-…

A: It is been asked to test whether the mean LDL cholesterol level between corn flakes diet and oat…

Q: A sample of 3 measurements are taken and recorded: x = 8, y = 9 and z = 5 = 7.33 I+ytz 3 The sample…

A: Measure of central tendency measures the central or average value of a dataset. Measured of…

Q: qs 4 subpart a b

A: Given Treatment 1 (yellow) n=9 M=8 s=1.22 Treatment 1 (blue) n=9 M=13 s=1.22

Q: Listed in the accompanying data table are birth. weights from a sample of 26 births use the Sample…

A: Mann-Whitney U test is used to test the median significance between two independent samples. It is…

Q: Continuous vs. Discrete variables Identify each quantitative variable as continuous or discrete.…

Q: Alan Baker interested in the number of chairs per household people have. Please finish the…

A: The mean=∑ixifi∑ifi=1(10)+2(8)+3(8)+4(12)+5(6)+6(10)10+8+8+12+6+10=18854=3.5

Q: TABLE 6E.2 earing Diameter Data Sample Number i R Sample Number I R 1 34.5 3 13 35.4 8 2 34.2 4 14…

A: Given:

Q: Determine uz and oz from the parameters of the population and the sample size a. u = 80, o =4, n =…

A: Given,μ=80 , σ=4 , n=49

Q: Match the following definitions with the correct terms. Data involving a single variable [ Choose ]…

A: Match the following:

Q: Annual high temperatures in a certain location have been tracked for a sample of 16 years. Let X…

A: The correlation coefficient (r) = 0.964 t = 13.565…

Q: The accompanying table shows results from regressions performed on data from a random sample of 21…

A: Given, The accompanying table shows results from regression performed on data from a random sample…

Q: Listed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman, Find…

A: Given : Provided are systolic blood pressure measurements (in mm Hg) obtained from the same woman .…

Q: Weights of adult male Rhesus of7-21Kg The monkeys (Macaca mulatta) are nermally distributed with a…

A: The Z-score of a random variable X is defined as follows: Z = (X – µ)/σ. Here, µ and σ are the mean…

Q: Given the data, what is the median Age? Data 2 Person's ID # #1 #2 12pt #3 #4 #5 #6 #7 #8 #9 #10 #11…

A: The objective of this question is to find the median age from the given data. The median is the…

Q: 1. Consider the data below. This data represents the number of miles per gallon that 30 selected…

A: The provided data represents the number of miles per gallon that 30 selected four-wheel drive sports…

Question

100%

Practice Pack

OFFON

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
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:
(1) The Regression equation and interpret the intercept and the slope.
(i) 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.

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!

Includes step-by-step video

SEE SOLUTION Check out a sample Q&A here

Steps to perform Regression analysis in Excel :

VIEW

a) Regression output

VIEW

b) Regression equation

VIEW

Predict the bicarbonate when pH of well water is 9.9 :

VIEW

Trending now

This is a popular solution!

Learn your way

Includes step-by-step video

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

what is the best fit line

Solution

by Bartleby Expert

SEE SOLUTION

Similar questions

SAMPLE NAME pH EC DATE SAMPLED Effluent 1 7.1 80 27/02/2020 Effluent 2 5.1 410 27/02/2020 Effluent 3 5.0 1400 27/02/2020 Effluent 1 7.0 80 25/01/2020 Effluent 2 6.5 730 25/01/2020 Effluent 3 7.1 800 25/01/2020 Effluent 1 7.2 400 24/12/2019 Effluent 2 6.9 700 24/12/2019 Effluent 3 7.2 790 24/12/2019 Effluent 1 7.1 250 23/11/2019 Effluent 2 6.8 750 23/11/2019 Effluent 3 7.0 800 23/11/2019 Effluent 1 7.0 350 25/10/2019 Effluent 2 6.9 810 25/10/2019 Effluent 3 7.1 810 25/10/2019 Effluent 1 7.0 750 28/09/2019 Effluent 2 7.0 350 28/09/2019 Effluent 3 7.0 770 28/09/2019 Effluent 1 7.0 750 25/08/2019 Effluent 2 7.0 350 25/08/2019 Effluent 3 7.0 750 25/08/2019 Effluent 1 7.0 350 27/07/2019 Effluent 2 7.1 680 27/07/2019 Effluent 3 6.8 760 27/07/2019 Effluent 1 7.2 400 27/06/2019 Effluent 2 6.8 650 27/06/2019 Effluent 3 6.7 760 27/06/2019 Effluent 1 7.0 350 26/05/2019 Effluent 2 6.9 750 26/05/2019 Effluent 3 7.0 770 26/05/2019 Effluent…
Titles Notation v sample mean а. Ро coefficient of determination b. N C. s2 d. V population standard deviation d. o sample standard deviation e. o V sample size f. s mean of a sampling distribution of sample means g. r h. a population variance i. l the proportion found in Ho j. p sample proportion k. x? correlation coefficient l. po population mean m. OF population size n. Ha o. p2 the mean found in the null hypothesis р. р v chi-squared 9. п
1:40 b hank y A ALEKS Week 4 Quiz 1 20+ Sig 0 2 Continue e Xenial → 3 Accordi www-awu.aleks.com/aleksc ALEKS 4 X 5 ALEKS 6 5GUC.ll 100% A ALE X 7 30 Suppose that a researcher is interested in estimating the mean systolic blood pressure, μ, of executives the blood pressures of a random sample of executives of major corporations to estimate U. Assuming th population of systolic blood pressures of executives of major corporations is 27 mm Hg, what is the mini researcher to be 95% confident that his estimate is within 5 mm Hg of U? + Carry your intermediate computations to at least three decimal places. Write your answer as a whole num minimum whole number that satisfies the requirements). (If necessary, consult a list of formulas.) Español 8 Save For Later © 2023 McGraw Hill LLC. All Rights Reserved. Terms of Use | Privacy Center | Accessibility O E |||
7:41 A myopenmath.com Use the data values in the table below to calculate the correlation between the variables x and y. Submit the link through Canvas to either a photo of your work on paper or a link to a google sheet. X y 1 25.88 22.44 3 21.4 4 18.56 16.62 6. 11.28 7 11.04 8 8.3 Give your answer to three decimal places. Submit Question
1-What these statistics tell you about the kurtosis of the variables:
Student 1:33 PM Wed Apr 21 * 73% O O Q B STA+2023+EC+C12 Home Insert Draw Layout Review View Calibri Bold (Body В I B I U А.. A Read Only - You can't save changes to this file. Save a copу 3. Are health and happiness related? The following data represents the level of happiness and level of health for a random sample of individuals from the General Social Survey. Does the evidence suggest that health and happiness are related. Let a=0.05 Education/Health Excellent Less than High Good Fair Рor 72 202 199 62 School High School Junior College 465 877 358 108 80 138 49 11 Bachelor 229 276 64 12 Graduate 130 147 32 2 ||
first picture is background information
Trace metals in drinking water affect the flavor and an unusually high concentration can pose a health hazard. Ten pairs of data were taken measuring zinc concentration in bottom water and surface water of a water source. Location 1 2 3 4 55 6 7 00 8 9 10 Zinc concentration in bottom water in surface water Zinc concentration 430 .266 567 531 .707 .716 .651 .589 .469 .723 415 238 .390 .410 .605 .609 .632 .523 .411 .612 Do the data support that the zinc concentration is less on the surface than the bottom of the water source, at the a = 0.1 level of significance? Note: A normal probability plot of difference in zinc concentration between the bottom and surface of water indicates the population could be normal and a boxplot indicated no outliers. a. Express the null and alternative hypotheses in symbolic form for this claim. Assume Ha 1- μ2, where ₁ is the population mean zinc concentration in the bottom of water and H2 is the mean zinc concentration in the surface of water. Ho: Select an…