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
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,...
Related questions
Question

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images

Recommended textbooks for you

Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON

Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax

Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,

Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON

Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax

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)
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
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.

Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education