We are analyzing how much the use of fertilizers affects the agricultural yield of the farmers.
Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()
A published solution is not available for this question yet.
You decided to perform analysis of the IPL teams year on year. You downloaded the teams
standings table which got downloaded as a PDF. You wish to convert to a csv file for further
analysis in Excel. The following method in ‘tabula’ can be used for the same:
A.
convert_into
B.
convert_file
C.
convert_all
D.
convert_csv
A published solution is not available for this question yet.
You decided to perform analysis of the IPL teams year on year. You downloaded the teams
standings table which got downloaded as a PDF. You wish to convert to a csv file for further
analysis in Excel, you realize that the team ‘Delhi Daredevil’ has changed its name to ‘Delhi Capital’.
Using excel, you wish to replace the old name with a new name. It can be done in Excel using
A.
Find and Replace
B.
Finding and Replacing
C.
Replace and Find
D.
Search and Replace
A published solution is not available for this question yet.
You developed a sudden interest in English Premier League. Post the TDS course, you wanted to
perform an analysis on all teams which played EPL from the year 1992. You performed PDF
scraping using ‘tabula’ and appended every year standings of teams one below the other and
saved as a single csv file. For looking at aggregating at various levels (viz Year wise, Team wise) the
following can be used in Excel:
A.
Pilot Table
B.
Pivot Table
C.
Pivol Table
D.
None of these
A published solution is not available for this question yet.
Assume you have data with a column “Direction” which takes the values “Left”, “Right”. If you had
used one hot encoding, the new columns added would be:
A.
Direction_Left, Direction_Right
B.
Left_Direction, Right_Direction
C.
Left-Direction, Right-Direction
D.
Direction-Left, Right-Direction
A published solution is not available for this question yet.
You decide to use keras to classify images into one of the following categories: cat, dog, bull.
Which of the following loss functions from Keras would you pick for the task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
mean_absolute_error
A published solution is not available for this question yet.
Identify which of the following statements is/are TRUE
1. A story contains a single view along with shelves, cards, legends, and the Data and Analytics
panes in its side bar.
2. A worksheet contains a sequence of stories that work together to convey information
3. A dashboard is a collection of views from multiple worksheets
A.
1 Only
B.
3 Only
C.
2 & 3 Only
D.
1 & 2 Only
A published solution is not available for this question yet.
The dataset consists of geographic, demographic information about countries and their respective
GDPs. You would like to visualize this data and study the relationship between the location of
countries and their GDPs. You decide to use Tableau to visualize the dataset. But you would also
like to generate a summary of the data. Choose the most suitable answer among the given
options.
A.
The summary can be generated using Quill and this is possible because Quill
can be used as an extension in Tableau.
B.
Tableau can be used for visualization. But Quill is incompatible with Tableau.
C.
Quill does not support generation of summary. Therefore using other
visualization tools such as Tableau would work.
D.
None of the options are appropriate for the generation of summary for the
given question.
A published solution is not available for this question yet.
We are interested in analyzing the effect of money spent on TV advertising on the sales volume of
a product. Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()
A published solution is not available for this question yet.
You are working on a piece of code that classifies different vehicles into its respective class (car,
LCV, truck, earth movers). Which of the following loss functions from Keras would you pick for the
task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
Mean_absolute_error
A published solution is not available for this question yet.
We are interested in fitting an ARIMA model to our time series data. Specifically, we are interested
in a moving average model of 0, setting a lag value of 4 for autoregression, and a difference order
of 1. Which of the following gives you such a model?
A.
ARIMA(..., trend = (4,1,0))
B.
ARIMA(..., order = (4,1,0))
C.
ARIMA(..., order = (0,4,1))
D.
ARIMA(..., trend = (0,4,1))
A published solution is not available for this question yet.
Scikit-learn has a DecisionTreeClassifier module that is useful in building decision tree classifiers.
Suppose, our dataset is imbalanced in class. Which feature in the DecisionTreeClassifier() will help
us tackle this problem?
A.
random_state
B.
min_sample_split
C.
class_balance
D.
class_weight
A published solution is not available for this question yet.
The given piece of code extract details of all Bollywood movies that were released in Jan – March
2009 and later prints out only those rows where the respective movie was categorized only as a
Drama. Identify which block of code executes without any errors.
A.B.C.D.
A published solution is not available for this question yet.
Provided below is an incomplete code snippet that enables you to compute distance between two
locations. Choose the most appropriate option that can be used in place of **< missing line >** to
compute the distance. Assume the coordinates of location one is stored in the variable “loc1” and
the coordinates of location 2 is stored in the variable “loc2”.
Provided below is a snippet of the code block of HTML tags from a website providing weather
forecast. Your goal is to scrape the high and low values for the 10-day temperature forecast.
A.B.C.D.
A published solution is not available for this question yet.
Provided below is a snapshot of the dataset which consists of movie reviews and respective labels.
To compute the sentiment scores the Azure Machine Learning add-in requires input and output
values. In the figure provided below the input and output cells need to be populated with
appropriate values to obtain sentiment scores.
Choose the most appropriate option that enables you to predict sentiment scores using the Excel
Azure Machine Learning add-in.
A.B.
A published solution is not available for this question yet.
scikit-network package contains functions for (pick all correct sentences):
A.
analysis of faults in a computer network
B.
social network analysis
C.
analysis of large graphs
D.
enhancing one’s social network
**BDM**
**Section Id :** 64065329421
**Section Number :** 5
**Section type :** Online
**Mandatory or Optional :** Mandatory
**Number of Questions :** 21
**Number of Questions to be attempted :** 21
**Section Marks :** 40
A published solution is not available for this question yet.