Please explain your answer to the following questions. Sincethere are 4, I have increased the points. Thank you verymuch.
The following calibration data were collected by measuring the absorbance of each solution five times, and then calculation the average absorbance for each solution. The data have not been corrected. Using the data, generate a calibration curve and determine the R2 value for the graph using all data including the blank. Report the R2 to 3 decimal places. Using the calibration curve from the previous question, calculate the concentration of iron in a check standard based on the following data: Absorbance = 0.343, 0.345, 0.338, 0.342, 0.339. Also calculate the uncertainty as the standard deviation of x (see equation 4-27 in the textbook) associated with the check standard concentration using LINEST. Report the concentration and uncertainty to the appropriate number of significant figures. To calculate the 95% confidence interval associated with your answer to the previous question, you would need to multiple sx by which t-value? Report your answer to at least three decimal places. If the known concentration of the check standard (from Question 4) is 15.27 mg/L, what is the percent recovery?
First, make a calibration curve using only the area of the ethanol peak and the concentrations of the standards. As in Part 1 a and b, prepare and print a calibration curve including the linear least squares equation of the line equation and the R2 value, and print a copy for your report. Also, calculate the concentration of your sample and the uncertainty (95% confidence interval), as well as the uncertainty of the unknown determination on a percentage basis, and include these values in your report. .
Next, make a calibration curve based on the ratio of ethanol area to propanol area and the concentrations of the standards. As in the previous question, prepare and print a calibration curve including the linear least squares equation of the line equation and the R2 value, and print a copy for your report. Also, calculate the concentration of your sample and the uncertainty (95% confidence interval), as well as the uncertainty of the unknown determination on a percentage basis, and include these values in your report. .
At a blood alcohol concentration of 0.08% (w/v) or more a person is considered impaired. Briefly discuss whether the calculated results for the sample in e and f above support criminal charges of impairment.
Report Requirements:
Spreadsheet with graphs and calculations. Prepare separate sheets in one excel file for each of the following:
Data Set 1
Data Set 2
Calibration with external standard
Standard addition with one standard (optional, could submit hand or type written calculation only)
Standard addition with multiple additions
Internal standard peak areas
Internal standard peak area ratios
Print-outs of graphs
Data Set 1
Data Set 2
Calibration with external standard
Standard addition with multiple additions
Internal standard peak areas
Internal standard peak area ratios
Results
Fill in the table below with results from the spreadsheet. Remember to include units.