standard concetration curve on excel for mac

Standard Concetration Curve On Excel Series Of Data

One of the big advantages of ELISA is that it can be used to accurately quantify protein levels.

The linear part of this standard curve is the most sensitive part of the curve and is the.

The R 2 value tells how close to the trendline the data actually is, and a value of 0.9986 is pretty good (a value of 1 would be perfect).

It is also possible to use Excel to insert a trendline in the non-linear part of the standard curve.

This would be useful for quantitation of samples giving stronger signals, so that the OD values obtained correspond to this non-linear part of the standard curve.

In this case insert a trendline and select the Polynomial option, which will give an equation of the form Y AX 2 BX C; this can then be pasted in the other cells of the spreadsheet as was done for the simpler linear equation.

This can be helpful when you are writing a chemistry lab report or programming a correction factor into a piece of equipment.

Standard Concetration Curve On Excel Series Of Data

This lets you create a series of data pairs that youll then use to develop a calibration curve.

When you plot those two data pairs as points and draw a line between them (the calibration curve), then assuming the response of the thermometer is linear, you could pick any point on the line that corresponds to the value the thermometer displays, and you could find the corresponding true temperature.

This is useful for a visual display, but you can also calculate the formula of the line using Excels SLOPE and INTERCEPT functions.

When you enter these values into simple formulas, you will be able to automatically calculate the true value based on any measurement.

The X-values will be our standards, and they could represent anything from the concentration of a chemical solution we are measuring using a scientific instrument to the input variable of a program that controls a marble launching machine.

Check the boxes next to Display Equation on chart and Display R-squared value on chart.

The R-squared value is a statistic that tells you how closely the line fits the data.

The best R-squared value is 1.000, which means every data point touches the line.

As the differences between the data points and the line grow, the r-squared value drops, with 0.000 being the lowest possible value.

Note that the correlation of the data is very good in our example, with an R-squared value of 0.988.

Well perform the actual calculations in the cells beneath those titles.

In the Knownys field, select or type in the Y-Value column cells.

The order of the Knownys and Knownxs fields matters in the SLOPE function.

Select or type in the Y-Value column cells for the Knownys field.

The order of the Knownys and Knownxs fields also matters in the INTERCEPT function.

Select or type in either of the two cell ranges for the Array1 field.

Unlike SLOPE and INTERCEPT, the order does not affect the result of the CORREL function.

The CORREL function returns R, so we must square it to calculate R-squared.

The Y-value returned should be equal to the INTERCEPT of the line of best fit.

The X-value returned should be equal to zero, but the value returned is 3.14934E-06.

The value returned is not zero because we inadvertently truncated the INTERCEPT result when typing the value.

The formula is working correctly, though, because the result of the formula is 0.00000314934, which is essentially zero.

This formula is what you would use to calculate the concentration of that solution or what input is needed to launch the marble a certain distance.

We can be reasonably confident in these results because of the high R-squared value in this example.

Standard Concetration Curve On Excel For Mac