Ethics and Professional skills module unit 7

Re Abacus – You just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).

I can only reiterate that if you do the calculation in the spreadsheet in such a way that you avoid calculator errors you should get the correct answer. Perhaps try re-working the equivalent numbers in the illustration earlier in the module – just to make sure you’re not making a careless mistake (mismatching the variables and their coefficients or ignoring the negative intercept).

You need to READ through the section “Predictive Analytics” in the unit – in particular the page which shows the summary output of the BBQ sales illustration and the following page which starts “This information can therefore be used to predict future sales …”

You should then apply what you learn to the end-of-unit assessment. Q3 asks you to predict additional profit (= revenue because there is no variable cost). The first page of the unit assessment, before you download the spreadsheet, tells you what the variables are.

tanzeelrehman – please reflect on the ethics and professionalism of your action

I suggest you read through MY posts – I don’t have the xls to hand but I don’t think you have correctly identified the X1, X2, etc values in the xls. I’m pretty sure there should be a *1 or *0 in the calculation. If you download the xls and do the calculation in the xls there really is little scope to get this wrong. Just make sure you are multiplying out the correct values!

Hi

Please you can you explain the link between the following:

Coefficients
Intercept -63964..57622
X1 234.9566375
X2 0.406247082

and so on
many thanks

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.

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.

To solve the abacus problem you just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).

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”

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 15000000

Min Total 60000000

Then I added the little parts above the break line and was getting these figures

Homeware 2500000
Grocery 500000

So 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

In $m means the # of millions – i.e. the number before the 000000.

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.