Fit y by x

[#1]

Dear JMP community,

I collected datasets for the absorption behaviour for 2 different dyes. So I made absorption measurement for 3 different dilution series of the 2 dyes and consequentely want to analyze the data sets with JMP. My final goal is to get an averaged extinction coefficient of the 2 dyes and analyze each resulting graph (linear correlation) statistically among themselves. So far I just managed to analyze each graph by themself with Fit y by x. Can somebody help me with this problem?

Best regards

[#2 · Accepted solution]

You can use Bivariate as before but include the three replicates in the regression analysis. Do not average the dilution series first. Put Dye in the By role to separate the data analysis but confine the results to one window.

Here is mock up of your study:

Here is the resulting analysis:

I saved the script for this analysis to the data table. I attached the data table with the mock up of your study.

[#3]

@Mark_Bailey  Thank you very much for your quick response. Your solution  helped me a lot. I made the misstake to sort the data for each series in seperate columns so I couldn't analyze all at once.