The following time series data shows the profit (million Rs) of XYZ company from the fiscal year 2015 to 2023: Year Profit (Million Rs) 2015 15 2016…
BBS Business Statistics · 2081 · Solved Question with Answer
The following time series data shows the profit (million Rs) of XYZ company from the fiscal year 2015 to 2023:
| Year | Profit (Million Rs) |
| 2015 | 15 |
| 2016 | 18 |
| 2017 | 20 |
| 2018 | 22 |
| 2019 | 25 |
| 2020 | 23 |
| 2021 | 27 |
| 2022 | 32 |
| 2023 | 30 |
a. Fit a straight line trend to these data.
b. Calculate the trend values and short term fluctuations.
c. Plot the actual data as well as the trend values on graph paper.
d. Estimate the profit for 2024.
e. What is the monthly increment of the profit?