Page: 1
/ 52
Total 259 questions
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.18
- B. $2,667.60
- C. $3,082.72
- D. $12,330.88
Answer : 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. A workbook with multiple tabs for each region
- B. A daily email with snapshots of regional summaries
- C. A static report with a different page for every filtered view
- D. A dashboard with filters at the top that the user can toggle
Answer : D
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?
- A. Recode the variables.
- B. Calculate the percentiles of the variables.
- C. Calculate the standard deviations of the variables.
- D. Normalize the variables.
Answer : D
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)
- A. Data identification
- B. Data processing
- C. Data reporting
- D. Data encryption
- E. Data masking
- F. Fata removal
Answer : DE
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 formatting
- B. Grouping
- C. Filtering
- D. Sorting
Answer : D
31 days access 