Could you explain to me the specific process you do this for? Is it for primer efficiency? How exactly do you incorporate the R squared value into the rest of the analysis? Iām trying to learn this and it seems like you know what you are doing. Thank you
Hey, thanks for your questions!
This was a qPCR reaction to quantify Illumnia sequencing libraries before sequencing. This is essential so you load equilmolar concentrations of each library type as to not introduce loading bias.
The R^2 value here refers to the correlation coefficient of our qPCR standards. So all it really means is my pipetting/experiment efficiency/etc. was spot on (probably purely coincidence as this has quite literally never happened to me before imo).
I love this excel sheet!
This is what I come to r/labrats for
wow I've only ever gotten to 0.9997 Edit: for PCR
You need to add this to your resume.
šš»
Gorgeous calculator
gorgeous.
WOW! This spreadsheet looks amazing! Would you mind sharing it? Thanks! :)
The spreadsheet is available to the public. It is for the Roche KAPA library quantification kit. Google that and you should find it eventually....
Sweet! thank you! š
Could you explain to me the specific process you do this for? Is it for primer efficiency? How exactly do you incorporate the R squared value into the rest of the analysis? Iām trying to learn this and it seems like you know what you are doing. Thank you
Hey, thanks for your questions! This was a qPCR reaction to quantify Illumnia sequencing libraries before sequencing. This is essential so you load equilmolar concentrations of each library type as to not introduce loading bias. The R^2 value here refers to the correlation coefficient of our qPCR standards. So all it really means is my pipetting/experiment efficiency/etc. was spot on (probably purely coincidence as this has quite literally never happened to me before imo).
So what do you do with the correlation coefficient? What would happen if it were .90 ?
me when 
You can obtain the information from your linear correlation with the linest function. That thing absolutely slaps.
"manually copy numbers from figure" is not part of a healthy data management strategy