DEMAND FOR FRUITS
Actual PROJECTED
YEAR Values (Y) X X² X⁴ XY X²Y VALUES (YC)
2016 209 -4 16 256 -836 3344
2017 229 -2 4 16 -458 916
2018 239 0 0 0 0 0
2019 249 2 4 16 498 996
2020 259 4 16 256 1036 4144
∑= 1185 40 544 240 9400
YC= a + bX + cX²
a= = =239.857
Where ∑x⁴∑y-∑x²(∑x²y) 544(1,185)-40(9,400)
n(∑x⁴)-(∑x²)² 5(544)-(40)²
b= = =6
∑xy 240
∑x² 40
c= = = 0.357142857
n(∑x²y)-∑x²(∑xy) 5(9,400)-40(1,185)
n(∑x⁴)-(∑x²)² 5(544)-(40)²
+ 6X + 0.35714285X²
Therefore
YC = 239.857
TOTAL PROJECTED DEMAND FOR FRUITS
2021 6 36 288.714
2022 8 64 310.714
2023 10 100 335.571
2024 12 144 363.286
2025 14 196 393.857
DEMAND FOR VEGETABLES
Actual PROJECTED
YEAR Values (Y) X X² X⁴ XY X²Y VALUES (YC)
2016 245 -4 16 256 -980 3920
2017 260 -2 4 16 -520 1040
2018 275 0 0 0 0 0
2019 290 2 4 16 580 1160
2020 305 4 16 256 1220 4880
∑= 1375 40 544 300 11000
YC= a + bX + cX²
Where a= ∑x⁴∑y-∑x²(∑x²y) = 544(1,375)-40(11,000) =275
n(∑x⁴)-(∑x²)² 5(544)-(40)²
b= ∑xy = 300 = 7.5
∑x² 40
c= n(∑x²y)-∑x²(∑xy) = 5(11,000)-40(1,375) = 0.0
n(∑x⁴)-(∑x²)² 5(544)-(40)²
Therefore
YC = 275 + 7.5X + 0X²
TOTAL PROJECTED DEMAND FOR VEGETABLES
2021 6 36 320.000
2022 8 64 335.000
2023 10 100 350.000
2024 12 144 365.000
2025 14 196 380.000
DEMAND FOR FISH
Actual PROJECTED
YEAR Values (Y) X X² X⁴ XY X²Y VALUES (YC)
2016 355 -4 16 256 -1420 5680
2017 370 -2 4 16 -740 1480
2018 385 0 0 0 0 0
2019 400 2 4 16 800 1600
2020 415 4 16 256 1660 6640
∑= 1,925 40 544 300 15,400
YC= a + bX + cX²
Where a= ∑x⁴∑y-∑x²(∑x²y) = 544(1,925)-40(15,400) = 385
n(∑x⁴)-(∑x²)² 5(544)-(40)²
b= ∑xy = 300.00 = 7.5
∑x² 40
c= n(∑x²y)-∑x²(∑xy) = 5(15,400)-40(1,925) =0
n(∑x⁴)-(∑x²)² 5(544)-(40)²
Therefore
YC = 385 + 7.5X + -0X²
TOTAL PROJECTED DEMAND FOR FISH
2021 6 36 430.000
2022 8 64 445.000
2023 10 100 460.000
2024 12 144 475.000
2025 14 196 490.000
-5
1120
-0.004464
DEMAND FOR MEAT
Actual PROJECTED
YEAR Values (Y) X X² X⁴ XY X²Y VALUES (YC)
2016 455 -4 16 256 -1820 7280
2017 470 -2 4 16 -940 1880
2018 485 0 0 0 0 0
2019 500 2 4 16 1000 2000
2020 515 4 16 256 2060 8240
∑= 2425 40 544 300 19400
YC= a + bX + cX²
Where a= ∑x⁴∑y-∑x²(∑x²y) = 544(2,425)-40(19,400) =485
n(∑x⁴)-(∑x²)² 5(544)-(40)²
b= ∑xy = 300 = 7.5
∑x² 40
c= n(∑x²y)-∑x²(∑xy) = 5(19,400)-40(2,425) = 0
n(∑x⁴)-(∑x²)² 5(544)-(40)²
Therefore
YC = 485 + 7.5X + 0X²
TOTAL PROJECTED DEMAND FOR MEAT
2021 6 36 530.000
2022 8 64 545.000
2023 10 100 560.000
2024 12 144 575.000
2025 14 196 590.000
DEMAND FOR MEAT
Actual PROJECTED
YEAR Values (Y) X X² X⁴ XY X²Y VALUES (YC)
2016 512 -4 16 256 -2048 8192
2017 552 -2 4 16 -1104 2208
2018 592 0 0 0 0 0
2019 632 2 4 16 1264 2528
2020 672 4 16 256 2688 10752
∑= 2960 40 544 800 23680
YC= a + bX + cX²
Where a= ∑x⁴∑y-∑x²(∑x²y) = 544(2,960)-40(23680) =592
n(∑x⁴)-(∑x²)² 5(544)-(40)²
b= ∑xy = 800 = 20
∑x² 40
c= n(∑x²y)-∑x²(∑xy) = 5(23680)-40(2,960) =0
n(∑x⁴)-(∑x²)² 5(544)-(40)²
Therefore
YC = 485 + 20X + 0X²
TOTAL PROJECTED DEMAND FOR MEAT
2021 6 36 712.000
2022 8 64 752.000
2023 10 100 792.000
2024 12 144 832.000
2025 14 196 872.000
2960 23680 544 40
a 544 40 5
1610240 947200 663040 2720 1600 1120 592
b 800 40 20
c 23680 2960 544 40
5 40 5
118400 118400 2720 1600 1120 0