I have built a time series model in R for Quarterly data.
Data:
year Qtr1 Qtr2 Qtr3 Qtr4
2017 21000 22000 17000 19000
2018 20000 22000 18000 19000
2019 32000 30000 28000 26000
2020 25000 23000 24000 27000
2021 40000 12000
For year 2021 we have Qtr 1 and Qtr 2 data with totals. Qtr 1 is full quarter data whereas Qtr2 is 30 days of Q2 data.
Using this 30 days data I need to predict the entire Q2 results. What will be end value of that Q2.
I tried Holt winters
t_data<-ts(mydata1_subset$total,frequency = 4,start = c(2016,1),end = c(2021,2))
t_data_timeseries_hw <- hw(t_data,seasonal="additive",
initial = c("optimal", "simple"), level = .95)
The result prediction am getting is from Q3 , Q4 etc..,But I need to get the prediction from Q2 and goes like Q3,Q4... is their a way to achieve this, any help would be greatly appreciated