Data Science Fundamentals

What does the term "outlier" refer to in statistics?

• The mean of a dataset

• Unusual or extreme values in a dataset

• The mode of a dataset

• The standard deviation of a dataset

What is the purpose of the term "one-hot encoding" in machine learning?

• Handling missing values

• Scaling numerical features

• Encoding categorical variables into binary vectors

• Reducing dimensionality

What is the first step in the data science process?

The intersection of row and column is called as

• Row

• Column

• range

• Cell

What is a Pivot Table?

• A table containing data that is organized horizontally.

• A table containing only black, grey and white formatting

• A table used to calculate financial pivot values.

• A tool used to summarize data.

Which of these functions will you use if you wish to evaluate more than one condition?

• IF()

• IFELSE()

• IFS()

• IFELSES()

 

In the function =IF(SUM(B3:B6)>10, "Yes", "No"), which of the two functions will be evaluated first?

• IF function

• SUM function

What is the output of the function =if(A1=A2,"Unequal","Equal")

when A1=10 A2 = 11

• Equal

• Unequal

• Error

• None of these

Which of the following programming languages are most widely used by data scientists?

• • C and C++

• • Python, R and SQL

• • Java and JavaScript

Which of the following analytical and statistical techniques do data scientists commonly use?

• • Classification

• • Regression

• • Clustering

• • All of the above