Data Forecasting I need help with Excel Data Forecasting.  I need to forecast the months for the location areas listed in yellow using the 2019, 2020, and

Data Forecasting I need help with Excel Data Forecasting. 

I need to forecast the months for the location areas listed in yellow using the 2019, 2020, and 2021 historical data. Using the census location to project 2022 for each month listed in yellow. Sheet1

Attendance

Month CV DY EA EE GA HK LH LD SA AM

19-Jan 1695 1907 3476 2223 2886 2844 0 1854 1442 0

Y 19-Feb 1570 1796 3263 2023 2573 2544 0 1720 1334 0

E 19-Mar 1731 1984 3800 2348 3025 3005 0 1958 1446 0

A 19-Apr 1617 1950 3628 2382 2954 2863 0 1940 1484 0

R 19-May 1806 2104 3944 2201 3109 3174 0 2048 1627 0

19-Jun 1602 1943 3677 2226 2939 2881 0 1902 1475 0 Historical Data for the 2022 projections that are in yellow

2019 19-Jul 1834 2024 3941 2119 3127 3026 0 2033 1598 0

19-Aug 1748 1792 3456 2176 2988 2848 0 1888 1490 0

19-Sep 1737 1924 3223 2198 2847 2884 0 1957 1478 0

19-Oct 2019 2307 3630 2540 3233 3329 0 2329 1773 0

19-Nov 1587 1909 3010 2130 2647 2724 0 1889 1527 0

19-Dec 1560 1902 2783 2108 2674 2819 0 1877 1481 0

0 0

20-Jan 1804 2071 3161 2268 3066 3291 0 2044 1694 0

20-Feb 1657 1900 2854 2088 2840 3084 0 1990 1532 0

20-Mar 927 835 1159 881 1259 1522 0 842 614 0

Y 20-Apr 86 19 29 12 5 14 0 135 0 0

E 20-May 132 47 43 70 1 1 0 156 0 0

A 20-Jun 140 58 94 89 0 2 0 213 8 0

R 20-Jul 134 100 78 122 3 2 0 193 36 0

20-Aug 210 130 69 185 14 3 0 223 47 0 Historical Data for the 2022 projections that are in yellow

2020 20-Sep 248 230 11 200 84 0 19 290 151 0

20-Oct 298 347 31 216 191 66 43 480 215 0

20-Nov 308 288 50 183 176 106 47 459 174 0

20-Dec 306 201 33 81 101 157 52 244 121 0

Month CV DY EA EE GA HK LH LD SA AM SA

21-Jan 74 96 5 14 100 81 17 109 18 2

Y 21-Feb 84 158 30 6 114 85 26 234 64 19

E 21-Mar 149 207 38 10 164 83 56 326 85 43

A 21-Apr 186 263 75 23 309 163 326 417 269 65 I NEED YOUR HELP TO PROJECT THE 2022 ATTENDANCE FOR EACH MONTH AND FOR EACH LOCATION WITH USING THE Historical Data for 2019, 2020, 2021

R 21-May 249 298 149 53 194 304 37 481 459 121

21-Jun 476 422 327 93 118 525 49 640 361 138

2021 21-Jul 643 422 432 141 482 482 56 664 542 164

21-Aug 701 469 481 342 666 864 115 732 614 175

21-Sep 898 542 533 392 569 808 119 857 712 214 65

21-Oct 914 594 634 430 657 960 127 936 812 243 72

21-Nov 942 650 739 492 745 1114 139 1020 908 271 86

21-Dec 984 703 834 580 837 1249 149 1104 978 296 97

Census projection for 2022

LOCATION CV DY EA EE GA HK LH LD SA AM SA

Month

22-Jan 1078 735 889 642 928 1302 165 1142 1012 342 110 Census Projection – Baseline*

22-Feb 1150 862 1002 830 1061 1460 182 1201 1048 389 135 CV

Y 22-Mar 1215 977 1104 1000 1181 1603 197 1254 1081 431 158 DY

E 22-Apr 1287 1104 1217 1188 1314 1761 214 1313 1117 478 183 EA

A 22-May 1357 1227 1326 1370 1443 1914 231 1370 1151 524 207 EE

R 22-Jun 1429 1354 1439 1558 1576 2072 248 1429 1187 571 232 GA

22-Jul 1498 1477 1549 1740 1705 2225 264 1486 1222 616 256 HK

2022 22-Aug 1570 1604 1662 1928 1838 2383 281 1545 1258 663 281 LH

22-Sep 1642 1731 1775 2116 1971 2541 298 1604 1294 710 306 LD

22-Oct 1712 1853 1884 2298 2099 2693 315 1662 1329 756 330 SA

22-Nov 1784 1980 1997 2486 2232 2851 332 1721 1365 803 355 AM

22-Dec 1854 2103 2106 2668 2361 3004 348 1778 1400 848 379 SA

I have done a few projection using Forcast.linear that is listed in yellow. I believe there is a better way to do these projections using the day location census Census projection for 2022

Using the census to project the numbers in yellow.

Submit a Comment

Open chat