I need help to Produce a BSA standard curve. Use Excel to draw a scatter plot (data points are not connected with a line) using the data obtained for the BSA standards. Generate a linear regression line. the graph must indicate and clearly label on the y axis the average absorbance values obtained for diluted skim milk, diluted whey pH 4.2 and diluted whey pH 4.8 and draw a dashed horizontal line that will intersect the regression line; from the trendline intersect then draw a vertical line that will intersect with the x-axis. here are my numbers: BSA CONCERNTRATION AVERAGE 20 ug/mL BSA 0.175 50 ug/mL BSA 0.231. 100 ug/mL BSA 0.480 150 ug/mL BSA 0.680 200 ug/mL BSA 0.838 Absorbance 1 Absorbance 2 Average SKIM MILK 0.536 0.628 0.582 WHEY PH 4.8 1.09 0.963 1.027 WHEY PH 4.2 0.313 0.191 0.252

Human Anatomy & Physiology (11th Edition)
11th Edition
ISBN:9780134580999
Author:Elaine N. Marieb, Katja N. Hoehn
Publisher:Elaine N. Marieb, Katja N. Hoehn
Chapter1: The Human Body: An Orientation
Section: Chapter Questions
Problem 1RQ: The correct sequence of levels forming the structural hierarchy is A. (a) organ, organ system,...
icon
Related questions
Question
I need help to Produce a BSA standard curve. Use Excel to draw a scatter plot (data points are not connected with a line) using the
data obtained for the BSA standards. Generate a linear regression line. the graph must indicate and clearly label on the y axis the
average absorbance values obtained for diluted skim milk, diluted whey pH 4.2 and diluted whey pH 4.8 and draw a dashed horizontal
line that will intersect the regression line; from the trendline intersect then draw a vertical line that will intersect with the x-axis. here
are my numbers: BSA CONCERNTRATION AVERAGE
20 ug/mL BSA 0.175
50 ug/mL BSA 0.231.
100 ug/mL BSA 0.480
150 ug/mL BSA 0.680
200 ug/mL BSA 0.838
Absorbance 1 Absorbance 2 Average
SKIM MILK 0.536 0.628 0.582
WHEY PH 4.8 1.09 0.963 1.027
WHEY PH 4.2 0.313 0.191 0.252
Transcribed Image Text:I need help to Produce a BSA standard curve. Use Excel to draw a scatter plot (data points are not connected with a line) using the data obtained for the BSA standards. Generate a linear regression line. the graph must indicate and clearly label on the y axis the average absorbance values obtained for diluted skim milk, diluted whey pH 4.2 and diluted whey pH 4.8 and draw a dashed horizontal line that will intersect the regression line; from the trendline intersect then draw a vertical line that will intersect with the x-axis. here are my numbers: BSA CONCERNTRATION AVERAGE 20 ug/mL BSA 0.175 50 ug/mL BSA 0.231. 100 ug/mL BSA 0.480 150 ug/mL BSA 0.680 200 ug/mL BSA 0.838 Absorbance 1 Absorbance 2 Average SKIM MILK 0.536 0.628 0.582 WHEY PH 4.8 1.09 0.963 1.027 WHEY PH 4.2 0.313 0.191 0.252
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Human Anatomy & Physiology (11th Edition)
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Molecular Biology of the Cell (Sixth Edition)
Molecular Biology of the Cell (Sixth Edition)
Biology
ISBN:
9780815344322
Author:
Bruce Alberts, Alexander D. Johnson, Julian Lewis, David Morgan, Martin Raff, Keith Roberts, Peter Walter
Publisher:
W. W. Norton & Company
Laboratory Manual For Human Anatomy & Physiology
Laboratory Manual For Human Anatomy & Physiology
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.
Inquiry Into Life (16th Edition)
Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education