contestada

Here is a linkLinks to an external site. to a spreadsheet containing a simulated data set. There are standards and their related absorbance values, and there are samples from two sites that were diluted, prior to processing and measuring their absorbances. The groundwater originates from the upslope site, and the hope is that the microbes in the soil are removing the NO3- from the groundwater before it reaches the downslope site.

Respuesta :

  • A standard curve is used to translate the absorbance of the purple dye into concentration after the nitrate has been transformed into the dye and its absorbance has been measured on a spectrophotometer.
  • Samples with known NO3- concentrations are run on the spectrophotometer to create a standard curve.
  • Standards are samples with known concentrations.
  • The concentration of NO3- is then correlated with the obtained absorbance values using a linear regression.

  • Create a standard curve in Excel using the provided data, and then use Trendline to add a linear regression to the equation.
  • The concentration of NO3- in all the samples is then calculated using the standard curve and the dilutions.
  • Use the appropriate t-test from the data analysis tool kit to determine whether the nitrate concentration upslope is smaller or larger than the nitrate concentration downslope.
  • The results of a t-test carried out with the aid of the data analysis tool pack will comprise the means for both groups.

What is the upslope site's average NO3- concentration?

  • Report your response with three decimal places using the data analysis tool pack output.

What is the downslope site's average NO3- concentration?

  • Report your response with three decimal places using the data analysis tool pack output.

  • Is the upslope site safe to drink based only on nitrate content, given that the EPA drinking water quality regulation is 10 mg/L of nitrate?

       (Type "yes" or "no")

  • Based solely on NO3- content, is it safe to drink at the downslope site? (Type "yes" or "no")

Assuming that the two sites are hydrologically related, that the transit time between the two sites is quick, and that the two sites cannot be viewed as independent sample, Put the letter of your preferred response in the answer field.

A. Unpaired, one-tailed t test

B. two-tailed unpaired t-test

C. paired one-tailed t-test

D. paired two-tailed t-test

What is the calculated, rounded-to-four-decimal-places t statistic?

The data analysis tool pack provided a critical t value.

  • Is the estimated t statistic larger or less than that value?

        (Enter "greater" or "lesser" here.)

  • Is the difference between the nitrate concentrations at the upslope and downslope sites significant?

       (Type "yes" or "no")

  • Do you believe that bacteria are eliminating NO3- from the ground water based on this statistical result and the supposition that there is no diffusion or dilution between the upslope and downslope site?

       (Type "yes" or "no")

To learn more about groundwater visit:

https://brainly.com/question/10005777

#SPJ4

Otras preguntas