For the calculations do the following

Data Analysis:

Calculate the concentration and how many milligrams of dye (in µM, micromolar) of FD&C Blue-1 dye in the stock solution.

Calculate the concentration and how many milligrams of dye (in µM, micromolar) of each of the eight solutions prepared in test tubes A-H.

Calculations and graphs

Enter the data for concentration and percent transmittance for test tubes A-H into LoggerPro (or Google sheets)

Create calculated columns for:

o Concentration (in M, molar)

o Transmittance

o -Log (Transmittance)

Create a graph that shows the relationship between -Log (Transmittance) (on y-axis) to the concentration (in M,

on the x-axis)

Data to be used to complete calculations

Perform a linear fit on the data to get the slope of the line, the molar absorptivity constant, for FD&C Blue-1 dye.

Use the percent transmittance for the various consumer drinks to calculate their:

o Transmittance

o -Log (Transmittance)

Use the Beer-Lambert Law, the absorptivity constant and the -log (transmittance) values for the various consumer drinks to calculate the concentration of dye in them.

Use the concentrations above to calculate the amount of FD&C Blue-1 dye (in milligrams) in one container of each of the consumer drinks.

Make sure the graphs and calculations are the following Calculations and/or a graph are done/created that represent the data in a way that helps to answer a question, all calculations are polished, graph has all required element done/created that represent the data in a way that helps to answer a question, all calculations are polished, graph has all required elements which is as follows

 Descriptive, Relevant Title

 Axes Labeled

 Units on All Axes

 Points Plotted Correctly

 Best Fit Line/Curve (if appropriate)

 Points Connected (if appropriate)

 Data Table with Column Labels

 Short Description of What is Being Shown

 Multiple Data Sets Merged/Overlaid (if appropriate)

 Name of Author/Creator (if submitted out of context)

Conclusion

write it so it answers the following

For the overall lab and each part:

 A claim about the purpose: Was it successful? What was the overall result? (The purpose of this experiment was to determine the amount of artificial dye found in consumer drink by the spectrophotometric Orange light of maximum wavelength of 630µm)

 Specific observed evidence (raw data or calculated values) from the lab.

 Scientific reasoning citing things that could not be observed directly (particles too small for the eye to

see or forces between particles)

Make sure the conclusion fits in these descriptions

A claim is made that answers the original question or prompt There is specific evidence cited from the data, calculations, and/or graphs to support the claim Scientific reasoning connecting the evidence to the claim is thorough.

In addition to being proficient, further predictions are made (or follow-up investigation are proposed) using the results from the investigation