Problem 44545. "Percentages may not total 100 due to rounding"

Created by David Verrelli

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:rPr><w:b/></w:rPr><w:t>Percentages</w:t></w:r><w:r><w:t> are commonly</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:b/></w:rPr><w:t>rounded</w:t></w:r><w:r><w:t> when presented in tables. As a result, the sum of the individual numbers does not always add up to 100%. A warning is therefore sometimes appended to such tables, along the lines:</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:i/></w:rPr><w:t>\"Percentages may not total 100 due to rounding\"</w:t></w:r><w:r><w:t>.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>EXAMPLE 1: A survey of eleven people for their opinion on a new policy found five to be in favour, five opposed, and one undecided/neutral. Percentage-wise this becomes</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[In favour: 45% (5 of 11)\nUndecided/neutral: 9% (1 of 11) \nOpposed: 45% (5 of 11)]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>The total of these is 99%, rather than the expected 100%. Despite this conflict, in this example</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:b/></w:rPr><w:t>all of the individual numbers have been correctly entered</w:t></w:r><w:r><w:t>.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>EXAMPLE 2: In the same report, a survey of a further ten people on a different policy found four to be in favour, four opposed, and two undecided/neutral. Suppose the data were presented in the following table</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[In favour: 45%\nUndecided/neutral: 20%\nOpposed: 45%]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Given the background information, we would quickly recognise this as inconsistent, with a spurious total of 110%, rather than the expected 100%. In fact, we would probably guess that a copy-and-paste mistake had occurred. However, it is important to realise that even if we looked at this table alone, in isolation, without any background knowledge of the survey size or the true number of responses in any category, just by knowing that there are only three categories we can firmly conclude that in this example</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:b/></w:rPr><w:t>one or more of the individual numbers must have been entered incorrectly</w:t></w:r><w:r><w:t>.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>YOUR JOB: Given a list (vector) of integer percentages, determine whether among the individual values at least one of them</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:i/></w:rPr><w:t>must</w:t></w:r><w:r><w:t> have been incorrectly entered (return</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:rFonts w:cs=\"monospace\"/></w:rPr><w:t>true</w:t></w:r><w:r><w:t>), as in Example 2, or whether there might not be any incorrect entries (return</w:t></w:r><w:r><w:t> </w:t></w:r><w:r><w:rPr><w:rFonts w:cs=\"monospace\"/></w:rPr><w:t>false</w:t></w:r><w:r><w:t>), as in Example 1.</w:t></w:r></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

Percentages are commonly rounded when presented in tables. As a result, the sum of the individual numbers does not always add up to 100%. A warning is therefore sometimes appended to such tables, along the lines: "Percentages may not total 100 due to rounding".EXAMPLE 1:
A survey of eleven people for their opinion on a new policy found five to be in favour, five opposed, and one undecided/neutral. Percentage-wise this becomes<pre class="language-matlab">In favour: 45% (5 of 11)
Undecided/neutral: 9% (1 of 11) 
Opposed: 45% (5 of 11) 
</pre>The total of these is 99%, rather than the expected 100%. Despite this conflict, in this example all of the individual numbers have been correctly entered.EXAMPLE 2:
In the same report, a survey of a further ten people on a different policy found four to be in favour, four opposed, and two undecided/neutral. Suppose the data were presented in the following table<pre class="language-matlab">In favour: 45%
Undecided/neutral: 20%
Opposed: 45%
</pre>Given the background information, we would quickly recognise this as inconsistent, with a spurious total of 110%, rather than the expected 100%. In fact, we would probably guess that a copy-and-paste mistake had occurred. However, it is important to realise that even if we looked at this table alone, in isolation, without any background knowledge of the survey size or the true number of responses in any category, just by knowing that there are only three categories we can firmly conclude that in this example one or more of the individual numbers must have been entered incorrectly.YOUR JOB: 
Given a list (vector) of integer percentages, determine whether among the individual values at least one of them must have been incorrectly entered (return <tt>true</tt>), as in Example 2, or whether there might not be any incorrect entries (return <tt>false</tt>), as in Example 1.

*Percentages* are commonly *rounded* when presented in tables.  As a result, the sum of the individual numbers does not always add up to 100%.  A warning is therefore sometimes appended to such tables, along the lines: _"Percentages may not total 100 due to rounding"_.

EXAMPLE 1:
A survey of eleven people for their opinion on a new policy found five to be in favour, five opposed, and one undecided/neutral.  Percentage-wise this becomes

In favour:          45% (5 of 11)
  Undecided/neutral:   9% (1 of 11)  
  Opposed:            45% (5 of 11)

The total of these is 99%, rather than the expected 100%.  Despite this conflict, in this example *all of the individual numbers have been correctly entered*.

EXAMPLE 2:
In the same report, a survey of a further ten people on a different policy found four to be in favour, four opposed, and two undecided/neutral.  Suppose the data were presented in the following table

In favour:          45%
  Undecided/neutral:  20%
  Opposed:            45%

Given the background information, we would quickly recognise this as inconsistent, with a spurious total of 110%, rather than the expected 100%.  In fact, we would probably guess that a copy-and-paste mistake had occurred.  However, it is important to realise that even if we looked at this table alone, in isolation, without any background knowledge of the survey size or the true number of responses in any category, just by knowing that there are only three categories we can firmly conclude that in this example *one or more of the individual numbers must have been entered incorrectly*.

YOUR JOB:  
Given a list (vector) of integer percentages, determine whether among the individual values at least one of them _must_ have been incorrectly entered (return |true|), as in Example 2, or whether there might not be any incorrect entries (return |false|), as in Example 1.

Solve

Solution Stats

15 Solutions
3 Solvers

Last Solution submitted on Oct 25, 2020

Last 200 Solutions

Problem Recent Solvers3

Problem Tags

data entry data quality finite precision misprints precision quality control rounding rounding error

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Problem 44545. "Percentages may not total 100 due to rounding"

Solution Stats

Last 200 Solutions

Problem Recent Solvers3

Suggested Problems

More from this Author32

Problem Tags

Community Treasure Hunt

Problem 44545. "Percentages may not total 100 due to rounding"

Solution Stats

Last 200 Solutions

Problem Recent Solvers3

Suggested Problems

More from this Author32

Problem Tags

Community Treasure Hunt

Players