Dec 17 2021 11:48 PM
I have data in the below table format and want to forecast for the remaining four months, but the formula I am using is not giving a fruitful output
=FORECAST.LINEAR(BL3,$H5:$BK5,$H$3:$BK$3)
Jan 2015 | Feb 2015 | Mar 2015 | Apr 2015 | May 2015 | Jun 2015 | Jul 2015 | Aug 2015 | Sep 2015 | Oct 2015 | Nov 2015 | Dec 2015 | Jan 2016 | Feb 2016 | Mar 2016 | Apr 2016 | May 2016 | Jun 2016 | Jul 2016 | Aug 2016 | Sep 2016 | Oct 2016 | Nov 2016 | Dec 2016 | Jan 2017 | Feb 2017 | Mar 2017 | Apr 2017 | May 2017 | Jun 2017 | Jul 2017 | Aug 2017 | Sep 2017 | Oct 2017 | Nov 2017 | Dec 2017 | Jan 2018 | Feb 2018 | Mar 2018 | Apr 2018 | May 2018 | Jun 2018 | Jul 2018 | Aug 2018 | Sep 2018 | Oct 2018 | Nov 2018 | Dec 2018 | Jan 2019 | Feb 2019 | Mar 2019 | Apr 2019 | May 2019 | Jun 2019 | Jul 2019 | Aug 2019 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $145 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $430 | $1,545 | $2,236 | $906 | $3,645 | $1,573 | $4,951 | $4,360 | $7,355 | $3,264 | $9,354 | $9,014 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $6,355 | $4,329 | $5,992 | $5,772 | $4,678 |
$6,018 | $5,225 | $3,427 | $11,148 | $501 | $36 | $36 | $0 | $924 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,207 | $1,291 | $1,465 | $153 | $150 | $0 | $30 | $0 | $0 | $0 | $0 | $1,734 | $1,600 | $1,358 | $587 | $60 | $353 | $0 | $205 | $0 | $899 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $35,604 | $10,498 | $5,835 | $3,077 | $1,612 | $1,404 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,357 | $9,343 | $8,355 | $8,148 | $4,151 | $17,420 | $4,212 | $15,695 | $0 | $7,795 | $421 | $4,934 | $2,616 | $4,687 | $3,667 | $3,056 | $3,870 | $5,067 | $6,715 | $8,711 | $18,797 | $8,445 | $16,879 | $16,117 | $15,333 | $11,380 | $4,943 | $18,217 | $4,325 | $10,253 | $10,261 | $14,308 | $4,295 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,778 | $312 |
$452 | $635 | $469 | $209 | $120 | $32 | $26 | $0 | $0 | $0 | $0 | $0 | $0 | $2,929 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Dec 18 2021 03:30 AM
Dec 18 2021 07:25 AM
@Hans Vogelaar ...thanks ,then which formula to use, could you please help with that!
Dec 18 2021 07:46 AM
If you look at the chart, you'll see that the data in each series don't follow any particular trend - they don't go up or down consistently, nor is there a clear seasonal trend. It all looks rather random. So no method of forecasting will provide a meaningful result.