Question

Cadmium	Nickel	Distance	Angle
105	85	1	320
48	72	2	189
39	60	3	175
28	49	5	348
18	31	7	63
9	20	9	182
8	16	13	240
6	11	18	318
2	4	20	280

this is the data for these set of questions . thank you very much please clearly represent The answer

1.)A plant species is being studied for the presence of cadmium and nickel levels near a former industrial waste site. Specifically, a researcher would like to know if distance to the industrial waste site is a predictor of Cadmium levels in the plant species. Perform the appropriate analysis using the Question 14 dataset in the Excel file. We can assume assumptions of test have been met. What is the slope of the equation from your analysis of the data? Use one of the following formats -9.999 or 9.999 depending on which is appropriate.

2.)You decide see how the addition of a second independent variable influences the results of the analysis from Question 14 (Cadmium vs. Distance and Angle). You add to the analysis the direction the plants were located in reference to the industrial waste site. The data is in the Angle column and represents the degrees off of magnetic north to where the plants were located. What is the p value from the analysis for Angle? Use the 0.999 format.

3.)For Question 14, the researcher would now like to know if there is a difference in mean Cadmium and Nickel concentrations in the plant species under investigation with both distance and angle from the industrial waste site. What kind of analysis should the research run?

4.)The researcher believes that there is a relationship between concentrations of Cadmium and Nickel. Run the appropriate analysis using the dataset for Question 14 in the Excel file and report on the r value.

Answer 1

Question1

If,researcher would like to know if distance to the industrial waste site is a predictor of Cadmium levels in the plant species.Then we need to run the regression of Cadmium levels on the distance.

We will do it using Excel.

The slope of the equation from analysis of the data is -3.52936

Refer to the output below:-

Question2

Now we have to decide how the addition of a second independent variable influences the results of the analysis.

i.e Regress Cadmium on Distance and Angle

The p-value of the angle is 0.140546

Refer Below:-

Question 3

For this question we can simply take average of the Cadmium and Nickel values and test for the equality of them.

Or

we can run the two regression

Cadnium ~ distance + angle

Nickel ~ distance + angle

and perform t- test for the intercepts in the model.

Question4

Here we need to check the relationship between concentrations level of Cadnium and Nickel.

So we will find out the correlation between them and make conclusion.

Correlation value is high and near to 1,hence we can say that there is a linear relationship between concentrations of Cadnium and Nickel.

r=0.911249

Since it measures the extent of linear relationship between two variable.