- All Exams Instant Download
Which of the following functions will allow the data analyst to organize the table in this manner?
A data analyst has been asked to organize the table below in the following ways: By sales from high to low - By state in alphabetic order - Which of the following functions will allow the data analyst to organize the table in this manner?A . Conditional formattingB . GroupingC...
Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?
Refer to the exhibit. A customer list from a financial services company is shown below: A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income. Which of the...
Which of the following would be considered non-personally identifiable information?
Which of the following would be considered non-personally identifiable information? A. Cell phone device name B. Customer’s name C. Government ID number D. Telephone numberView AnswerAnswer: A Explanation: Non-personally identifiable information (non-PII) is any data that cannot be used to identify, contact, or locate a specific individual, either alone or...
Which of the following steps should be taken to ensure data consistency?
While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?A . Delete any of the responses that do not have “January” written out.B . Replace any of the...
Which of the following data manipulation techniques is an example of a logical function?
Which of the following data manipulation techniques is an example of a logical function?A . WHEREB . AGGREGATEC . BOOLEAND . IFView AnswerAnswer: D Explanation: This is because an IF function is a type of logical function that returns a value based on a condition or a set of conditions....
Which of the following is the BEST way to meet this stakeholder requirement?
A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?...
Which of the following must be done to the Genre column before this task can be completed?
A data analyst for a media company needs to determine the most popular movie genre. Given the table below: Which of the following must be done to the Genre column before this task can be completed?A . AppendB . MergeC . ConcatenateD . DelimitView AnswerAnswer: D Explanation: Delimiting is the...
Which of the following date parameters should the analyst use?
Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which of the following date parameters should the analyst use?A . 2019 vs. YTD 2020B . Q3 2019 vs....
Which of the following methods would BEST address this issue?
While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?A . Replace missing data.B . Remove duplicate data.C . Replace redundant data.D . Remove invalid data.View AnswerAnswer: A Explanation: This is...
Which of the following would be the BEST technique for the analyst to apply to acquire the data?
An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?A . Web scrapingB . SamplingC . Data wranglingD . ETLView AnswerAnswer:...
