prediction line plot

[SarahAdina]

Hi, I am trying to make a pedriction analysis in Knime. I have a table with a column for year and a column for difference in pay. I have the years from 1997 to 2022, and want to make a prediction from 2023 to 2050. I want to show it in a line plot.

this is part of the table i have.

I want it to look a bit like this:

I have have tried this:

Can someone help me?

[mlauber71]

@SarahAdina welcome to the KNIME forum. About the graphic you could try to adapt this example:

How to rotate the scale of a Line Plot?

@rogerius1st and there I was hoping to convince you of the benefits of employing Python graphics in order to get interesting charts: [from_knime_linechart_dates] With the help of KNIME Data Apps one can create a GUI where you can select the data change settings in order to make this usable in similar situations: [image] The settings will be converted into Python code. Once a framework is there you can change the settings - or even better ask ChatGPT to do it for you. Also let it explain th…

[SarahAdina]

I’m not sure if this is relevant for this, I don’t want to rotate, I just want to make a prediction 27 years in the future based on historical data?

[gonhaddock]

Hello @SarahAdina
I think that what you are looking for -specially if you don’t have any other data-; it isn’t about prediction, but dealing with uncertainty.

I would try to create a Montecarlo simulation model on a year by year basis; based on current salary differentials statistical distribution

BR

[mlauber71]

@SarahAdina the example was for your task of displaying your results.

Concerning the prediction you first might have to decide if you have a regression or a time Series problem

Prediction of cost based on the historical data

@singhsukh12 you will have to decide if this is a problem that indeed can be formulated as a regression task, this will depend on the relationship between your variables and he target. A collection of regression algorithms can be found here Otherwise this might be a time series problem if the costs are seasonal.

Concerning time series here are some hints:

Getting started with time series

@polina_l there is a dedicated book as well as examples on the KNIME Hub you could begin with Codeless Time Series Analysis with KNIME KNIME Hub Space - Codeless Time Series Analysis with KNIME (the examples from the book) Tutorial: Introduction to Time Series Analysis Time Series Analysis with KNIME — an introduction Time Series Analysis Workshop [Time Series Analysis Workshop] Time Series Analysis with the KNIME Analytics Platform [Time Series Analysis with the …