Q&A

A data analyst wants to display the various segments of a country’s energy sources (e.g., oil, coal, gas, solar, wind) contributing to 100% of its energy sources in a visual…

Why is regression analytics used in the inferential and machine learning analyses of big data? It is used to find groups of observations that are similar to each other. It is…

Which type of inferential and machine learning analysis is used to find groups of observations that are similar to each other? regression association cluster observation Answers Explanation & Hints: A…

Why are different sampling techniques used to gather inferential statistical data? to reduce error and increase confidence in the generalizations about the findings to get accurate mean values to verify…

A data analyst wants to find data point values that are significantly different from others in a data set. What are these values called? outliers scatter plots cluster associations Answers…

Which three key pieces of information are required to perform a VLOOKUP function in Microsoft Excel? (Choose three.) the column number in the range that contains the return value the…

What can a data analyst do if they wanted to remove duplicate values in a Microsoft Excel spreadsheet? use VLOOKUP use conditional formatting parse the data from "text to column"…

How is the Microsoft Excel VLOOKUP tool used in data analysis? to summarize descriptive data sets to interpret inferential data sets to find specific information in a large spreadsheet to…

What are inferential data sets? They are data sets gathered from a representative sample to make generalizations or predictions about a population. They are data sets that describe the current…

In Microsoft Excel, what is a characteristic of an "absolute reference"? the reference changes depending on the relative position of the cell it is indicated by preceding a cell reference in…

What is the Microsoft Excel "LEN" function used for? it returns the number of characters in a text string in a cell it automatically adds the values in a given…

What is the name of the Microsoft Excel function in the formula "=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)"? MATCH INDEX $A2 $B2 Answers Explanation & Hints: The name of the function in the formula…

How is an active cell displayed in Microsoft Excel? a blinking border a flashing border a pointer arrow a wide dark border Answers Explanation & Hints: In Microsoft Excel, an…

What is the Microsoft Excel Data > Sort command used for? it sums up the values in a given column it filters out the values in all blank cells it is used to arrange…

What is the Microsoft Excel "CONCATENATE" function used for? it is used to combine the data from one or more columns into a single column it is used to combine…

What keyboard shortcut can be used in Microsoft Excel to select all the data? CTRL-V CTRL-A CTRL-C CTRL-P Answers Explanation & Hints: You can use the keyboard shortcut keys CTRL-A…

Which two methods are used to collect unstructured data for analysis? (Choose two.) querying a relational database using a web-scraping tool copying a spreadsheet obtaining data through an API downloading…

What are Web scrapping tools used for in big data analytics? to automatically extract data from HTML pages to provide standardized interfaces for data collection to store real-time data in its original…

Which two tasks are part of the transforming data process? (Choose two.) collecting data required to perform the analysis reviewing the data and addressing erroneous or missing values eliminating the…

What task is performed as part of the loading process in data preparation? transferring the data into a database providing values for missing data collecting and recording the data locating…