- All Exams Instant Download
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 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 variable name formats would be problematic if used in the majority of data software programs?
Which of the following variable name formats would be problematic if used in the majority of data software programs?A . First_Name_B . FirstNameC . First_NameD . First NameView AnswerAnswer: D Explanation: This is because First Name is a variable name format that would be problematic if used in most of...
What does he have to make sure he checks for in his ELT process?
Jhon is working on an ELT process that sources data from six different source systems. Looking at the source data, he finds that data about the sample people exists in two of six systems. What does he have to make sure he checks for in his ELT process? Choose the...
Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.
Which of the following value is the measure of dispersion "range" between the scores of ten students in a test. The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.A . 90B . 60C . 70D . 80View AnswerAnswer: B Explanation:...
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:...
Which of the following is the FIRST step the analyst should perform with the data?
An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?A . Conduct an exploratory analysis and use descriptive statistics.B . Conduct a trend analysis and use a scatter chart.C . Conduct a link analysis and illustrate the...
Which of the following types of analysis would this practice be considered?
A company’s marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought the product, at what frequency, and at what value. Which of the following types of analysis would this...
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 should be accomplished NEXT after understanding a business requirement for a data analysis report?
Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?A . Rephrase the business requirement.B . Determine the data necessary for the analysis.C . Build a mock dashboard/presentation layout.D . Perform exploratory data analysis.View AnswerAnswer: B Explanation: Exploratory data analysis (EDA) is...
