Correlation of Different Data TypesHow could I correlate delta CT values and biomass in grams or seed count in arithmetric numbers.
Re: Correlation of Different Data TypesCan you show even a few observations (rows) of data? Hard to picture your problem.
Re: Correlation of Different Data TypesFew rows of data attached.
Re: Correlation of Different Data TypesYou reply contains no example in any form.
Also, please explain the nature of the variables, delta CT values and biomass in grams or seed count, and the intent of your analysis of correlation.
Re: Correlation of Different Data TypesI attached an excel spreadsheet that had my data in columns. The CT value is an a.n. or unit received from qPCR results that is used to measure the gene expression in a sample of plant tissue. For example the higher the CT value the more copies of the gene and the higher the expression. What I was asked is there any correlation between the gene expression of the plant tissue and the biomass of the plant at the given treatments. So does Ox+Myc+4End+Bs biomass of the shoot, root, seed wt. and seed count correlate with Agp CT value of the gene expressed by Ox+Myc+4End+Bs and so forth. Someone suggested the R squared values is what I would look at but that does not make sense to me.
Re: Correlation of Different Data TypesI still do not see any attachment to any reply in this discussion thread.
Re: Correlation of Different Data TypesOk, lets try this again:
I attached an excel spreadsheet that had my data in columns. The CT value is an a.n. or unit received from qPCR results that is used to measure the gene expression in a sample of plant tissue. For example the higher the CT value the more copies of the gene and the higher the expression. What I was asked is there any correlation between the gene expression of the plant tissue and the biomass of the plant at the given treatments. So does Ox+Myc+4End+Bs biomass of the shoot, root, seed wt. and seed count correlate with Agp CT value of the gene expressed by Ox+Myc+4End+Bs and so forth. Someone suggested the R squared values is what I would look at but that does not make sense to me.
Re: Correlation of Different Data TypesThe data is in an Excel workbook. Do you use JMP?
I used multiple regression to assess the relationship between shoot dry weight, root dry weight, seed weight, Myc, 4End, and Bs with the responses Agp shoot CT and Agp root CT separately. I included quadratic terms for the quantitative factors because my initial analysis indicated a non-linearity. I did not include any terms for potential interaction effects.

The Agp Shoot CT shows the strongest effects. The factor Myc is probably not significant. The Profiler is the easiest way to interpret the model.

There is only a weak relationship for the Agp Root CT. There appears to be twice as much variation in this response compared to the first response but much less of it is correlated with the changes in the factors. Does it make sense that the response would exhibit a minimum near the middle shoot dry weight?
My observations are:
- This data set is small so there is low power for detecting active effects.
- The experiment varied 6 factors over 10 runs, so many effects are confounded.
- Either the Myc, 4End, and Bs factor levels were recorded incorrectly or this experiment was not designed using statistical principles. There are unnecessary correlations among the factors that reduce the efficiency of the data for estimation.
Re: Correlation of Different Data TypesYes, I do use JMP.