I am trying to figure out the slope for each cycle in a time series and was wondering what could be done next to evaluate this. The slope of the highlighted section in blue is to be found
You will need to create a new data column that identifies each cycle. Then use Analyze > Fit Y by X. Cast Column 5 in the Y role, Time in the X role, and the grouping column in the By role. Click OK.
Press and hold the Ctrl key for Windows or the Command key for macOS, click the red triangle next to the first Bivariate object, and select Fit Line. (Actually, it looks like the cycles have a non-linear change, so you might try Fit Polynomial degree=2 instead.) Right-click on a table of Parameter Estimates and select Make Combined Data Table.
Thanks @Mark_Bailey .
But how can I make another data column that automatically identifies each cycle?
The existing column is attached
No importable file was attached.
Do you mean the observations go up and down once is a cycle? Then based on the plot, the big jump might be a good indicator. The jumps are pretty large. To calculate jumps, you can generate them from Time Series platform directly. Look for Difference, then follow the steps accordingly. In the end, "Save" column from the Difference report.
Otherwise, using JMP column formula to generate the jumps is also straightforward. Right click on your data column, choose "New Formula Column", choose "Row", choose "Difference".
@peng_liu Please see the revised diagram. I need the slopes of the lines starting from the peak point to the lowest point for each cycle .
