topic Re: Write Slope to Data Table in Discussions

Write Slope to Data Table

Sarah1 — Mon, 27 Jan 2025 03:17:27 GMT

I have a data table with variable data over time per batch. Each variable value is on an individual row with it's corresponding time. I am looking to write the slope of the linear fit of that X(time) to Y(variable). I have done a bivariate fit per batch with a linear fit to get the slope per batch. I am looking to write this value back to the data table. The goal is to add a column of each batches' slope to compare between batch variability. There are 800+ batches, so copy and paste from the graphs is not an option.

Re: Write Slope to Data Table

txnelson — Mon, 27 Jan 2025 04:53:58 GMT

If your data are similar to this

You can run your Bivariates

And then right click on any of the Parameter Estimates tables and select

Make Combined Data Table

It will then create a table with the Intercepts and Time Estimates for each batch

You can then simply delete the intercept rows, and you will have a table of all of just your Time Estimates, which are your slopes.