In: Statistics and Probability
Unusually high concentration of metals in drinking water can pose a health hazard. Twenty couples of data were taken from different locations of X Lake measuring zinc concentration in bottom water and surface water.
Table 1. Zinc Concentration (mg/l) in bottom and surface water in different regions and areas of X Lake
| 
 Location  | 
 Region  | 
 Area  | 
 Zinc_Bottom  | 
 Zinc_Surface  | 
 Zinc_Mean  | 
 TZ3_Mean  | 
| 
 Loc 1  | 
 North  | 
 Area A  | 
 0.51  | 
 0.49  | 
 0.50  | 
 2.67  | 
| 
 Loc 2  | 
 North  | 
 Area A  | 
 0.46  | 
 0.45  | 
 0.46  | 
 2.45  | 
| 
 Loc 3  | 
 North  | 
 Area A  | 
 0.52  | 
 0.52  | 
 0.52  | 
 2.66  | 
| 
 Loc 4  | 
 North  | 
 Area A  | 
 0.51  | 
 0.50  | 
 0.50  | 
 2.56  | 
| 
 Loc 5  | 
 North  | 
 Area A  | 
 0.58  | 
 0.57  | 
 0.58  | 
 3.03  | 
| 
 Loc 6  | 
 North  | 
 Area A  | 
 0.57  | 
 0.55  | 
 0.56  | 
 3.21  | 
| 
 Loc 7  | 
 North  | 
 Area A  | 
 0.59  | 
 0.58  | 
 0.59  | 
 3.50  | 
| 
 Loc 8  | 
 North  | 
 Area B  | 
 0.46  | 
 0.44  | 
 0.45  | 
 2.40  | 
| 
 Loc 9  | 
 North  | 
 Area B  | 
 0.46  | 
 0.44  | 
 0.45  | 
 2.35  | 
| 
 Loc 10  | 
 North  | 
 Area B  | 
 0.45  | 
 0.43  | 
 0.44  | 
 2.56  | 
| 
 Loc11  | 
 East  | 
 Area B  | 
 0.41  | 
 0.40  | 
 0.41  | 
 1.33  | 
| 
 Loc 12  | 
 East  | 
 Area B  | 
 0.41  | 
 0.39  | 
 0.40  | 
 1.56  | 
| 
 Loc 13  | 
 East  | 
 Area B  | 
 0.41  | 
 0.39  | 
 0.40  | 
 1.23  | 
| 
 Loc 14  | 
 East  | 
 Area B  | 
 0.47  | 
 0.45  | 
 0.46  | 
 1.12  | 
| 
 Loc 15  | 
 East  | 
 Area C  | 
 0.41  | 
 0.39  | 
 0.40  | 
 1.23  | 
| 
 Loc 16  | 
 East  | 
 Area C  | 
 0.37  | 
 0.36  | 
 0.37  | 
 1.10  | 
| 
 Loc 17  | 
 East  | 
 Area C  | 
 0.41  | 
 0.39  | 
 0.40  | 
 1.20  | 
| 
 Loc 18  | 
 East  | 
 Area C  | 
 0.40  | 
 0.39  | 
 0.39  | 
 1.10  | 
| 
 Loc 19  | 
 East  | 
 Area C  | 
 0.39  | 
 0.37  | 
 0.38  | 
 1.12  | 
| 
 Loc 20  | 
 East  | 
 Area C  | 
 0.46  | 
 0.44  | 
 0.45  | 
 1.30  | 
QUESTION
Does the data suggest that there is a relationship between Zinc concentration and TZ3 concentration? If so, fit a simple regression model which explains zinc concentration (Zinc_Mean) with TZ3 concentration (TZ3_Mean). Obtain the ANOVA table of the regression. Comment on overall significance of the model and the coefficients.