The data provided on the UnitsSold worksheet required some cleaning before it could be analyzed to calculate the estimated annual demand. What text functions did you use to clean the data? Explain how you knew which text functions to use
What will be an ideal response?
The following functions were used to clean the data on the UnitsSold worksheet: CLEAN, TRIM, LEFT, and VALUE. Since the data included various nonprintable characters the CLEAN function had to be used in order to remove them. The data also included spaces before the number of units so the TRIM function was used to remove any excess spaces. The LEFT function was used in order to extract the 2 character unit count from the word "units". Lastly, since the data was a text value the VALUE function had to be used to convert the text to a number in order to be able to calculate the average.
You might also like to view...
In a multiple-document interface (MDI), a JDesktopPane is the parent window and what class is the child window?
a. JChild. b. JInternalFrame. c. JChildWindow. d. JFrame.
What term or terms of a growth function are considered when determining the order of an algorithm?
What will be an ideal response?
Symbols or signs that classify data into three, four, or five categories, based on the values in a range.
What will be an ideal response?
Which of the following is NOT a step that should be taken as part of a ?response policy?
A. ?Secure the area and disconnect devices from the network B. ?Create documentation detailing the scene C. ?Attempt to access files to determine if they are compromised D. ?Protect the chain of custody of evidence