We simply have to check the option for Display R-squared value on chart. LINESTyvalues xvalues123 note curly brackets but they give the same answer and the same as the trend line in a chart for the same data. Using Microsoft Excel to plot and apply standard curve A protein assay such the BCA Protein Assay is an excellent tool for estimating the protein concentration of a sample.
Again use the fill handle to quickly copy and paste the formula for all the cells.
You will get a linear line and excel can generate the equation. You will get a linear line and excel can generate the equation. In the opening Format Trendline pane check the Polynomial option and adjust the order number in the Trendline Options section and then check the Display Equation on Chart option. Navigate to the Charts menu and select the first option in the Scatter drop-down.