Given the trend line equation y=a+b(x−2022) with the data:
| Year (x) | 2020 | 2021 | 2022 | 2023 | 2024 |
|---|
| Profit (y) | 2 | 3 | 4 | 5 | 2 |
Let u=x−2022 to simplify calculations.
The equation becomes y=a+bu
Converting x-values to u-values:
When x=2020: u=2020−2022=−2
When x=2021: u=2021−2022=−1
When x=2022: u=2022−2022=0
When x=2023: u=2023−2022=1
When x=2024: u=2024−2022=2
The transformed data:
Number of data points: n=5
∑u=−2+(−1)+0+1+2
∑u=0
uˉ=50=0
∑y=2+3+4+5+2
∑y=16
yˉ=516=3.2
∑u2=(−2)2+(−1)2+02+12+22
∑u2=4+1+0+1+4
∑u2=10
∑uy=(−2)(2)+(−1)(3)+(0)(4)+(1)(5)+(2)(2)
∑uy=−4−3+0+5+4
∑uy=2
Since uˉ=0:
a=yˉ=516
Using the least squares formula:
b=∑u2∑uy
b=102
b=51
ba=51516
ba=516×15
ba=16
Therefore, the value of ba=16