How to Determine Protein Concentration from Standard Curve in Excel

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel Functions that we can use to create formulas. Many educational institutions and business companies use excel files to store valuable data. Sometimes, we insert charts or graphs because they represent survey results better. We can easily plot mathematical equations in excel. However, we can also generate equations from a standard curve in excel. This article will show you 2 easy ways to Determine Protein Concentration from Standard Curve in Excel.


Download Practice Workbook

Download the following workbook to practice by yourself.


2 Easy Ways to Determine Protein Concentration from Standard Curve in Excel

Often, we need to carry out various operations in excel worksheets. You’ll see how to determine protein concentration from a standard curve here. Before that, we need some protein sample concentrations and corresponding absorbance. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset contains some known protein concentration in g/L and their absorbance at 610 nm. We’ll generate a graph using this dataset. Now, learn the methods for determining protein concentration from this standard curve in excel.

how to determine protein concentration from standard curve in excel


1. Use Linear Equation Formula to Determine Protein Concentration from Standard Curve in Excel

We all know a simple linear equation formula which is:

y = mx + c

We’ll use this equation in our first method to get the protein concentration. But first, we’ll show the steps to generate a standard curve from the given dataset. Here, the protein concentrations are our X-axis values and absorbances are Y-axis values. Therefore, follow the below steps to perform the task.

STEPS:

  • First, select the range B4:C10.
  • Then, go to Insert ➤ Charts ➤ Scatter.
  • The following figure will make the steps clearer.

Use Linear Equation Formula to Determine Protein Concentration from Standard Curve in Excel

  • As a result, you’ll see the standard curve.
  • The below graph is our scatter chart output.

  • Now, double-click any of the scatter plottings in the curve.
  • Next, select Add Trendline in the Context Menu.

  • Afterward, double-click the trendline and select Format Trendline.
  • Consequently, the Format Trendline pane will appear.
  • There, check the box for Display Equation on chart.

  • Hence, you’ll see the trendline with the equation.
  • Look at the following picture where the final output is demonstrated.

  • If we compare the equation in the curve with the linear equation y = mx + c, we get m = 0.0292 and c = -0.0828.
  • Subsequently, we place the values in cells C12 and C13 respectively.

  • We have the absorbance of an unknown sample in cell C16 (859) which can also be termed y.
  • Now, to get the unknown sample concentration or x, we’ll apply the formula:
x = (y-c)/m
  • For this purpose, click cell B16.
  • Type the formula:
=(C16-C13)/C12
  • Press Enter.
  • At last, it’ll return the protein concentration of an unknown sample.


2. Determine Protein Concentration from Standard Curve with Excel TREND Function

Moreover, the TREND function gives out values present in a linear trend analyzing the known data points. We’ll use this function to get protein concentration in excel. So, learn the following process to carry out the operation.

STEPS:

  • Firstly, click cell B13.
  • Then, input the formula:
=TREND(B5:B10,C5:C10,C13)
  • Consequently, press Enter.
  • Thus, it’ll return the precise output.

Determine Protein Concentration from Standard Curve with Excel TREND Function


Conclusion

Henceforth, you will be able to Determine Protein Concentration from Standard Curve in Excel following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo