• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Assignment X3 - Pie chart in solutions

J

JT5870

Made first post
Hello,

In the solutions spreadsheet the percentages in the pie chart do not sum to 100%. It appears this is because the percentages have been calculated from the monetary tax amounts before creating the pie chart.

In my solution I created the pie chart directly from the monetary tax amounts and so Excel has automatically rounded up the highest percentage so that they cumulatively sum to 100%.

Would I lose marks for my approach or when creating a pie chart should we always calculate the percentages first before creating a pie chart?

Thank you in advance for your help.
 
Hi

I think that either approaches are fine here. Rounding means that three of the segments in the solution have 0.33 after the value, and this gives the 'missing' 1%. If in any doubt a comment can be added in the audit trail/summary explaining this. I would take care though, especially if the rounding make a difference to the results, for example it could change one category to be the 'highest' from being around the same as another (it is essentially rounding up which should always be used with care). Calculating the percentages first ensures that you are aware of the true values.

Kind regards
Sarah
 
You must log in or register to reply here.
Back
Top