Forums › Ask ACCA Tutor Forums › ACCA Ethics and Professional Skills Module › Ethics and Professional skills module unit 7
 This topic has 109 replies, 41 voices, and was last updated 2 months ago by Kim Smith.

AuthorPosts

May 17, 2020 at 9:14 am #571095JP1982
 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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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 (1619) – 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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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: 46
 Replies: 87
 ☆☆
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: 5
 Replies: 24
 ☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
@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: 4
 Replies: 30
 ☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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: 4
 Replies: 30
 ☆
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: 4
 Replies: 30
 ☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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: 4
 Replies: 30
 ☆
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 SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
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!!!
February 5, 2021 at 1:04 pm #609313valentinoh Topics: 1
 Replies: 1
 ☆
Good day,
Can someone please help me out. I am struggling to find correct answers for question 2, 3 and 5 of unit 7 of Ethics module. I have followed through all Kim’s notes, plugged in figures in to the formulas and even used Excel Spreadsheet for accuracy of my calculation but I am still not winning. Kindly please assist asap. I do understand the fundamental principle, but I am just not sure why I am not getting the correct answers!February 5, 2021 at 2:16 pm #609325Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
@valentinoh – I can’t suggest anything else short of giving you the answers – which would be unethical of me(!) If you have read through all my tips on this thread (not just those on this page) it is really not as difficult as it may look. When you say “even used excel spreadsheet” I would expect you to have downloaded the one provided. Then if you have worked through the illustration earlier in the module, you should be able to interpret the coefficients.
February 21, 2021 at 9:30 am #611172mbulukimanake Topics: 0
 Replies: 1
 ☆
I need help with the Predictive analytics questions
been failing since morning 
AuthorPosts
 You must be logged in to reply to this topic.