What should Andy's null hypothesis be?

Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average. What should Andy's null hypothesis be?A . People who receive electronic coupons spend more on average.B . People who receive electronic coupons spend less...

March 22, 2025 No Comments READ MORE +

Which of the following variable types BEST describes the “Year” column?

Refer to the exhibit. Given the table below: Which of the following variable types BEST describes the “Year” column?A . NumericB . DateC . AlphanumericD . TextView AnswerAnswer: B Explanation: This is because date is a type of variable that represents a specific point or period in time, such as...

March 22, 2025 No Comments READ MORE +

The number of phone calls that the call center receives in a day is an example of:

The number of phone calls that the call center receives in a day is an example of:A . continuous data.B . categorical data.C . ordinal data.D . discrete data.View AnswerAnswer: D Explanation: Discrete data is a type of data that can only take certain values, usually whole numbers or integers....

March 21, 2025 No Comments READ MORE +

Which of the following is the NEXT step the analyst should take in the dashboard creation process?

An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?A . Optimize the dashboard.B . Create subscriptions.C . Get stakeholder approval.D...

March 21, 2025 No Comments READ MORE +

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)A . To improve data acquisitionB . To remember specifics about data fieldsC . To specify user groups for databasesD . To provide continuity through personnel turnoverE . To confine breaches of PHI dataF . To...

March 20, 2025 No Comments READ MORE +

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...

March 20, 2025 No Comments READ MORE +

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,...

March 18, 2025 No Comments READ MORE +

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...

March 16, 2025 No Comments READ MORE +

Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?A . Five rows, eight columnsB . Seven rows, eight columnsC . Eight rows, seven columnsD . Nine rows,...

March 16, 2025 No Comments READ MORE +

Which of the following statistical methods requires two or more categorical variables?

Which of the following statistical methods requires two or more categorical variables?A . Simple linear regressionB . Chi-squared testC . Z-testD . Two-sample t-testView AnswerAnswer: B Explanation: This is because a chi-squared test is a type of statistical method that tests the association or independence between two or more categorical...

March 15, 2025 No Comments READ MORE +