Trend analysis when trend is NOT constant

Oniyama100
Registered Posts: 7 New contributor 🐸
Hi there, I am studying trend analysis for Cash and Treasury Management, AAT Level 4, (although trend analysis features throughout the professional qualification).
I have come across a question in the Kaplan text regarding the extrapolation of a trend when the trend is NOT constant.
The way to calculate this is given as:
Average trend = (last known trend - first known trend) / (number of sets of data -1)
Can anyone tell me why there is a -1 at the end here?
I have attached the picture of the question containing the data set used, this covers 12 months, so the calculation gives 12-1, giving a data set of 11.
I am confused, I hope someone knows why this is.
I appreciate ANY help possible.
Regards
I have come across a question in the Kaplan text regarding the extrapolation of a trend when the trend is NOT constant.
The way to calculate this is given as:
Average trend = (last known trend - first known trend) / (number of sets of data -1)
Can anyone tell me why there is a -1 at the end here?
I have attached the picture of the question containing the data set used, this covers 12 months, so the calculation gives 12-1, giving a data set of 11.
I am confused, I hope someone knows why this is.
I appreciate ANY help possible.
Regards
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 18.9K For AAT students
- 234 NEW! Qualifications 2022
- 133 General Qualifications 2022 discussion
- 7 AAT Level 2 Certificate in Accounting
- 31 AAT Level 3 Diploma in Accounting
- 55 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 91 Software
- 272 Tax
- 135 Bookkeeping
- 7.3K General accounting discussion
- 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
- 3.8K For everyone
- 39 AAT news and announcements
- 352 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 586 Job postings
- 17 Who can benefit from AAT?
- 36 Where can AAT take me?
- 44 Getting started with AAT
- 26 Finding an AAT training provider
- 47 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 65 AAT membership