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?

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 Value = 10 Value in Column B Rounded with function ROUNDDOWN() 10 Difference (Column B minus Column C) 100 10.0 9.9 99

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Book1 - Excel X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ACROBAT DISHEND... D24 A C F Value in Column B Rounded

Values in 4th column (Difference (Column B minus Column C) ) are wrong.

for example see row 5, 9.7-9 = 0.7 that is a terminating decimal number but in question's picture it is shown as repeating decimal number.

Even if you increase it's precision only zeros will be padded to the right.

I have highlighted the cells where values are wrong corresponding to your picture.

Add a comment
Know the answer?
Add Answer to:
Each embedded worksheet illustrates one or more issues/problems in data representation. Closely examine the contents of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • One of the more interesting applications of the x test is to examine issues of fairness...

    One of the more interesting applications of the x test is to examine issues of fairness and cheating in games of chance. Since such games usually involve wagering, there is an incentive for people to try to rig the games, and allegations of missing cards, "loaded" dice, and "sticky" roulette wheels are all too common. Take the example of dice. Most dice used in wagering have six sides, with each side having a value of one, two, three, four, five,...

  • Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales...

    Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....

  • 18.1 Lab Lesson 11 (Part 1 of 1) Part of lab lesson 11 There in one...

    18.1 Lab Lesson 11 (Part 1 of 1) Part of lab lesson 11 There in one part to lab lesson 11. The entire lab will be worth 100 points. Lab lesson 11 part 1 is worth 100 points For part 1 you will have 80 points if you enter the program and successfully run the program tests. An additional 20 points will be based on the style and formatting of your C++ code. Style points The 20 points for coding...

  • the picture above is the one you are supposed to use for the MATlab code please...

    the picture above is the one you are supposed to use for the MATlab code please help Problems. Grayscale images are composed of a 2D matrix of light intensities from O (Black) to 255 (White). In this lab you will be using grayscale images and do 2D-array operations along with loops and iflelse branches. 1. We can regard 2D grayscale images as 2D arrays. Now load the provided image of scientists at the Solvay Conference in 1927 using the imread)...

  • CMPS 12B Introduction to Data Structures Programming Assignment 2 In this project, you will write...

    can i get some help with this program CMPS 12B Introduction to Data Structures Programming Assignment 2 In this project, you will write a Java program that uses recursion to find all solutions to the n-Queens problem, for 1 Sns 15. (Students who took CMPS 12A from me worked on an iterative, non-recursive approach to this same problem. You can see it at https://classes.soe.ucsc.edu/cmps012a/Spring l8/pa5.pdf.) Begin by reading the Wikipcdia article on the Eight Queens puzzle at: http://en.wikipedia.org/wiki/Eight queens_puzzle In...

  • 10. Write a one-page summary of the attached paper? INTRODUCTION Many problems can develop in activated...

    10. Write a one-page summary of the attached paper? INTRODUCTION Many problems can develop in activated sludge operation that adversely affect effluent quality with origins in the engineering, hydraulic and microbiological components of the process. The real "heart" of the activated sludge system is the development and maintenance of a mixed microbial culture (activated sludge) that treats wastewater and which can be managed. One definition of a wastewater treatment plant operator is a "bug farmer", one who controls the aeration...

  • i need help with a mips program to to covert roman numerals to real numbers Lab 4: Roman Numeral Conversion Part A: Due...

    i need help with a mips program to to covert roman numerals to real numbers Lab 4: Roman Numeral Conversion Part A: Due Sunday, 19 May 2019, 11:59 PM Due Friday, 24 May 2019, 11:59 PM Part B: Minimum Submission Requirements Ensure that your Lab4 folder contains the following files (note the capitalization convention): o Diagram.pdf o Lab4. asm O README.txt Commit and push your repository Lab Objective In this lab, you will develop a more detailed understanding of how...

  • Principles of Inorganic Chemistry! Week 5 Effect of Temperature on Solubility of a Salt In this experiment, you w...

    Principles of Inorganic Chemistry! Week 5 Effect of Temperature on Solubility of a Salt In this experiment, you will study the effect of changing temperature on the amount of solute that will dissolve in a given amount of water. Water solubility is an important physical property in chemistry, and is often expressed as the mass of solute that dissolves in 100 g of water at a certain temperature. In this experiment, you will completely dissolve different quantities of potassium nitrate,...

  • You need not run Python programs on a computer in solving the following problems. Place your...

    You need not run Python programs on a computer in solving the following problems. Place your answers into separate "text" files using the names indicated on each problem. Please create your text files using the same text editor that you use for your .py files. Answer submitted in another file format such as .doc, .pages, .rtf, or.pdf will lose least one point per problem! [1] 3 points Use file math.txt What is the precise output from the following code? bar...

  • import java.util.Arrays; import java.util.Random; import java.util.Scanner; /** * TODO Write a summary of the role of...

    import java.util.Arrays; import java.util.Random; import java.util.Scanner; /** * TODO Write a summary of the role of this class in the * MasterMind program. * * @author TODO add your name here */ public class MasterMind { /** * Prompts the user for a value by displaying prompt. * Note: This method should not add a new line to the output of prompt. * * After prompting the user, the method will consume an entire * line of input while reading...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT