Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Data analytics
| Question | Answer |
|---|---|
| Which statement is true concerning data analytics? | Predictive analytics uses simulation models and forecasting to suggest what could happen. |
| A data analyst uses Excel and Tableau to identify patterns and correlations in a dataset to draw conclusions. Which phase of the analytic process is the analyst currently working on? | analyzing the data |
| Refer to the exhibit. A data analyst wants to create a formula in Microsoft Excel that will automatically calculate the net revenue from the sales of dining sets. Which formula inserted in cell F2 will accomplish this? | =(C2*(B2-D2)*E2) |
| Which type of variable is used for qualitative values such as gender or eye color? | nominal |
| What are three resources provided by the Kaggle web site? (Choose three.) | • publicly available datasets • code • community competitions |
| Which statement is true about the ELT and ETL process? | In the ELT process, the transform step occurs on the stored data as it is used |
| An analyst in an online order company is researching products that online customers spend the most time browsing for on the website but do not buy. The result of the analysis will enable the company to.. What relevant data is required to do the research? | streaming customer-viewing data |
| Which two tasks are performed as part of the transform step of the ETL data process? (Choose two.) | • removing the blank records • standardizing formats such as date, time, and location |
| Which option in Microsoft Excel represents a formula with an absolute reference? | =($A$1-$B$1)) |
| A data analyst needs to organize sales data for analysis. Which Excel function can order the data by date sold, with the most recent sales listed first? | Sort & Filter |
| How can data analysts use the Conditional Formatting tool in Excel to aid in data analysis of bike sales records? | to highlight values in the revenue column that are above average |
| A learner is analyzing a large volume of data in a Microsoft Excel spreadsheet and wishes to find duplicate data values. The data has been organized in a table where each row has different but... Which Microsoft Excel function can be used to do this? | VLOOKUP |
| A data analyst wants to compare the average life expectancy and GDP for forty countries. Which type of visual representation would best suit this task? | scatter plots |
| What is a statistical analysis result that a descriptive statistical analysis will not provide? | predictions made about other data sets that are not in the population |
Created by:
user-1998864