Scenario: You are performing the Bradford assay. Following...

Scenario: You are performing the Bradford assay. Following are the tables containing OD values. Note that here, we are assuming that • you have made the dilution series • performed the Bradford assay • used the spectrophotometer to determine the OD values corresponding to each dilution. Table 1. Absorbance reading for protein standard curve using BSA as known protein Mg/ml BSA Absorbance (OD value) 0 0 0.1 0.16 0.2 0.37 0.3 0.43 0.8 1.28 1.0 1.4 3. Make a standard curve, using the data from table 1, using Excel. (3 pts) The graph should have a Title and properly labelled axes. Submit the graph (Excel) with your worksheet.

Transcript

00:05 So you're given a set of data with the first column, the concentration of a bsa milligram per millier in the first column, and then you have the second column which has the absorbance for each bsa sample.

00:22 So you can see there are altogether six samples.

00:26 When the bsa has a concentration of zero, the absorbance from the spectrometer is also zero.

00:32 When bsa has a concentration of 0 .1 milligram per millimeter, the absorbance is 0 .16, and then so go on and forth.

00:41 So you can see for each bsa sample, it's going to produce one absorbance.

00:48 So the question asks you to create a standard curve according to the bsa concentration and absorbance.

00:57 And also you need to properly label the axis.

01:00 Okay, so what you need to do is, first of all, you have to put the concentration of the bsa in the first column and go down this way, like what i did.

01:12 The second column is going to be absorbance, again, for each of the sample, you have to go again down this way.

01:19 So once you put all your numbers in the first two columns, you're going to select both columns.

01:26 So you make sure bsa is in front of absorbance.

01:28 The next step, you're going to click insert.

01:33 And then you go to the chart section, and then you will click the scattered or bubble chart.

01:40 When my cursor is, and then you click that, and you choose the first one on the top.

01:46 So with this one here.

01:50 So you choose scattered chart, you'll see, now you have a graph or diagram right here.

01:59 Remember the bsa concentration is always the x axis and then the absorbance is always on a y.

02:07 So you want to make sure that they're in the correct orientation.

02:12 The next step, you want to add the x's title to remind yourself.

02:17 So you can change that into xbsa concentration in milligram per militer.

02:31 So this is a label x -axis, and then you can, again, do the same thing to label y -axis, which obviously absorbance.

02:42 So this is properly labeled.

02:45 And then you want to create this trend line.

02:49 So i want you to right -click the one of the dot.

02:53 It doesn't matter which dot...

Question

Please give Ace some feedback