Question

In: Statistics and Probability

In order to analyze water samples using a spectrophotometer or plate reader, it is necessary to...

In order to analyze water samples using a spectrophotometer or plate reader, it is necessary to turn the molecules of nitrate into a dye molecule that can be quantified. The first step in turning nitrate (NO3-)  into a dye molecule is reducing it to a molecule of nitrite (NO2-). This is done by reacting the NO3- with cadmium.

After the reduction reaction, the NO2- is reacted with two additional reagents. The first reagent, Reagent A, is a solution of sulfanilamide and hydrochloric acid. The second reagent, Reagent B, is a solution of N-(1-naphthyl)-ethylenediamine, called NNED for short. The compounds are mixed with the water sample and produce a purple color. The intensity of the purple color is directly related to the concentration of nitrite in the water sample. We can measure how purple the water turns as absorbance on a spectrophotometer and then convert the absorbance to concentration of nitrate.

To make Reagent A, we will need to make a solution of 10.0 g of sulfanilamide in 1 L of 2.4 molar hydrochloric acid (HCl).

The stock solution of HCl is 6 molar HCl. How many milliliters (mL) of 12 M HCl would you add to produce 0.15 liters (L) of HCl?  mL HCl

After creating 0.15 L of 2.4 molar HCl solution, how many grams of sulfanilamide will be added?  g sulfanilamide

After reacting the nitrate with cadmium to produce nitrite, the nitrite is then reacting with sulfanilamide and N-(1-naphthyl)-ethylenediamine, to produce a purple dye molecule that can be quantified on a spectrophotometer.

The N-(1-naphthyl)-ethylenediamine, called NNED for convenience, reagent is made by mixing 1 gram of NNED in 1 liter of water. However, we don't always want to make an entire liter of solution because the NNED solution only lasts about 1 month before going bad and turning brown.

How many milligrams of NNED will need to be added to make 0.125 liters of solution?

After converting the nitrate into a purple dye, and measuring the absorbance of the purple dye on a spectrophotometer, a standard curve is used to convert the absorbance into concentration.

To make a standard curve, samples with known concentrations of NO3- are run on the spectrophotemeter. The samples with known concentrations are called standards. A linear regression is then performed to relate the concentration of NO3-  to measured absorbance values.

Here is a link 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.

Using the given data create a standard curve in Excel, and use Trendline to add a linear regression with the equation. Then use the standard curve and the dilutions to determine the concentration of NO3- in all the samples. Using the data analysis tool pack, perform the appropriate t-test to deduce if the nitrate concentration upslope is less than or greater than the nitrate concentration downslope. When performing a t-test using the data analysis tool pack, the output will include the means for both groups.

What is the average NO3- concentration at the upslope site?

Report your answer, from the data analysis tool pak output, to 3 decimal places

What is the average NO3- concentration at the downslope site?

Report your answer, from the data analysis tool pak output, to 3 decimal places

Given the EPA drinking water quality standard is 10 mg/L of nitrate, is the upslope site safe to drink based only on nitrate content?  (Enter yes or no)

Is the downslope site safe to drink, based only on NO3- concentration?  (Enter yes or no)

Assuming the two sites are hydrologically well connected, the transit time between the two sites is fast, and the two sites cannot be treated as independent samples, what kind of t-test should be performed to show that the upslope site is greater than the downslope site? Enter the letter of your answer choice in the answer blank

A. one-tailed unpaired t-test
B. two-tailed unpaired t-test
C. one-tailed paired t-test
D. two-tailed paired t-test

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

Is the calculated t statistic greater or less than the critical t value reported by the data analysis tool pack?  (enter greater or less)

Is the nitrate concentration at the upslope site significantly greater than the downslope site? (Enter yes or no)

Based on this statistical result, and assuming no diffusion or dilution occurs between the upslope and downslope site, do you think microbes are removing NO3- from the ground water?  (Enter yes or no)

DATA

mg N per L Abs Sample ID Upslope Absorbance Dilution mg N Downslope Absorbance Dillution
0 0 1 0.449 0.01 0.316 0.5
0.1 0.12 2 0.243 0.01 0.251 0.5
0.2 0.225 3 0.331 0.01 0.256 1
0.4 0.432 4 0.45 0.1 0.2 1
0.6 0.585 5 0.551 0.01 0.563 1
6 0.561 0.01 0.316 0.5
7 0.541 0.02 0.951 1
8 0.244 0.01 0.317 1
9 0.532 0.01 0.2 0.5
10 0.5 0.02 0.269 1
11 0.332 0.01 0.2 0.5
12 0.443 0.02 0.313 0.5
13 0.655 0.1 0.2 1
14 0.675 0.01 0.745 1
15 0.5 0.1 0.119 0.5
16 0.39 0.01 0.103 1
17 0.5 0.02 0.149 1
18 0.532 0.01 0.311 0.5
19 0.5 0.1 0.918 1
20 0.108 0.01 0.328 1
21 0.119 0.1 0.2 0.5
22 0.689 0.01 0.206 1
23 0.5 0.02 0.2 0.5
24 0.329 0.1 0.508 0.5
25 0.753 0.01 0.256 0.5
26 0.511 0.01 0.294 0.5
27 0.839 0.02 0.417 0.5
28 0.543 0.01 0.149 1
29 0.392 0.02 0.118 0.5
30 0.444 0.01 0.201 1

Solutions

Expert Solution

Note: Only Statistics part is answered in this question.


Related Solutions

40) In order to analyze water samples using a spectrophotometer or plate reader, it is necessary...
40) In order to analyze water samples using a spectrophotometer or plate reader, it is necessary to turn the molecules of nitrate into a dye molecule that can be quantified. The first step in turning nitrate (NO3-)  into a dye molecule is reducing it to a molecule of nitrite (NO2-). This is done by reacting the NO3- with cadmium. After the reduction reaction, the NO2- is reacted with two additional reagents. The first reagent, Reagent A, is a solution of sulfanilamide...
A technologist is performing a colorimetric assay using 96?well ELISA microtiter plates.   The ELISA plate reader...
A technologist is performing a colorimetric assay using 96?well ELISA microtiter plates.   The ELISA plate reader measures the absorbance of the solution in each well (cuvet) by recording the light passing through the solution from the top to the bottom of each well.  The assay’s color, when tested in a standard spectrophotometer, is linear to an absorbance of 4.0 however the ELISA reader has a range of linearity which only extends to an absorbance of 1.2.  When a microtiter plate is placed...
A city is considering purchasing automated license plate reader software dedicated to detecting a particular type...
A city is considering purchasing automated license plate reader software dedicated to detecting a particular type of crime. This change would increase the fraction of offenders who get caught from 15% to 20%. The social cost of each crime is $10,000. The cost of trial and punishment for each convicted criminal is $100,000. Suppose the increase in detection results in a decrease in the number of crimes committed from 1,000 per year to 700 per year. Calculate the effect that...
A city is considering purchasing automated license plate reader software dedicated to detecting a particular type...
A city is considering purchasing automated license plate reader software dedicated to detecting a particular type of crime. This change would increase the fraction of offenders who get caught from 15% to 20%. The social cost of each crime is $10,000. The cost of trial and punishment for each convicted criminal is $100,000. Suppose the increase in detection results in a decrease in the number of crimes committed from 1,000 per year to 700 per year. Calculate the effect of...
The following questions refer to Quantum Dot samples (CdSe). We measured absorbance with a spectrophotometer. 1....
The following questions refer to Quantum Dot samples (CdSe). We measured absorbance with a spectrophotometer. 1. Why does a wavelength of 400 nm excitation work for all emission samples? 2. Can you use other excitation wave length other than 400 nm? Why or why not? 3. Why does the UV lamp work well for quantum dots excitation in this experiment? 4. Your explanation of emission spectra in connection to the quantum particle-in-a-box model.
When making inferences concerning the mean difference using two dependent samples, it is necessary to calculate...
When making inferences concerning the mean difference using two dependent samples, it is necessary to calculate the standard deviation of the sample differences. Calculate the standard deviation of the sample differences using the following information. Round to 2 decimal places. College Placement Test Results Applicant 1 2 3 4 5 Before 51 62 74 64 72    After 68 87 82 75 84
Using the Assessment 5, Part 1 Template, analyze and compute the necessary financial ratios. The Financial...
Using the Assessment 5, Part 1 Template, analyze and compute the necessary financial ratios. The Financial Statements worksheet in the template contains the income statement, balance sheets, and additional information needed. The Ratio Analysis worksheet contains space for your calculations and answers. Net sales (all on account) $600,000 $520,000 Assets Expenses: Current Assets Cost of Goods Sold $415,000 $354,000 Cash $21,000 $18,000 Selling and administrative $120,800 $114,600 Short-term investments $18,000 $15,000 Interest Expense $7,800 $6,000 Accounts Receivable $86,000 $74,000 Income...
Design an experiment to find the iron concetration (Fe3+) in spinach using a spectrophotometer
Design an experiment to find the iron concetration (Fe3+) in spinach using a spectrophotometer
A solid was dissolved in water and analyzed using thin layer chromatography. All the necessary precautions...
A solid was dissolved in water and analyzed using thin layer chromatography. All the necessary precautions were taken to get a good result. The chromatogram had three spots with Rf values of 0.25, 0.38, 0.74 in the column for the solid. If a fresh sample of the solid were tested to measure the melting point, would the melting point have been sharp or have been a broad range? Explain your answer.
A developed TLC plate was examined under UV light. Was it a necessary step if both...
A developed TLC plate was examined under UV light. Was it a necessary step if both ferrocene and acetylferrocene are visible without a visualization method? Why or why not? I need at least a paragraph response to this question!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT