QUESTION: 1

A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

$2,466.18
$2,667.60
$3,082.72
$12,330.88

Answer(s): A

A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?

A workbook with multiple tabs for each region
A daily email with snapshots of regional summaries
A static report with a different page for every filtered view
A dashboard with filters at the top that the user can toggle

Answer(s): D

Reveal Solution Next Question

QUESTION: 3

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 following should the analyst do to the variables to ensure they all have the same weight in the score calculation?