Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
- - - - -

mRNA level-Pearson-Excel

  • Please log in to reply
1 reply to this topic

#1 nikou



  • Active Members
  • Pip
  • 1 posts

Posted 27 January 2009 - 02:09 AM


I`m now analyzing correlation coefficient (Pearson) for mRNA level and fat content.
My problem is I`m not sure how to compute the mRNA levels (measured by Real-time PCR) in the Pearson formula and the scatter plot using Excel.
I was thinking to use the ∆Ct (target gene - reference gene), but then I found some papers using the 2-ΔΔCt, and one of them also used 2-ΔCt.

Also, I`ve been searching about how to make the scatter plot and trendline for this Pearson test in Excel.
Using Excel, I always end up with the graph for regression analysis and I don`t know how to make the graph or trendline into Pearson.
I checked the R values for regression and Pearson and they both are quite the same, although I`m kind of sure that the graph would be somehow different between those two tests.

Hope my questions aren`t (gramatically) confusing and anyone can help me because my head is spinning right now :(


#2 pcrboy



  • Active Members
  • Pip
  • 18 posts

Posted 27 January 2009 - 03:11 AM

The standard approach is to normalize your data, generally by using the control. Although I'm unfamiliar with the 2-dCt, I do understand how dCt is trying to normalize all data for mRNAs. Also, if your qPCR contains only relatively few samples, it may be good to try to calculate a p-value. As for the correlation coefficient, there is a simple function in excel (CORREL i think) which will calculate the Pearson coefficient for you.

Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.