Forums › Ask ACCA Tutor Forums › ACCA Ethics and Professional Skills Module › Ethics and Professional skills module unit 7
- This topic has 86 replies, 30 voices, and was last updated 3 weeks ago by
arjun585.
- AuthorPosts
- May 17, 2020 at 9:14 am #571095
JP1982
- Topics: 0
- Replies: 2
- ☆
Hi
Please you can you explain the link between the following:
Coefficients
Intercept -63964..57622
X1 234.9566375
X2 0.406247082and so on
many thanksMay 17, 2020 at 9:52 am #571103Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
The BBQ Illustration is in the predictive analytics section of the module – you’re expected to work through the module before attempting the assessment at the end of it. If you do so you should understand the types of variables you might have to deal with and that the multiple regression formula is simply the sum of the coefficients multiplied by the variables.
In principle it is no different to linear regression – which is assumed knowledge of MA – see Chapter 19 of the MA notes https://opentuition.com/acca/ma/ – only multiple regression has more than two variables.
May 17, 2020 at 7:40 pm #571131Daryn
- Topics: 0
- Replies: 2
- ☆
I took these X1,X2 and … variables from the ANOVA summary that is given in the task. There is a table with the intercept and variables coefficient. I did it in the same was as in the example from unit.
in the xls file there is no data about variables.
What other variables should I try? not clear.
May 18, 2020 at 8:02 am #571171Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
I suggest it makes sense for them to be presented in the order indicated on the first slide (before the download spreadsheet slide) which describes the spreadsheet.
June 10, 2020 at 3:57 am #573328bw196502
- Topics: 0
- Replies: 1
- ☆
Hi
SO sorry to disturb you that I used –
Would you please guide me what to do next as really stuck here?I have passed all acca exams except this unit now. Wish someone can help.
Thanks a million.
June 10, 2020 at 7:29 am #573341Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
There are 4 variables – not 3. If you put the values of the variables you are given into a blank column of the spreadsheet (say column J) – matched up against the corresponding rows (16-19) – then multiply out and take account of the intercept you should get the correct answer. Your approach is correct you just have careless errors in it.
July 20, 2020 at 12:50 pm #577452kumbie2019
- Topics: 0
- Replies: 1
- ☆
Please help me on tkumbirai@gmail.com or whatsapp number +26771404392. I am not getting it
July 20, 2020 at 1:43 pm #577471Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
To solve the abacus problem you just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).
August 17, 2020 at 8:43 am #580854calen
- Topics: 0
- Replies: 1
- ☆
I can confirm that this helped me pass the module, thanks for this!
August 18, 2020 at 2:07 pm #581047Vu
- Topics: 45
- Replies: 86
- ☆☆
Here is the hint for the question of predicted sales:
“To get the predicted sale you need to load the Data Analysis Tab if not loaded already and follow the procedure to use the linear regression prediction following the instruction given on the module. You need to understand how to identify the constant and the coefficient and you will get the predicted sale easily. If you are not able please get back”
September 19, 2020 at 2:16 pm #586175Tom85
- Topics: 4
- Replies: 20
- ☆
I went through this with a professional data scientist and got the first two questions wrong.
The reason was because I entered the data to two decimal places. There was nothing to suggest we’d be penalised for this. ACCA are usually very clear when they want it rounded to the nearest dollar so this is disappointing. It is meant to be simulating real life after all.
If you are getting these wrong try answering without decimals.
September 20, 2020 at 6:24 pm #586263kavanaghc
- Topics: 1
- Replies: 1
- ☆
Hi all,
I am loosing the will to live. I am doing Unit 7 – “Types of data visualisation – Composition” In 2017 how much was the total sales in $m (excluding bakery sales)?. Maybe I am just looking at this wrong. I don’t want someone to tell me the answer as that won’t help me, but to see am I actually going mad or just tired. This was my thinking on it.
The departments are stacked – exclude bakery. I was working the basics
Deli 25000000
Homeware 20000000
Grocery 15000000Min Total 60000000
Then I added the little parts above the break line and was getting these figures
Homeware 2500000
Grocery 500000So I put in my answer, including all the zeros, then I thought maybe I have the little extra number wrong so tried a few of them. Then I thought maybe I am just tired so I had a colleague look at it and she got the same numbers I did.
Any help on this would be great as I am cracking up.
Rgds
Caroline
October 2, 2020 at 12:16 am #587177dladyx
- Topics: 0
- Replies: 5
- ☆
Try answering without the zeros. For instance 25 instead of 25000000
October 2, 2020 at 8:18 am #587184Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
In $m means the # of millions – i.e. the number before the 000000.
October 7, 2020 at 2:47 pm #587611thjxxacca
- Topics: 0
- Replies: 1
- ☆
Hi.. I really need help. Im stucked at level 7 of the end of unit assessment, where i had to answer questions relating to the data analysis of the ticket sales and all that. But im totally lost, had no idea where to refer to for the analysing of the data from the spreadsheet. Can anyone guide me along please 🙁
October 7, 2020 at 4:23 pm #587631Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
thjxxacca – I suggest you start at the beginning of this thread reading my posts – I tell you exactly what you are supposed to have done before you tackle the assessment.
October 18, 2020 at 7:16 am #589649kjayale
- Topics: 0
- Replies: 3
- ☆
Can someone help me to advise on Module 7 Q2? I am so desperate to complete the Professional Ethics. Whole week wasted 🙁
October 18, 2020 at 7:20 am #589650kjayale
- Topics: 0
- Replies: 3
- ☆
I managed to solve the abacus question within 10 minutes but the predicted sales (Q2) and other final questions are disaster..
October 18, 2020 at 8:55 am #589665Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
@kjayale – please spend 5 minutes reading through my posts on this thread – I tell you everything you need to pay attention to, to pass this module.
October 18, 2020 at 11:39 am #589690Spiro
- Topics: 0
- Replies: 17
- ☆
Regarding the 250k investment question. Probably we should first calculate the expected revenues by updating the barrier cost variable value in the equation?
But, what about the next step? Should we deduct from the calculated sales the 250k investment cost to find the profit and to elaborate further, or simply to compare the sales based on 250k and 30k investments variables?October 18, 2020 at 5:16 pm #589736Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
Please read through my posts on this thread – you need to look to the illustration in the module, that I have clearly signposted, to understand what you are trying to achieve in the task.
October 19, 2020 at 9:37 am #590327Spiro
- Topics: 0
- Replies: 17
- ☆
I read several times your posts. What we are looking for is the impact on profits if $250,000 were spent on automated ticket barrier investment.
First calculate the expected sales with change of X Variable 3 to 250K, and then take into account the increase in cost of investment with 220K.
Probably I do not understand properly the question?October 19, 2020 at 9:48 am #590338Spiro
- Topics: 0
- Replies: 17
- ☆
Just to correct the above comment, that the 220K investment cost increase I deduct from the increase of expected sales.
October 19, 2020 at 5:58 pm #590566Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
But have you gone back to the illustration in the module? You don’t seem to understand the point of the formula. As I explain in previous posts increase in revenue is increase in profit because there is no variable/direct cost of sales. It cannot be correct to deduct cost of investment – i.e. CAPITAL cost (which would be asset in SoFP) from revenue in the derivation of profit.
October 20, 2020 at 4:47 am #590673Spiro
- Topics: 0
- Replies: 17
- ☆
Well, I change one of the variables (the investment spend) and predict the new sales using the rest variables values from Q2. Then compare with sales initially calculated with 30k spend. The delta is not accepted as a correct answer. Spent plenty of hours by making various trials but without any result. Even, I’m asking myself, are unit 7 assessment Q2 and Q3 related?
October 21, 2020 at 8:47 am #590945Kim Smith
Keymaster- Topics: 39
- Replies: 3633
- ☆☆☆☆☆
No the questions are independent of each other.
December 26, 2020 at 1:45 pm #600908arjun585
- Topics: 4
- Replies: 4
- ☆
Hi,
I used the formula Y = deleted
I got the following :DELETED
This is the correct answer!!!
- AuthorPosts
- You must be logged in to reply to this topic.