Ethics and Professional skills module unit 7

i tried again i failed

150 15000 30000 3 are the coefficients a, b, c, d to put into the formula. You need to pick the x values from the spreadsheet provided. If you can’t find them – go back to the illustration provided earlier in the unit and read how to interpret the spreadsheet.

You should be putting in a $ amount (not nearest $000) for example.

If you have calculated an amount >$100,000 perhaps you have overlooked the intercept (a negative amount).

If you go back to the illustration you should see exactly how to calculate this. You really should be able to calculate it in the spreadsheet provided.

That’s a relief! Thank you for letting me know!

What would the predicted ticket sales with the following data:

Distance from capital Population Ticket barrier Demographic profile of town Predicted sales
150 15000 30000 3 ???
I am struggling to get the answer,please help sir
This is what i did 150 (63,964.58) -9594686.433
15000 234.9566375 3524349.563
30000 0.406247082 7048699.125
3 1.133622322 1.218741246
Answer i got 978,363.47

Please look at my earlier posts on this thread. You need to correctly identify the intercept value and x1 to x4 in the spreadsheet. If you work through the explanations in the illustration earlier in the unit you should be able to work these Qs out. I think you may be treating the intercept amount which should not be multiplied by anything as x1.

Re the abacus you just need to read very carefully the explanation of values top and bottom.

You have to work properly through the unit before attempting the assessment – see my post January 24, 2020 at 8:08 am on this thread.

From the table of contents (TOC) select 5th box “Types of Analytics”
Use the navigation tool bottom left or otherwise scroll through to the section “Predictive Analytics”. The 2nd slide is called “Regression” – you can skip the bit about how to do the regression in excel (since the spreadsheet is provided for you) but read carefully the page which starts “Undertaking this process with the data above reveals the following output table:”
You can see in the table there is a “coefficients” column with 4 values matching intercept and three variables – X1, X2 and X3.
The next slide shows you the equation that is derived from the output table.

The only difference between how you calculate Y to answer Q1 is that there are 4 variables not 3.

Cell A15 of the spreadsheet says “intercept” – the value is the adjacent cell (B15)
Cell A16 says “X Variable 1” – I shortened this to X1.

I think the underlying problem may be that you do not know/have forgotten what is mean by “regression analysis” which is assumed knowledge. If you look to Chapter 9 section 4 of our MA notes https://opentuition.com/acca/ma/ there is a short explanation of “linear” regression – i.e. with only two variables. There is a lecture to accompany this. A linear equation i.e. of the form “y = a + bx” provides the means by which an accountant can calculate y for any value of x.

Multiple regression is an extension of this – i.e. the equation gives the relationship between multiple variables.

My sincerest apologies for typo – it is Chapter 19 (search work “regression”).

Yes that is exactly what you have to do and you can do it in the spreadsheet if you download it.

That’s great – thank you for letting me know. I hope you have some appreciation of what you achieved. If you’re not really sure there’s a short article here https://www.investopedia.com/ask/answers/060315/what-difference-between-linear-regression-and-multiple-regression.asp

I didn’t want to suggest that you look at this before because I know when faced with a specific problem students want to know the answer to that problem.
The link I’ve given you is to a very useful site if you are not familiar with it. From this article you can dip into more detail on linked topics (highlighted in blue and underlined). I find them relatively easy reading on quite complex topics and the longer articles are often summarised with “key takeaways” at the end.