Forums › ACCA Forums › ACCA MA Management Accounting Forums › Help with Correlation question!
- This topic has 5 replies, 2 voices, and was last updated 14 years ago by Anonymous.
- AuthorPosts
- October 11, 2010 at 10:12 pm #45519
Q: Regression analysis was used to find the equation Y=300 – 4.7X, where X is the time(in quarters) and Y is sales level in thousands of units. Given that X = 0 represents 20X0 quarter 1 what are the forecast sales levels for 20X5 quarter 4? – this is a regression lines and time series question…i need help with finding X at 20X5 quarter 4 please
October 12, 2010 at 2:11 pm #69250AnonymousInactive- Topics: 0
- Replies: 63
- ☆☆
They say that X=0 for 20X0 quarter 1,so X=1 for 20X0 quarter 2,X=2 for 20X0 quarter 3,X=3 for 20X0 quarter 4 and so on,then for 20X1 quarter 4,X=7,for 20X2 quarter 4,X=11,for 20X3 quarter 4,X=15,for 20X4 quarter 4,X=19,for 20X5 quarter 4,X=23
October 12, 2010 at 10:07 pm #69251okay you lost me a bit…. how does X=7 in 20X1 quarter 4?….. is it that 20X1 quarter 1 begins with X being equal to 4 and then, 5 , 6 ,7, then 20X2 quarter 1 also begins with X=7 , then 8,9,10?…..a quarter is 4 parts obviously…..but i’m confused how you get your numbering
October 13, 2010 at 7:35 am #69252AnonymousInactive- Topics: 0
- Replies: 63
- ☆☆
Yes 20X1 quarter 1 X is =4,20X2 quarter 1 X is 8,not 7,you try and slowly go until 20X5 quarter 4
October 13, 2010 at 7:55 am #69253I worked it out now! Thanks for your help mate, really appreciate it, and good luck to you!
October 13, 2010 at 10:16 am #69254AnonymousInactive- Topics: 0
- Replies: 63
- ☆☆
You are welcome 🙂 good luck to you too
- AuthorPosts
- You must be logged in to reply to this topic.