cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

Write Slope to Data Table

Sarah1
Level I

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.

1 REPLY 1
txnelson
Super User

Re: Write Slope to Data Table

If your data are similar to this

txnelson_0-1737953244867.png

You can run your Bivariates

txnelson_1-1737953316390.png

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

txnelson_2-1737953489780.png

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.

txnelson_3-1737953622508.png

 

 

 

Jim