Data Forecasting

profile[email protected]
Book3Test.xlsx
Home>Mathematics homework help>Statistics homework help>Data Forecasting

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.