ructions: Figure 1: Using Microsoft Excel, create a scatter plot using the conce
ID: 572957 • Letter: R
Question
ructions: Figure 1: Using Microsoft Excel, create a scatter plot using the concentration and absorb methylene blue standards and determine the slope and y-intercept using the linear model equat Once you have appropriately set up your spreadsheet, you should be able to predict the unknown of methylene blue using the absorbance data that you collected. This unknown concenta as a separate data point on your figure (with an appropriate label in the key) and should fall along th if calculated properly ance data for your ion Y=mX+ b concentration be plotted e trendline Your figure should include the following: .Explanation / Answer
a plot of concentration ( on x-axis) and absorbance ( on y-axis) is generated and shown below.
the equation of best fit is abosrbance =127.1*concentration ( mg/ml)-0.145
at 1.683 absorbance, fro mthe equation, 1.683= 127.1* concentration-0.0145
concentration = (1.683+0.0145)/127.1=0.0143 mg/ml
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.