I have reached the last section of Unit 7, I was been asked to download a spreadsheet for the calculation of the result of each strategic option of Telford. But none of my answer was correct. I do not understand it as each question only has one item needs to be adjusted and it should be quite easy to get.
Now I am stuck, is there anyone has came to this question already? Need help to understand where has gone wrong.
Appreciated if anyone can help!!
I was in the same situation, but managed to go through Unit 7 just yesterday.
You are supposed to find only the incremental profit on each strategic option given. and don't forget to treat each strategic decision as independent of the others.
I have managed to solve them. Think we misread the requirement of the question as it is only asking for the impact on net profit and not the new net profit figure.
So for each strategic option, how much would the current net profit increase or decrease by.
Hope this helps.
Has anyone been able to complete the end of unit assessment in Unit 7 Data?
It tells you to perform regression analysis using the "data analysis" tool on the excel spreadsheet - but I cant see where in excel you can find the data analysis function.
I am in the same boat as you. I am finding it very strange.
I am seeking assistance too.
I was misreading the question too! Thanks for your help.