- All Exams Instant Download
Which one of the following is a measure of dispersion?
Which one of the following is a measure of dispersion?A . Variance.B . Mode.C . Median.D . Mean.View AnswerAnswer: A
Which of the following sampling methods would MOST likely result in a representative sample?
A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?A . A stratified phone survey of 100 people that is conducted between 2:00...
Which of the following is the correct data type for text?
Which of the following is the correct data type for text?A . BooleanB . StringC . IntegerD . FloatView AnswerAnswer: B Explanation: A string is a data type that represents a sequence of characters, such as text, symbols, numbers, or punctuation marks. Strings are enclosed in quotation marks, such as...
Which of the following is a process that is used during data integration to collect, blend, and load data?
Which of the following is a process that is used during data integration to collect, blend, and load data?A . MDMB . ETLC . OLTPD . BIView AnswerAnswer: B Explanation: ETL is a process that is used during data integration to collect, blend, and load data. ETL stands for extract,...
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?...
