topic Re: Fit y by x in Discussions

Fit y by x

Freddy — Sun, 11 Jun 2023 11:07:10 GMT

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

Re: Fit y by x

Mark_Bailey — Mon, 26 Oct 2020 16:03:06 GMT

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.

Re: Fit y by x

Freddy — Tue, 27 Oct 2020 15:15:00 GMT

@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.