I need to predict "Y" variable using the already predicted values in "X". The highlighted yellow data is the current data. I used the timeseries Arima() model to predict the X values for next 25 periods. Now, I need to use these values to predict my "Y" and then plot the "Y" over time period with confidence intervals.
I am new to the prediction models and need guidance on what to use that can help take the "X" values and predict for missing "Y"
Thanks!