How to Determine Protein Concentration from Standard Curve in Excel

Get FREE Advanced Excel Exercises with Solutions!

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 a Standard Curve in Excel.


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

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 (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

Read More: How to Calculate Unknown Concentration from Standard Curve in Excel


Download Practice Workbook

Download the following workbook to practice by yourself.


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. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


<< Go Back to Excel Standard Curve | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo