Index numbers
phunkyphantom22
Registered Posts: 166 Dedicated contributor 🦉
From my U7 practice paper  task is to use trend data calculated in previous task and index numbers given to index figures for the next quarter.
I've been given a list of quarters and their index numbers and then 2 blank columns headed 'unindexed trend' and 'indexed trend'.
Presumably, I fill in 'unindexed trend' with the trend data from the previous task.
Then what?! How do I calculated the indexed trend?
And how do I get the next year Q1 figure when my moving average trends only got me to Q2 of the previous year?!
I've been given a list of quarters and their index numbers and then 2 blank columns headed 'unindexed trend' and 'indexed trend'.
Presumably, I fill in 'unindexed trend' with the trend data from the previous task.
Then what?! How do I calculated the indexed trend?
And how do I get the next year Q1 figure when my moving average trends only got me to Q2 of the previous year?!
0
Comments

Can anyone help please? I have my test this week and am struggling with this  much appreciated! :)0

Please can someone help me  my test is tomorrow morning and I still don't understand this..... thanks! :)0

I've quoted youFrom my U7 practice paper  task is to use trend data calculated in previous task and index numbers given to index figures for the next quarter.
I've been given a list of quarters and their index numbers and then 2 blank columns headed 'unindexed trend' and 'indexed trend'.
Presumably, I fill in 'unindexed trend' with the trend data from the previous task.
Then what?! How do I calculated the indexed trend?
And how do I get the next year Q1 figure when my moving average trends only got me to Q2 of the previous year?!
I'm sorry, I don't understand your questionSandy
sandy@sandyhood.com
www.sandyhood.com0 
Hi Sandy,
The task is asking me to calculate the unindexed trend and the indexed trend. I have been give a list of months and their indexes, then I have to used the trend figures calculated in the previous task to calculate the unindexed and indexed trends.
I don't really understand the question and cannot find any examples in my books.
Also, I am meant to give the indexed trend for Q1 07 but when I calculate the trend figures in the previous tasks using 4 point moving averages, the last centred average I got to was Q2 06  how on earth do I continue it to get to Q1 07?0 
Index numbers
Which U7 practice paper are you working from?0 
I've not got the front of it to check, sorry!
Any ideas on what to do? Really stuck :(0 
Using a trend and projecting that trend into the future appears on a few exams.
Often you find that the trend rises by the same amount each quarter, and assume this will continue so you add the quarterly increase.
Sometimes you can't see an obvious figure, so text books recommend finding the average rate of growth and using that.
Hopefully that enables you to extrapolate your unindexed trend into the future.
Once you've done that, take each value and multiply it by the index for that quarter to produce an indexed trend.
Without seeing your question I have had to have a bit of a shot in the dark, but the style of question sounds reasonably common and I hope what I've written helps.Sandy
sandy@sandyhood.com
www.sandyhood.com0 
I've been revising all night and with that and the help of you guys, I think I've cracked it! Thanks v much for all your help, much appreciated! :)0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 305 NEW! Qualifications 2022
 157 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 79 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 272 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 198 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 581 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership