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.
Choose Language Hide Translation Bar
View Original Published Thread

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