- All Exams Instant Download
Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below: Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the...
Which of the following is the mean?
Refer to the exhibit. A data analyst needs to calculate the mean for Q1 sales using the data set below: Which of the following is the mean?A . $2,466.18B . $2,667.60C . $3,082.72D . $12,330.88View AnswerAnswer: C Explanation: The mean is the average of all the values in a data...
Which of the following is used for calculations and pivot tables?
Which of the following is used for calculations and pivot tables?A . IBM SPSSB . SASC . Microsoft ExcelD . DomoView AnswerAnswer: C Explanation: This is because Microsoft Excel is a type of software application that allows users to create, edit, and analyze data in spreadsheets, which are composed of...
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 data manipulation techniques should the analyst perform?
A data analyst must separate the column shown below into multiple columns for each component of the name: Which of the following data manipulation techniques should the analyst perform?A . ImputingB . TransposingC . ParsingD . ConcatenatingView AnswerAnswer: C Explanation: Parsing is the data manipulation technique that should be used...
Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?
Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?A . Simple randomB . ClusterC . SystematicD . StratifiedView AnswerAnswer: D Explanation: This is because stratified is a type of sampling in which elements...
Which of the following types of charts should be considered?
A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts...
Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?
Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?A . Data encryption.B . Data transmission.C . Data protection.D . Data masking.View AnswerAnswer: A Explanation: Data encryption can be used to...
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...
