A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?
Answer : D
The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:
Answer : C
Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)
Answer : AF
Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?
Answer : D
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?
Answer : C
Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)
Answer : AC
Which of the following will MOST likely be streamed live?
Answer : D
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
Answer : A
Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:
Using this information, which of the following students had the BEST score?
Answer : B
Given the data below:
In which of the following file formats is the data presented?
Answer : B
A commissions analyst has just completed second-quarter payout statements. The analyst created a dashboard to distribute the statements as quickly as possible. Which of the following will ensure only designated employees can view this information?
Answer : B
The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company’s year-over-year Q2 2020 sales. Which of the following reports should the analyst compare?
Answer : B
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 should be considered?
Answer : C
An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?
Answer : A
A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?
Answer : C