Use the following data to generate the standard curve needed...

Use the following data to generate the standard curve needed to determine the concentration of your purified DHFR protein sample: Concentration (µg/mL) | Absorbance 100 | 0.180 500 | 0.250 1000 | 0.375 1500 | 0.470 2000 | 0.630 Use the standard curve generated from the data provided above and the dilution and absorbance reading below to determine the concentration of your purified DHFR protein sample. • Be sure to account for any dilution in your final concentration result. • Please also convert the final DHFR protein concentration obtained from ug/mL for mg/mL for your reported results. • Round the final mg/mL concentration reported to 3 significant digits. Sample dilution (part:whole) | Absorbance 1:10 | 0.495

Transcript

00:02 So now you have a chart with the concentration of a protein in the first column and then also you have absorbance on the second column.

00:13 So you can see the protein is in a concentration of microgram per mil and absorbance is being listed on the right column.

00:21 So use this data to create a standard curve first and then calculate the final concentration by using a dilution and also convert the concentration from microgram per mil to milligram per mil and round up to three significant numbers.

00:41 So the very first step you want to create a standard curve.

00:44 What i would do is i would select both columns and then i would go to insert.

00:50 Then i will go to the chart and i will select the scatter chart right here and select the first one here, scatter.

01:01 So you can see that i got five dots each represent one data point here.

01:07 Now then i'm going to label the x and y axis by clicking the axis title.

01:14 So the x axis is going to be the concentration.

01:20 So i want to label it so that you guys don't get mistaken.

01:25 So microgram per mil.

01:28 So always label your axis and y obviously is absorbance.

01:36 There's no unit.

01:41 So now we know x is always concentration, y is absorbance.

01:44 We have this linear correlation between the concentration versus absorbance.

01:49 So the next step you want to right click the each of the one of data point and then go to the trend line.

02:02 And then you will see a trend line which is linear and then you want to go all the way down to the format trend line bottom which has several options.

02:11 You want to check display equation on chart and display r square value on chart.

02:17 So the y equals 0 .002x plus 0 .1424 will be the standard curve and r square value shows how accurate the data is.

02:28 So you can see 0 .099 is very close to one so it means these data are close to the line.

02:35 So this is what we want to use.

02:38 So this is our standard curve.

02:41 So now i want to use the whiteboard to calculate the rest of the content.

02:50 So let's go to whiteboard...

Question

Please give Ace some feedback