Each embedded worksheet illustrates one or more issues/problems in data represen
ID: 3744985 • Letter: E
Question
Each embedded worksheet illustrates one or more issues/problems in data representation. Closely examine the contents of each worksheet. Note that the issues/problems may be different in each worksheet.
Answer the following questions separately for both worksheets (4 answers in total)
Are all of the displayed values correct?
If not, why not?
Value in Column A Converted to Numeric with Function Value) 1234567890.1234600000 10000000000.0000000000 100000000000000000000.0000000000 1.000000000000000000000000000000 Text Value 1234567890.1 23456789 9999999999.999999999 99999999999999999999.999999999 1.0000000000000000000000000009Explanation / Answer
The first and last Row Conversion results are wrong and the second and third row conversion is right.
The correct result for 1st row will be 1234567890.12345 and last row will be 1.
In the case of first row the result is obtained by taking the first 5 digits after decimal point without rounding off.
In the case of second row the result is correct as the number is rounded off.
in the third scenario result is correct as same as second the number gets rounded off to next significant digits.
In the fourth row the result is incorrect as the 9 comes after many digits after decimal point and the result is treated as 1
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.